Entering content frame

Syntax documentation column_assignment Locate the document in its SAP Library structure

Syntax Rules for Column Descriptions

Syntax

<column_assignment> ::= <valCOLUMN_NAME> '<valLITERAL>'
| <valCOLUMN_NAME> <
generate_spec >

valCOLUMN_NAME

Column name
Specify this according to the SQL conventions. It can also contain the table name as a prefix (such as, customer.cno).

valLITERAL

Constant

Use

When you load application data, you can use this syntax rule to specify that a constant value is loaded into the specified column for each loaded data record, and which value this constant must have.

To do this, specify the constant in a position in the command. No data is then loaded from the data stream for the appropriate column.

Note

If the data stream is empty, the constants specified in the command are not loaded.

Loading Constants: <valCOLUMN_NAME> '<valLITERAL>'

To load any constant, enter the constant in a position. Place the value in single quotation marks.

The Loader handles the constant like a plain text value and converts it to the data type of the target column.

If you want to load the constant into a numeric column, it must have a valid numeric format.

Example

DATALOAD TABLE article
ano 01-08 CHAR
descr 09-39 CHAR
stock 40-43 INTEGER
min_ord '50'
ordered 46-49 INTEGER
delivery_date 50-57 CHAR
price 58-65 DECIMAL (2)
weight 66-69 REAL
INFILE 'customer.data' FORMATTED

Loading Special Constants: <valCOLUMN_NAME> <generate_spec >

You can load the special values STAMP, USER, USERGROUP, DATE, TIME, TIMESTAMP, and TRUE and FALSE.

Example

DATALOAD TABLE article
geaendert_von USER
geaendert_am DATE
geaendert_um TIME

ano 1
descr 2
stock 3 NULL IF POS 3 < '0'
INFILE 'customer.data'

 

Leaving content frame