assume 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 2452in 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 2436I have File 1 occurs 5 times with Employee-ID,Employee-Name,Employee-Dept (EEE and MECH). I have File 2 occurs 10 times with Employee-ID,Employee-Name,Employee-Dept (EEE,CIVIL,CHEMICAL and MECH). In FIle 1 and FIle 2 , for matching Employee-DEPT (Only MECH) , we need to move entire records from file1 to file 2. We should not use 2D array. Your help is needed here.
1098Hi Guys, I have faced one interview question if I have requirement to add 5 new columns to existing table what are prerequisite do i need to take.
1 2105Difference between file status codes 02 and 22.... since both are for duplicate key detection.
1 2350How we will get issues on AS/400 technology ? I mean which issue/Defect Tracking tool is using in all companies when any issue comes? Can anybody explain about the work flow of AS/400 project ? plzzz
1144
What is the need of base registers in IBM 360/370?
How is the record format of an output dataset specified?
Explain the device independent method to indicate where a record is stored?
How to send a sms to a mobile through mainframe vm’s?
Explain the system transid cemt?
explain about maximum displacement and how to cross this limit?
what is the difference between call and ++call?
When output dataset space is required, what quantity categories are used?
Explain the difference between exec cics handle condtion and an exec cics ignore command?
What is the function of finish in idms?
What are the cics transactions?
In a CICS program, how will you read a VSAM file?
Explain the difference between various read and find statement and which one should be used when for better adabas performance?
Explain the hierarchy levels in jcl?
What is the syntax for creating a table in the db2 database?