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,




Categories