What is the purpose of the SDSNLOAD dataset in the STEPLIB
while running DB2 programs?
Answers were Sorted based on User's Feedback
Answer / guest
THE SDSNLOAD load library allows the batch job to access
the DB2 load modules.
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / siva
It is not mandatory that we should use SDSNLOAD. I hope, it
is only used to run DB2 utilities. Not required to run DB2
program through IKJEFT01
| Is This Answer Correct ? | 3 Yes | 9 No |
What is runstats utility in db2?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
what is the difference between normal select query and currosor
What is the maximum length of sqlca?
How to handle null values in db2
What does reorg do in db2?
What is dbrm library?
what are extents?
Explain what are the various isolation levels possible?
If I have a view which is a join of two or more tables, can this view be updatable?
How would you find out the total number of rows in a db2 table?
What is query for your birthday date should be in hours,minute and seconds format?