Interested to Buy Any Domain ? << Click Here >> for more details...
what is dynamic cursor?gives syntax for this?
- 1 Answers
- 5406 Views
- TCS, I also Faced
- E-Mail Answers
Answer / harsha
Working-Storage Section.
01 WS-FIELD.
49 WS-FIELD-TEXT PIC X(40).
49 WS-FIELD-LEN PIC S9(4) COMP.
PROCEDURE DIVISION.
MOVE +45 TO WS-FIELD-LEN.
MOVE 'UPDATE TAB1
SET ----=:----- WHERE ---=:----'
TO WS-FIELD-TEXT.
EXEC-SQL
EXECUTE IMMEDIATE:WS-FIELD
END-EXEC.
| Is This Answer Correct ? | 1 Yes | 0 No |
how to take the back up of the DB2 table.
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
What is buffer pool in the db2 database?
How to check last update on table in db2?
can all users have the privilage to use the sql statement select * (dml)?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What is the difference between cursor and select statement?
What is a predicate?
What's the maximum number of characters that a tablename can have?
Can you use max on a char column?
Describe major components of db2?
db2 restart logic ?
COBOL 
