what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does

what's the equivalent Cobol Data type for Decimal(x,y) in
DB2? what does the current SQLID register contain?

Question Posted / guest

3 Answers
17259 Views
Cap Gemini, Tech Mahindra, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID re..

Answer / arun

cobol equivalent data type would be PIC s9(x-y)V9(y) comp3

Is This Answer Correct ?

14 Yes

0 No

what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID re..

Answer / sirisha

It is PIC 9(x-y)V9(y)

Is This Answer Correct ?

12 Yes

8 No

what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID re..

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 fetch multiple records without using cursor

14 Answers HCL,

1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers

What is SPUFI?

4 Answers

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers

How to resolve -504 sql code in DB2?

2 Answers Cap Gemini,

Compare a subselect to a join?

1 Answers

can we view the access paths created by dbrm ? how ? thx

2 Answers IBM,

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?