Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between dbm cfg and db cfg file in db2 ?
What are db2 objects?
How do you stop a db2 database in linux?
What is db2 plan table?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Which command is used to remove all rows from a table?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Give a brief description of db2 isolation levels?
What are foreign keys in db2?
How would you find out the total number of rows in a db2 table?
What is db2 purescale?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What action db2 takes when a program aborts in the middle of a transaction?
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 db2 connect?