IBM MainFrame (5234)
IBM AS400 (1355)
IBM PL/1 (31) The disposition parameter in the jcl is share ( DISP+SHR ) and the program opens file in extend mode what will happen?
6 20396how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
IBM,
10 15060I have a Main Program which is calling Sub-Program which is a DB2 pgm. What will happen if I am not closing the cursor used in the Sub-program? Please advise..
3 11749i have 10 steps in jcl program but i have to exicute only 2,4,6,8th and 10th ?how it's possible?
IBM,
10 378931.what are the builtin funtions in cl pgg?Explain with example 2.what is meant by left outer join?where we can use this?
2 6846what is difference between accespath and datapath? what is the difference between accespath and open datapath?
2 105781.What is the difference between regular join logical file and non join logical file? 2.what are the nessasary keywords for non join logical file
ANZ,
3 15213
How can record locking be achieved in those DB2 versions which do not support it?
Receive consists of buffer option in it. What is the significance of this option?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
How to check last update on table in db2?
what is the purpose of data structure?
How do I connect my db2 database to ibm?
how a data in physical and symbolic map gets treated? Since the physical map is much concerned about the screen alignment and the field positions, how the values entered in the field which has PICIN or PICOUT clause in Physical map gets treated? Does that mean datas recieved or sent to the physical map should be constant? How does the data in Symbolic map gets converted with 5suffix namely F,L,A,I and O. For example EMPNO is treated as EMPNOI, EMPNOO, EMPNOA, EMPNOL and EMPNOF. how does this happen in symbolic map. Please provide your inputs on the above and kindly correct me if I am wrong.
How would you find out the total number of rows in a db2 table?
Explain the difference between search and searchall?
Why cursor is used in db2?
What is the difference between a binary search and a sequential search? What are the pertinent cobol commands?
what do you mean by recovery and speed parameters in define cluster command?
How many sections are there in data division in COBOL?
Explain package in db2 and its advantages?
What is a db2 tablespace?