Interested to Buy Any Domain ? << Click Here >> for more details...
What is the SQL Communications Area and what are some of
its key fields?
- 1 Answers
- 5101 Views
- I also Faced
- E-Mail Answers
Answer / s
SQL CA is a collection of variables that is updated after
the execution of an SQL statement.
SQLCODE - SQL return code indicates if the execution was
successful or not and no data found conditions.
SQLSTATE - SQL return codes that can be used to test
specific error conditions.
SQLERRD(3)-Contains the no. of rows updated/inserted/deleted
| Is This Answer Correct ? | 2 Yes | 0 No |
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.
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is an alias and how does it differ from a synonym?
What is the maximum No of rows per page?
What is the difference between nvl and coalesce?
What are the two types of logging in the db2 database? Explain them.
What db2 400?
In terms of DB2 indexing, what is the root page?
Is db2 a database?
Can SQL statements/queries be included in a copybook?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What are the contents of a dclmgen?
COBOL 
