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|
how to resolve -811 error. give clear explination
What is CHECK PENDING ?
how we will do null data selection in cobol-db2 program
what happend with out using Commit,when closing cursor and program?
What DB2 Catalog column tell you when an index needs table reorganized ?
What is usage pointer in cobol?
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?
What is RUNSTATS?
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
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?
my project is insurance management system,how to explain my work environment in interview?
what is check point and restart Logic ? why do we go for that ??