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

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was

5 Answers   IBM,

What is meant by the attachment facility?

3 Answers  

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

how will you retrieve first record in table

1 Answers   UST,

Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 Answers  

What is image copy?

1 Answers   Virtusa,

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

Once you create a view, where would information about the view be stored?

1 Answers  

Return code 100 means?

6 Answers   Cap Gemini,

what is the input to PLAN? what is the input to DBRM?

4 Answers  

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,