what's the equivalent Cobol Data type for Decimal(x,y) in
DB2? what does the current SQLID register contain?

Answers were Sorted based on User's Feedback

Answer / arun

cobol equivalent data type would be PIC s9(x-y)V9(y) comp3

Is This Answer Correct ?    12 Yes 0 No

Answer / sirisha

It is PIC 9(x-y)V9(y)

Is This Answer Correct ?    11 Yes 8 No

Answer / marekj

SQLID - current SQL authorization ID, and qualifier for
dynamic SQL if DYNAMICRULES(run) was set during BIND process.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More DB2 Interview Questions

What is image copy?

1 Answers   Virtusa,

what is the use of bind parameter, Replace?

5 Answers   IBM,

what is copy pending and check pending ?

1 Answers   Xansa,

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

0 Answers   HeadStrong,


4 Answers   Accenture,

Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?

2 Answers  

What is a view? Why use it?

3 Answers  

What is Call attach facility? How does it work?

1 Answers   Syntel,

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

what is different three logs in DB2?

1 Answers   Syntel,

What is the purpose of the WHENEVER statement?

1 Answers  

When Can you be sure that a query will return only one row?

4 Answers