Which DB2 Utility is used to declare Tables in cobol/DB2 programs
DCLGEN
SQLCA
SQLSTATE
SQLCODE
The performance of static SQL is better than dynamic SQL, because for static SQL the binding is done only once and the program can be executed many times
True
False
The SQL statement EXECUTE IMMEDIATE causes an SQL statement to prepare and execute, dynamically, at run time.
When using DISPLAY statement, on the system punch device, the last eight characters are used for
Line Number
PROGRAM-ID name
User ID
Nothing
ENTRY is
Entry will enter the main program and execute it.
Specifies the program entry.
It establishes an alternate entry point into a COBOL called subprogram.
ENTRY is not a COBOL keyword
What is EXIT PROGRAM?
Invalid Syntax
Specifies the end of a called program and returns control to the calling program.
Specifies the end of a called program.
Specifies the end of a calling program.
Why do ypu use INVOKE in COBOL?
To creates object instances of a COBOL or Java class or invokes a method defined in a COBOL or Java class
To creates object instances of a COBOL or ORACLE class or invokes a method defined in a COBOL or ORACLE class
To creates object instances of a COBOL or UNIX class or invokes a method defined in a COBOL or UNIX class
Maximum length of program name (compact mode) that can be specified in PROGRAM-ID is
8
10
20
30
RECURSIVE in PROGRAM-ID will
Loop the program
What is RECURSIVE?
Recursively reenters
Recursively reenters only for CICS program
What are the valid level numbers other than 66, 77 & 88?
1 to 99
1 to 50
1 to 49
1 to infinite