If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
2048Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
2 5580i 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 14165what is main use of table space and index object? please its urgent
CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
5 16182What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
IBM,
3 18604Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
2 7352what is the difference between declaring the cursor in WS section and Procedure division?
HCL,
1 8452Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
9 14628COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
1 10189
What is runstats db2?
What is sqlca?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is the usage of open cursor command?
Define predicate?
What are the bind parameters ibm db2?
what is the responsibility of the construction superintendent
Give the name of some fields form sqlca.
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is a bind card?
What are catalog tables in db2?
What does runstats do in db2?
Mention the different locking levels that are available in db2.
Can you use max on a char column?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2