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 |
Q4. How will you get the count of record without using COUNT verb in query?
How do I delete a table in db2?
How connect db2 database to datastage?
How to create db2 table in mainframe?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is meant by isolation level?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
what is the Foreign key? explain?
What is the maximum No of rows per page?
What is a lock?
Highlight all the advantages that are attached to a package.