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 a predicate?
What is temporal table in db2?
What is the purpose of the WHENEVER statement?
Mention and explain the contention situations caused by locks?
How do I delete a table in database?
What is sqlca’s maximum length?
What is dclgen in db2?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
How can you split a table in to exactly half?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
what happend with out using Commit,when closing cursor and program?
What is rct?