Interested to Buy Any Domain ? << Click Here >> for more details...
what's the equivalent Cobol Data type for Decimal(x,y) in
DB2? what does the current SQLID register contain?
- 3 Answers
- 18355 Views
- Cap Gemini, Tech Mahindra, I also Faced
- E-Mail Answers
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 ? | 14 Yes | 0 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 |
What is the connection string to connect to the DB2 Database ?
What does it mean if the null indicator has -1, 0, -2?
What is the maximum number of columns in a db2 table?
What is scrollable cursor in db2?
how to resolve -805. give clear explination for that
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
Which command is used to remove all rows from a table?
How would one remove old reorg information from the DB2 catalog?
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
What is difference between isnull and coalesce?
What is the picture clause of the null indicator variable?
COBOL 
