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 |
Which one allows duplicate values Union or Union All ?
What is check constraint in db2?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What does reorg do in db2?
What is host variable in db2 cobol?
What is a result table?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is the use of reorg in db2?
How do I delete a column in db2?
What is the meaning concurrency in the db2 database?
What is tablespace?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).