SELECT INTO SQL SERVER AND SELECT INTO DB2
SQL SELECT INTO statement on mainframe differs from the way SELECT INTO SQL SERVER statement works.
The SELECT INTO on mainframe is used in a COBOL DB2 program, to store the contents of a table into host variables
Following example shows how SELECT INTO works in a cobol program
WHERE FIELD_NAME = :TABLE-NAME.FIELD-NAME
; ; ; ;
Here TABLE-NAME is the host variable copybook (the cobol declaration in the DCLGEN of the table TABLE_NAME)
TABLE_NAME is the name of the table
FIELD_NAME is the name of the field in the table
FIELD-NAME is host variable in DCLGEN TABLE-NAME
Note:- The SELECT INTO statement in a SQL server is used to take backups of tables.