Loading delimited data
//SYSREC DD DISP=SHR,DSN=USER.DATA
//SYSIN DD *
LOAD DATA RESUME NO REPLACE INDDN SYSREC
FORMAT DELIMITED
INTO TABLE NGT.TABLE1
//SYSIN DD *
LOAD DATA RESUME NO REPLACE INDDN SYSREC
FORMAT DELIMITED
INTO TABLE NGT.TABLE1
Data format example 1—Delimited file with delimited character strings
This example illustrates a delimited input file that uses delimited character strings. In this example, the column delimiter is a comma (,). Because the character strings contain the column delimiter character, you must delimit them with character string delimiters. The character string delimiter is a double quotation mark (″).
'009',"Delimited fields",",English"
'010',"Delimited fields" ,"Spanish"
'010',"Delimited fields" ,"Spanish"
Data format example 2—Delimited file with non-delimited character strings
This example illustrates a delimited file that uses non-delimited character strings. In this example, the column delimiter is a semicolon (;). Because the character strings do not contain the column delimiter character, they do not need to be delimited with character string delimiters.
009; Delimited fields;English
010;;Spanish
010;;Spanish
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*