I have a table with 50 records and if i try to access 100th record what will be the result.?(cobol-db2 program)

CoolInterview.com - World's Largest Collection of Interview Questions

Sponsored Links

Interview Questions

Our Services

Get 9,000 Interview Questions & Answers in an eBook.

9500+ Pages
9000 Question & Answers
All Tech. Categories

14 MB Content

Get it now !!

INTERVIEW QUESTIONS MAINFRAME DETAILS

Question :
I have a table with 50 records and if i try to access 100th record what will be the result.?(cobol-db2 program)

Posted by: Srikar on 8/19/2010

Contact Srikar

Category Mainframe Interview Questions

Rating (0.7) By 253 users

Added on 8/19/2010

Views 1372

Rate it!

Answers:

First the query will be executed successfully. But you get 2 sql return code. First 00 for successfull execution of the query. +100 for row not found since you are trying to access the row which is not found.

Posted by: satish

Contact satish

the above answer is correct. +100 sql code willappear

Posted by: k.sunil

Contact k.sunil

If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

Name :*

Email Id :*

Answer :*

Verification Code Not readable? Load New Code

  Enter the above shown code:*

Inform me about updated answers to this question



Related Questions View Answer

REDEFINE uses the same storage area. What about RENAMES? A variable that renames a group of other variables occupies different storage or same?? View Answer

suppose there are 5000 records ina flat file. how can we read files 2000 to 3000 using sort? View Answer

how can we read the last 1000 records of a file using some sort utility? View Answer

why do we use S9(4) comp to define the PARM length and not s9(4)comp-3? which is better? View Answer

what is the maximum no of characterts that can be passed thru PARM in jcl?
View Answer

What will the PDS utility do for TSO? View Answer

Is it a Mainframe Systems problem or a Network Systems problem? View Answer

What is IAM (Innovation Access Method) and why is it better than VSAM? View Answer

How do I know which archived data sets are about to expire? View Answer

What datasets are archived from disk and how long are they kept? View Answer

Where and how to use JCL process(premap and response map)? View Answer

what is the diff between dbrm.lib and loadlib what r they used for
View Answer

What is meant by impact analysis? View Answer

What are different types of process in jcl? View Answer

What is difference between oracle and sqlserver ? View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View ALL Mainframe Interview Questions