Interested to Buy Any Domain ? << Click Here >> for more details...
how to resolve -811
- 2 Answers
- 5648 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srini
Declare cursor instead of singleton select,as the query you
are running has multiple records.
| Is This Answer Correct ? | 3 Yes | 0 No |
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
How do I import data from excel to db2?
What is syscat in db2?
What is the difference between CS and RR isolation levels?
What is db2 command?
What is the significance of DB2 free space and what parameters control it?
What is the difference between static and dynamic SQL?
How many databases can be created inside an instance in db2 ?
what are stage one indexable predicates?
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 a bind in db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
COBOL 
