Interested to Buy Any Domain ? << Click Here >> for more details...
How to define the data items to receive the fetch items for
the SQL?
- 2 Answers
- 5956 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mehdee
Example:
EXEC SQL
FETCH AA_CURS
INTO :Host-name1, Host-name2, ...
EXEC-END
Note: Host-names listed are one to one related to the
Columns at DECLARE AA_CURS, and are INCLUDEed from it's
DB2 DECLGEN name in the program.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sadiq afroze
Using the DSECT, followed by lines of - 'data items DS
datatype'.
| Is This Answer Correct ? | 0 Yes | 2 No |
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
When is the authorization check on DB2 objects done - at BIND time or run time?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
What is page size in db2?
How we create a tables in db2,what is the process/syntax to create a table with example plz?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
What is bind and rebind in db2?
How do I connect my db2 database to ibm?
What is a subselect? Is it different from a nested select?
Which command is used to connect to a database in DB2 ? Give the Syntax.
How to define the data items to receive the fetch items for the SQL?
COBOL 
