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.