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.