When the like statement is used?
No Answer is Posted For this Question
Be the First to Post Answer
What is sqlca?
What do you mean by between and in? Is between inclusive of specified range values?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is the difference between group by and order by?
What is declare cursor?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
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?
Explain the EXPLAIN statement?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
What do you do to keep the cursor from closing after a commit?