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  




Categories