SQL - Structured Query Language - Tabela utilizada nos exemplos


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

TABELA01 - Tabela utilizada nos exemplos
   
 000001       ******************************************************************
 000002       * DCLGEN TABLE(DCL.TABELA01_CONTA)                               *
 000003       *        LIBRARY(DES.DCL.V00.DCLGEN(TABELA01))                   *
 000004       *        ACTION(REPLACE)                                         *
 000005       *        LANGUAGE(COBOL)                                         *
 000006       *        STRUCTURE(TABELA01)                                     *
 000007       *        APOST                                                   *
 000008       * ... IS THE DCLGEN COMMAND THAT MADE THE FOLLOWING STATEMENTS   *
 000009       ******************************************************************
 000010            EXEC SQL DECLARE DCL.TABELA01_CONTA TABLE                  
 000011            ( NU_CONTA                       SMALLINT NOT NULL,          
 000012              NO_NOME                        CHAR(40) NOT NULL,          
 000013              TS_INI_VG_CONTA                TIMESTAMP NOT NULL,         
 000014              NO_ENDERECO                    CHAR(70) NOT NULL,          
 000015              NO_CIDADE                      CHAR(50)                   
 000016            ) END-EXEC.                                                  
 000017       ******************************************************************
 000018       * COBOL DECLARATION FOR TABLE DCL.TABELA01_CONTA                 *
 000019       ******************************************************************
 000020        01  EMPTB002.                                                    
 000021            10 NU-CONTA             PIC S9(4) USAGE COMP.                
 000022            10 NO-NOME              PIC X(40).                
 000023            10 TS-INI-VG-CONTA      PIC X(26).                           
 000024            10 NO-ENDERECO          PIC X(70).                           
 000025            10 NO-CIDADE            PIC X(50).                          
 000026       ******************************************************************
 000027       * THE NUMBER OF COLUMNS DESCRIBED BY THIS DECLARATION IS 5       *
 000028       ******************************************************************