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



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

Answer / arun

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

Is This Answer Correct ?    14 Yes 0 No

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

Answer / sirisha

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

Is This Answer Correct ?    12 Yes 8 No

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

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

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,


How do I delete a table in db2?

0 Answers  


What is iseries database?

0 Answers  


Which command is used to remove all rows from a table?

0 Answers  


What is an intent lock?

3 Answers  






When the like statement is used?

0 Answers  


Who uses db2?

0 Answers  


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

0 Answers  


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers  


What do you need to do before you do EXPLAIN ?

1 Answers  


Where are plans stored?

2 Answers  


How can you classify the locks in db2?

0 Answers  


Categories