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 ? | 14 Yes | 0 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 |
What is the meaning of -805 SQL return code?
What is null value in db2?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
When do you use the IMAGECOPY?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
How does a cursor work?
wht displays the number of times a query modified ?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
How to handle null values in db2
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
what is the input to PLAN? what is the input to DBRM?