ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
2063by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
4 9184i want apply mainframe devolper with 3+ but i dont have that much of knowledge what isthe solution to get that much of knoweldge?
1 4603when SE37 SB37 and sd37 occurs how to increase the volume , primary quantity and secondary quantity?
1 3965
Is db2 a mainframe database?
How to remove the spaces at end of each record in the output file Via COBOL program? note: The file has a VB length ----TRY
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?
suppose if you added a coloumn to db2 table, How would it be the Impact analysis?
What does "using" do?
Is automatic restart possible in jcl? If yes, how?
Define TCT.
How do I connect my db2 database to ibm?
Is their any limit for data sets?
What is meant by deadlock in db2?
What is an area sweep?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Explain foreign keys?
How can an in-stream dataset be terminated?
What is control interval?