Interested to Buy Any Domain ? << Click Here >> for more details...
What is the SQL Communications Area and what are some of
its key fields?
- 1 Answers
- 4918 Views
- I also Faced
- E-Mail Answers
Answer / s
SQL CA is a collection of variables that is updated after
the execution of an SQL statement.
SQLCODE - SQL return code indicates if the execution was
successful or not and no data found conditions.
SQLSTATE - SQL return codes that can be used to test
specific error conditions.
SQLERRD(3)-Contains the no. of rows updated/inserted/deleted
| Is This Answer Correct ? | 2 Yes | 0 No |
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
what are the bind parameters?
How does DB2 store NULL physically?
What is precompiler in db2?
How can you display the current date & current time ?
What is the purpose of the WHENEVER statement?
How to update more then one record using update?
What is cursor with hold option in db2?
What is meant by explain?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
COBOL 
