I know my query will return more than one row but I don't want cursor what should I do?
Answer / secret service
Add FETCH FIRST 1 ROW ONLY to your query.
|Is This Answer Correct ?||0 Yes||0 No|
where do u use low-value and high value in cobol
How To move a value to an array using move verb?
How is sign stored in Packed Decimal fields and Zoned Decimal fields?
how we rectify soc7 and soc4 errors in project?
what is ASRA, AEY9?
Following questions were asked in Capegemini on 8th sep,2012 mainframe test 1.)Condition code for dul recors in VSAM- 2.) Is NULL or =NULL in Select statement 3.)max size of CI 4.)What happens after CI is full 5.)Ques on COND parameter 6.)which among following can not be rolled back a)delete table b.)droptable c)Update d.)insert 7.)groupby and orderby sql querries 8.)Max extents in VSAM file 9.)quesn on DPRTY=(1,10) 10.)range of condition codes in COBOL 11.)occurs clase can not be used at which level? 12.)delimiter in jcl 13.)sort card for file in PGM=SORT 14.)PIC(6) value 120056 possible? 15)question on BLKSIZE Is (20,20) and (20,10) possible? 16.)number of bytes in RDF 17.)Can we use index in WS-section or LK-section 18.)Verify command in IDCAMS used for? 19.)question on Alternate Index 20.)Return code of file attribute mismatch 21.)In which format COBOL variables stored? 22.)what is Alternate of HANDLE? 23.)can SUM,AVG,MIN,ROUND used in numeric and char variable data types? 24.)What is the datatype of FILE STATUS codes in WS-section?
Minimum how many Number of Paragraphs are there in ID- Divison?
s9(18) comp-3:: What is the size of memory it takes internally?
What is 77 level used for ?
) what is the difference between AID and HANDLE AID?
What should be the sorting order for SEARCH ALL?
I have a occurs for 100 times but it has executed 101 time what could be the reason?