how do u update the faltfile into db2 table ?
Answers were Sorted based on User's Feedback
Answer / ankitha
flat file is loaded to table by LOAD utility. BUT
UPDATE with RRN value ,please any body elaborate
| Is This Answer Correct ? | 3 Yes | 2 No |
Also there is a option in FADB2 to load to table from flat
file using control card.
go to option 3.7
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sachin borase
Mass insert is possible using the load utility.
but need to write the program for update operation
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / selva ganesh s
Flat file can be updated by using RRN value.
| Is This Answer Correct ? | 1 Yes | 6 No |
How do you filter out the rows retrieved from a Db2 table ?
what are extents?
what is a corelated subquerry?
what is dynamic cursor?gives syntax for this?
What is FREEPAGE and PCTFREE in TABLESPACE creation?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
What is the difference between plan and package in db2?
What is a view? Why use it?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What does CURRENTDATA option in bind indicate
how do you resolve -805?
How to find primary key of a table in db2?