Where do you define your data in a program if the data is passed to the program from a Caller program?

July 3, 2012

Linkage Section

Cobol Comments Off

What is the default, passing BY REFERENCE or passing BY CONTENT or passing BY VALUE?

July 3, 2012

Passing by reference (the caller and the called share the same memory).

Cobol Comments Off

What does passing BY CONTENT mean?

July 3, 2012

The calling program passes only the contents of the literal, or identifier. With a CALL . . . BY CONTENT, the called program cannot change the value of the literal or identifier in the calling program, even if it modifies the variable in which it received the literal or identifier.

Cobol Comments Off

Name the divisions in a COBOL program ?

July 3, 2012

IDENTIFICATION DIVISION, ENVIRONMENT DIVISION, DATA DIVISION, PROCEDURE DIVISION.

Cobol Comments Off

what’s the error code for Unique Index Voilation:

June 25, 2012

-803

DB2 Comments Off

what’s the best locksize that you could use when you create a tablespace?

June 25, 2012

The answer is Locksize = ANY.Unless you are Sure what’s the Purpose of tablespace ie.,Read-only or R/W.If you use lock size =any, Db2 would automatically determine what type of locks it should use.

DB2 Comments Off

What is the size of a data page?

June 25, 2012

4K to 8K

DB2 Comments Off

The only place of VSAM KSDS in DB2 is?

June 25, 2012

BSDS is a VSAM KSDS.

DB2 Comments Off

MAX. NO OF ROWS PER PAGE

June 25, 2012

127

DB2 Comments Off

What is EXPLAIN in DB2

June 25, 2012

EXPLAIN is used to detail the access paths chosen by DB2 optimizer for SQL statement. This command is used to monitor the performance of SQL statement used in a program.
Answer: BIND mainly performs two things syntax checking and authorization checking.It binds together all packages into an application plan hence the name BIND.Apart from this bind has optimiser as a subcomponent.Its function is to determine the optimum access strategy.

DB2 Comments Off