How to read the 2nd last record of a VSAM file? (The file size is huge and we don't know the key)
HCL,
3328In 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?
2050While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
2391I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
1 2618assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
TCS,
1 3294in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
TCS,
1 3289
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Does jcl support automatic restart?
What is the difference between version control and debugging tools?
Discuss about db2 bind?
INCLUDE is used ONLY on MVS/ESA Version 4 or higher systems to name an INCLUDE group. An INCLUDE group is a set of one or more valid JCL statements that are stored together in a JCLLIB data set or a system procedure library, and that are read in and used to replace the INCLUDE statement itself within the job. Any number of INCLUDE statements can be used in a job, but the name field value used on each should be unique within the job. The INCLUDE statements can appear in a job anywhere after the JOB statement, but may not appear between a CNTL and ENDCNTL JCL statement.
how we sort two input files based on a common column and giving one o/p file please send me the coding logic?
what are s0c1, s0c4, s0c5, s0c7 abends?
What is the difference between dbm cfg and db cfg file in db2 ?
Differentiate between addressing mode and run mode.
What is linkage section?
) what is the difference between AID and HANDLE AID?
What is meant by bmp mode?
Explain about find and obtain commands?
Explain host variables?
What is rmode(24)