priya

EXEC SQL DECLARE TABLE statement which gives the layout of the table in terms of DB2 data type. A host language copy book that gives the host variable definitions for the column name. In IBM Db2, a DCLMGEN is not a standard or commonly recognized term. It’s possible that there might be a typo or … Read more

DCLGEN is stands for DeCLarations GENErator. It is used to create the host language copy books for the table definitions. It also creates the DECLARE table. In the context of IBM Db2, DCLGEN stands for “Data Control Language Generator.” It is a utility used to generate Data Control Language (DCL) statements for embedding in application … Read more

DATE: PIC X(10) TIME PIC X(08) TIMESTAMP PIC X(26) In COBOL, the PICTURE clause is used to define the format of data items. For DB2 data types DATE, TIME, and TIMESTAMP, you would typically use the following PICTURE clauses: DATE: PICTURE: 9(8) Example: 01 WS-DATE-DB2 PIC 9(8). TIME: PICTURE: 9(6) Example: 01 WS-TIME-DB2 PIC 9(6). … Read more

If you use the OPEN CURSOR command with ORDER BY clause, the rows are fetched, sorted and made available for the FETCH statement. Otherwise simply the cursor is placed on the first row. In the context of DB2, the OPEN CURSOR command is used to prepare a cursor for processing. When you issue the OPEN … Read more

There are three reasons for not using SELECT * in embedded SQL programs: If you change the table structure i.e. adding a field, the program will have to be modified. Program can retrieve the columns which it might not use, leading an I/O overhead. The chance of an index only scan is lost. In Embedded … Read more