Home > IT Answers > Database > Flat files
Askt
265 pts.
 Flat files
Flat files, RPG data conversion, RPG/400
I have a data in data strucure then after i need to create flat files in txt format. please suggest me how can i proceed.

Software/Hardware used:
ASKED: November 25, 2008  12:51 PM
UPDATED: November 26, 2008  2:32 PM
RELATED QUESTIONS
Answer Wiki:
Hi, Are you using RPG for this or something else? Regards, Martin Gilbert. When you say it's in a data structure - it sounds like it's in RPG ??? Are all the elements of the structure character??? Do you need your text file on the 400 or are you sending it somewhere/somehow? Phil
Last Wiki Answer Submitted:  November 25, 2008  1:58 pm  by  Gilly400   23,625 pts.
All Answer Wiki Contributors:  Gilly400   23,625 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

yes RPGILE

Askt
 265 pts.
 

Hi,

Define your flat file as externally defined in your RPG – you may have to use RENAME to rename the record format if the format name is the same as the file name. Then you should be able to move your data structure to the field in the flat file (the flat file normally has one field which occupies the whole length of the record) and write the record to the flat file.

Regards,

Martin Gilbert.

Gilly400
 23,625 pts.
 

we have a task to add delimeter in flat file. can we add this to flat files if yes please suggest me
how it is.

Askt
 265 pts.
 

Hi,

What sort of delimiter and where does it need to be?

Regards,

Martin Gilbert.

Gilly400
 23,625 pts.
 

i want to use delimeter to split each column field record as below

name|address|

please suggest me how can i.

Askt
 265 pts.
 

You could create a 1 char field between each data field in the data structurre and populate them with the pipe ‘|’.

philpl1jb
 44,200 pts.