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 db2 bind process?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Which component is responsible for processing sql statements and selecting access paths?
what is datacom db?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
How can record locking be achieved in those DB2 versions which do not support it?
How do I start db2 in windows?
What is the syntax for FETCH in DB2 ?
What is Call attach facility? How does it work?
What do you mean by between and in? Is between inclusive of specified range values?
What is db2 stogroup?