Interested to Buy Any Domain ? << Click Here >> for more details...
where will u check for sqlcode ?
- 2 Answers
- 7600 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shaan
Be sure to include sqlca in working storage section.
Then you can check sqlcode from the copybook variable SQLCODE.
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / guru
If you dont include SQLCA, Define SQLCODE and SQLSTATE as
working storage variables and This will suffice
| Is This Answer Correct ? | 2 Yes | 0 No |
What are the various data types available in db2?
What is the use of dclgen in db2?
What will the DB2 optimizer do?
What is filter factor?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
How to rename a table in DB2 ?
how to unload different table data into different gdg files/ vsam files.
When will you chose to run RUNSTATS?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
What is a composite index and how does it differ from a multiple index?
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
COBOL 
