Loading delimited data

The following examples illustrate how to use BMC AMI Load to load delimited data. 

Important

For the assumptions made in this example, see Assumptions made in the syntax examples.

This example uses the same LOAD statement syntax as the example for emptying a table space, but loads delimited data instead of a dummy data set. 

Related topics

SYSREC

SYSIN 

//SYSREC    DD DISP=SHR,DSN=USER.DATA
//SYSIN     DD *
  LOAD DATA RESUME NO REPLACE INDDN SYSREC
  FORMAT DELIMITED
  INTO TABLE NGT.TABLE1

Important

In addition, in the following examples:

  • Leading blanks that are not delimited create white space and are not part of the target field.
  • Code omitted fields as two consecutive column delimiters, as shown in the second field of the second input record of the second example.
  • BMC AMI Load loads null or default values for omitted fields.

  • The characteristics of fields coded as two consecutive character delimiters depends on the target field, as described in the following table:

    Target field

    Result

    Varying

    0 length

    Fixed character

    Blanks

    Numeric, date, or time

    Generates an error

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"

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


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*