Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
4 9077Suppose i have a Cobol field of 10 byte. it contains a decimal sign.How to know where is the point location?
1 5877Suppose 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?
2 8279i have 10 steps in my jcl. -->if i want to execute my program from 5th step what i have to do? don't give //* in ur previous steps --> if i want to execute my program from 1to 5 steps only what i have to do?
2 6717I have a PS file and I would like to manually insert the binary values (like a COMP format) into the file. How can i do that? the way do in COMP-3 format.. suppose i want to insert -12345 in to file in comp-3 format. simply we can open a file in edit mode and do HEX-ON and insert the value . SEE BELOW-- 135 24D in 3 bytes - this will be COMP-3 presenatation of -12345.
1 6789I have a File that has duplicate records. I need only those records that occur more than thrice.?
3 9877in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
IBM,
2 6268In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)
2 8788Hi All, In a Cobol-DB2 program, I am fetching rows from 4 tables using cursor and then based on the a field present in that table, It processes the information accordingly..for example stat-c is one digit field..if stat-c is 'D' then the a row is deleted from table and written those details in to a file. If the stat-c is 'U' then a row is updated (hardcoded what to update)in a table and written those details in to a file. If the stat-c is 'I' then a row is inserted in a table and written those details in to two files. The issue is i have to include the intermediate commits. When an abend occurs, due to commit statement db2 tables will be saved, But there will be lose of file contents. When we resubmitting the job associated with this program there will be insert ,update and delete anomolies to avoid that what measures could be taken?. The intermediate commit is nothing but issuing commit after massive inserts, updates and deletes(sum of 500actions)
1 5574what type of version is we r using now real time in all modules(cobol, jcl, cics, db2, vsam)?
1 3819
Explain about house keeping in assembler?
Have you used comp and comp-3 in your project? And how?
is oorexx compatible with rexx?
In the house keeping section of an MVS assembly language program, like the one below STM R14,R12,12(R13) BASR R12,R0 USING *,R12,R11 LA R11,2048 LA R11,2048(R11,R12) .... .... 1. What if BASR R12,R0 IS NOT PRECEDE USING *,R12,R11? 2. USING (base address), REGISTER does USING directive says assembler to treat particular Register as a base register with the mentioned base address..in the above case * i.e current location counter..well if that is the case why we need BASR R12,R0 ? 3. What if I write like STM R14,R12,12(R13) BASR R12,R0 LA R11,2048 LA R11,2048(R11,R12) USING *,R12,R11 there is no address resolution being calculated in both LA statements so is it a right way to set Base register?..will there be any issues with Domain regarding R11 and R12?
How can the attributes of one sms dataset be copied to another dataset?
what is the purpose of the verify function of idcams?
i want to store 20 digits . how will u do it in cobol ?
Many jcl statements contain specific values designed to direct and control the execution of the statement. What are these fields called?
Explain the logical message in cics?
Explain how are you going to remove duplicates from the file that is being read?
What are the uses of commit and finish?
How do u write test cases?
how do we prepare test data using file-aid tool?
Explain how can a stopped job be started again?
What is the difference between read work file 1 and read work file once? Why we are using work file once?
