INSPECT TALLYING FOR ALL IDENTIFIER The following COBOL program depicts the use of INSPECT TALLYING FOR ALL IDENTIFIER     01 TEST-STRING  PIC X(40) VALUE SPACES.     01 WS-COUNTER   PIC 9(9)  VALUE ZEROES.     01 SEARCH-STRING PIC X(2)  VALUE SPACES.        MOVE ‘USE […]
INSPECT TALLYING FOR ALL IDENTIFIER Read More »
Relation between Plan, Packages and collection Can someone be kind enough to explain the relation between plan, packages and collections? I thin plan is a group of packages and DBRMS while Package has one DBRM each. But where does collection come into picture? “; ; ; ;
Relation between Plan, Packages and collection Read More »
S0C7 on Moving alphanumeric data to COMP-3 I get confused, when a question about COMP-3 and its relation I have heard lot of people saying moving alphanumeric data to COMP-3 would Can someone let me know if its true or not? I tried the sample code and it worked fine for me without any S0C7
S0C7 on Moving alphanumeric data to COMP-3 Read More »
STRING DELIMITED WITH POINTER The following COBOL program depicts the use of STRING DELIMITED WITH POINTER     01 WS-STRING1   PIC X(18) VALUE SPACES.     01 WS-STRING2   PIC X(18) VALUE SPACES.     01 START-POS   PIC 9(3)  VALUE ZEROS.     ** USING STRING DELIMTED BY THE
STRING DELIMITED WITH POINTER Read More »
SQL code of -904 is unsucessful execution of a DB2 query due to an unavailable resource. The name, type of resource unavailable and the reason is also provided by DB2. When does Sql code -904 comes? Sqlcode -904 can come if the sql statement tries to query a resource which is unavailable at the time
The following COBOL program depicts the use of     01 WS-SUB  PIC 9  VALUE ZEROS.        PERFORM 20000-FIRST-PARA VARYING WS-SUB FROM 1 BY 1 UNTIL        DISPLAY ‘PARA NAME IS  10000-FIRST-PARA’        DISPLAY ‘VALUE OF WS-SUB IS
COBOL PERFORM VARYING UNTIL Read More »
Difference Between Catalog and Instream Procs CATALOG PROC INSTREAM PROC 1) Catalog procs are members of proclib.                               2) PROC statement is optional  for catalog procs.               3) PEND cannot appear in a  catalog proc.                         4) EXEC statement using PROC can be coded anywhere in the JCL after JOB statement.    1) Instream proc
Difference Between Catalog and Instream Procs Read More »
Creating Primary Key while creating DB2 Table How to define a Primary Key while creating a DB2 table? Generally when we create a DB2 table, we create the primary key using the same query. You can use the following query to do this. Table_Name is the name of the table Column_One and Column_two are the
Creating Primary Key while creating DB2 Table Read More »
How to View the RCT entry for a CICS trx Can some one tell me the command to view the RCT entry for a CICS transaction? A new CICS DB2 program has been installed into and I have refreshed the CICS loads by getting the region down and up. But the there seems to be
How to View the RCT entry for a CICS trx Read More »
