INTO

The INTO option defines the output record.

Related topics

Control-statements-for-SAS-processing

SELECT-options

INTO.png

You can omit the INTO option entirely for a simple unload, in which case UNLOAD PLUS uses the default field data type, format, and length for all selected items.

See limitations and restrictions for SmartSwitch support of this feature.

record options

The following options allow you to specify output record identification information.

For more information about generating and inserting additional syntax into utility control statements, see Inserting-additional-command-options-into-utility-control-statements.

NAME

The NAME option allows you to override the default table name or file that UNLOAD PLUS generates from the control statements. When using DIRECT YES, the default name is the name of the table being unloaded. When using DIRECT NO, the default name is the userID.$TABLEn. To generate control statements with a name different from the default name, specify NAME ownerName.tableName.

Restriction

UNLOAD PLUS does not support Unicode table names.


NAME option actions based on CNTLCARDS option

CNTLCARDS option

NAME option action

CNTLCARDS DB2LOAD (the default for CNTLCARDS)

CNTLCARDS BMCLOAD

CNTLCARDS DB2

Sets the Db2 table name that UNLOAD PLUS generates in the LOAD utility, LOADPLUS control statements, or CREATE DDL statements, respectively

CNTLCARDS EASYTRIEVE

Sets the file name that UNLOAD PLUS generates for Easytrieve

If you specify CNTLCARDS EASYTRIEVE, the NAME option does not affect the file name that UNLOAD PLUS generates as Easytrieve input.

CNTLCARDS FOCUS

Sets the file name that UNLOAD PLUS generates for the FOCUS external file definition statement

CNTLCARDS SAS

Sets the file name that UNLOAD PLUS generates for the SAS INFILE

If you specify CNTLCARDS SAS, the NAME option does not affect the file name that UNLOAD PLUS generates as SAS input.

CNTLCARDS SQL/DS

CNTLCARDS SQL/DS-LOAD

CNTLCARDS SQL/DS-DDL

Sets the SQL/DS table name that UNLOAD PLUS generates in the DATA LOAD utility control statements, or CREATE DDL statements, respectively

CNTLCARDS TERADATA

Sets the table name that UNLOAD PLUS generates in the load utility control statements

CNTLCARDS NOMAD

Sets the file name that UNLOAD PLUS generates for the MASTER NOMAD INFILE

If you specify a two-part name, UNLOAD PLUS uses the second part for the master name. If you do not specify a name, you can use a comma as a placeholder.

'string'

This option allows you to insert additional load syntax to follow the INTO option for the IBM Db2 LOAD or the BMC LOADPLUS generated utility control statements when you specify CNTLCARDS DB2LOAD, CNTLCARDS DB2, or CNTLCARDS BMCLOAD. You can specify multiple strings of up to 72 bytes each. Enclose each string in single quotes. To embed a quoted string (a string enclosed by single quotation marks) within a string, add a single quotation mark before and after the quoted string. The following examples show the use of this option:

INTO 'PART 2:4 REPLACE'
INTO 'REPLACE WHEN EMPLDATE > ''2005-01-01'''

When loading system-period temporal objects, you might need to add syntax to the load statements that UNLOAD PLUS generates. You can either add the syntax as a string on the UNLOAD PLUS INTO option, or you can modify the load control cards that UNLOAD PLUS generated before you run the load job. The following table describes which strings to add for which conditions:


Strings to add to INTO statement for temporal objects

Condition

String

You specify FORMAT BMCLOAD.

'PERIODOVERRIDE TRANSIDOVERRIDE'

You want to load input file data into a system-period begin or end column

'PERIODOVERRIDE'

You want to load input file data into a transaction-start-ID column

'TRANSIDOVERRIDE'

RECORDID 'string'

You can use the RECORDID option to specify a value for a record identifier. The RECORDID is a character string constant that can be up to 72 bytes long, and is placed at the front of each output record for the SELECT statement.

Restrictions

Note the following restrictions when specifying the RECORDID option:

  • If you also specify FORMAT BMCLOAD, UNLOAD PLUS terminates.
  • If you also specify FORMAT XML, UNLOAD PLUS ignores the RECORDID option.

Additional considerations

The following considerations apply to the RECORDID option:

  • If UNLOAD PLUS generates CNTLCARDS for Db2 or DB2LOAD, the utility generates appropriate WHEN syntax for the Db2 load control statements.
  • If you also specify AUTOTAG YES, UNLOAD PLUS ignores the AUTOTAG option for that SELECT statement.

field specification

The field specification defines the fields of the output record. See field-specification for a complete description, including restrictions.

 

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