What are the contents of dclgen?
No Answer is Posted For this Question
Be the First to Post Answer
Is db2 a database?
wt is view ? wht r the restrictions for view ?
What is -904 sql code? How to resolve it?
When DB2 connection fails, will online program work or give errors.
What is Call attach facility? How does it work?
What is dbrm in db2 database?
What is the format (internal layout) of ?TIMESTAMP??
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.
If I have a view which is a join of two or more tables, can this view be updateable?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
Why cursor is used in db2?
How to execute stored procedure in db2 command editor?