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
2124by 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 9374i want apply mainframe devolper with 3+ but i dont have that much of knowledge what isthe solution to get that much of knoweldge?
1 4676when SE37 SB37 and sd37 occurs how to increase the volume , primary quantity and secondary quantity?
1 4058
What are the advantages of vsam over isam?
What is dbrm library?
how to retrieve the instream data in sysin?
What is a storage group (stogroup)?
How can i load all the data from a file to Table (array) in cobol.How i manage the occurs clause with out reading the file.Any options avilable ? Please can any one help me it is urgent?
How do you find the maximum value in a column in db2?
What is cascading rollback?
What is a set? What pointers are required, what are possible? How may sets be ordered?
What are the uses of db2 optimizer?
What statement marks the beginning of an in-stream or cataloged procedure in jcl and assigns default values to parameters defined in the procedure?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Explain the difference between link and xctl?
What is the output of the following command given in tso/ispf terminal?
how do you reference the variable unblock file formats from cobol programs