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 execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,

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?

7 Answers   IBM,

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?

3 Answers  

why we create view.

5 Answers  

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

How many clustering indexes can be defined for a table?

2 Answers  

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  

What is a DB2 catalog?

2 Answers  

What is lock escalation?

2 Answers  

How would you print the output of an SQL statement from SPUFI?

2 Answers  

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

1 Answers