-
-811 abend
when will occur -811 abend? how will u resolve the -811 abend?
-
SOC7 Abend
how can u resolve soc7 abend? how do you know the cause for soc7 abend? how do you findout. where soc7 abend occurs?
-
Bind Parameters
What are the important bind parameters to be used in bind card? What is the significance of each parameter?
-
Protected Fields
Can we update the Protected field in the MAP? If Yes, How?
-
what is the batch job and online job?
Explain the difference between batch and online job
-
-
dynamic cursor positioning
in dynamic cursor positioning, what happens if i move +1 to field+l instead of -1 to field+l?????
-
-
-
-
-
-
What is the difference between IN subselects and EXISTS subselect?
If there is an index on the attributes tested an IN is more efficient since DB2 uses the index for the IN. (IN for index is the mnemonic).
-
What is SPUFI?
SPUFI stands for SQL processing using file input. It is the DB2 interactive menu-driven tool used by developers to create database objects.
-
What is a DB2 access path?
An access path is the method used to access data specified in DB2 sql statements.
-
Explain the difference between an internal and an external sort, the pros and cons, internal sort syntax etc?
An external sort is not COBOL; it is performed through JCL and PGM=SORT. It is understandable without any code reference. An internal sort can use two different syntaxes: 1.) USING, GIVING sorts are comparable to external sorts with no extra file processing; 2) INPUT PROCEDURE, OUTPUT PROCEDURE sorts allow for data manipulation before and/or after the sort.