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 execute qcmdexc in rpgle?plz write code also?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
why we create view.
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
What is a Resource Control Table(RCT)? Describe its characteristics.
How many clustering indexes can be defined for a table?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
What is a DB2 catalog?
What is lock escalation?
How would you print the output of an SQL statement from SPUFI?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?