Generate text Output file with a Header and Details Format.
Load data to flat file from table. Hi all, I need to know how to copy data from a table say ABC to a flat file say XYZ.dat in unix, Please leave ur comments and the fastest way to do so, I need to load the table records into flat file.
You can upgrade it to a JOINT DATABASE TECHNOLOGY (JDT) format where the records in the flat file database (1 or more flat files) are persistently random access.
The conversion program reads each record in the flat file and maps the record data into each field of the interface table based on the text qualifiers and field delimiters specified in the flat file. All fields must be correctly formatted for the conversion program to correctly interpret each field and move it to the corresponding field in the appropriate inbound interface table.
I have planned to proceed by copying the data from ksds file to a temporary sequential file and concatenate with the flat file which contains the data unloaded from db2 table and sort them in ascending order. Then open the sortout file in output mode and write the records into the ksds file.
A common task that is performed using ODI is to export data from a flat file and load this data into another flat file. This tutorial walks you through the steps that are needed to create a project and an interface that will import a file to a staging area, perform some minor transformations, and then write the data to a file. You also execute the interface and verify the execution using ODI.
The flat file? Will it be fixed length for each data element? If so, you could also create a simple RPG program with an O Spec to write the records. Or if the data elements you are writing can be variable lenght (with some field delimiter) you could use SQL and just concatenate each field (with right trim function) with the delimiter, and then write (insert) the concatenated field to the flat.
Before inserting records into the file, move the values into the record buffer and then perform write verb. Write statement can be used with FROM option to directly write records from the working storage variables. From is an optional clause. If the access mode is sequential, then to write a record, the file must open in Output mode or Extend.