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 get Top 10 Salaries from a Table
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
What is meant by the attachment facility?
What if we fail to give values in columns declared as NOT NULL ?
how will you retrieve first record in table
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What is image copy?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
Once you create a view, where would information about the view be stored?
Return code 100 means?
what is the input to PLAN? what is the input to DBRM?
how to resolve -811 sqlcode .give clear explaination