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 resolve -811 error. give clear explination

4 Answers   IBM,


What is CHECK PENDING ?

4 Answers  


how we will do null data selection in cobol-db2 program

2 Answers   Wipro,


what happend with out using Commit,when closing cursor and program?

5 Answers   CSC,


What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  


What is usage pointer in cobol?

2 Answers   IBM,


can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  


What is RUNSTATS?

3 Answers  


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

3 Answers   Cap Gemini, Tech Mahindra,


I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,


my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,


what is check point and restart Logic ? why do we go for that ??

2 Answers   UST, CGI, Xansa,




Categories