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 |
What is read-only cursor?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is the STOSPACE Utility used for?
What will happen, while trying to close the closed cursor.
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
cursor with hold explain ?
What is an access path?
how to resolve -805 . how to see dbrm and package not found
What is dbrm in db2 database?
What is the difference between spufi and qmf?
What are the contents of dclgen?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?