RE: How generate a Multiformat Csv file tab delimeted

Quick spec... quick answer:
It sounds like you are doing an invoice header and detail extract.
Create a file on the ibm I with generic character columns.
Determine the maximum number of columns you need and call them column01,
coulmn02, .. columnNN
Then using SQL or RPG load the records in the order you need. Load the
columns based on whether header or detail data.
Then CPYTOIMPF/CPYTOSTMF from your generic file to a .csv.




-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of gio.cot
via RPG400-L
Sent: Saturday, May 24, 2025 4:39 PM
To: 'RPG programming on IBM i' <rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: gio.cot <gio.cot@xxxxxxxxxxx>
Subject: How generate a Multiformat Csv file tab delimeted

Hi All

I would need to generate a Multiformat Csv file tab delimeted (with RPG
or CLLE) ..

The CSV file have a record type (Ex. 01 Header 02 Details)

Ex.

Type record (01) customer code (0001 ) customer name (Acme Inc) invoice
number (12345) invoice date (2025/05/20)

Type record (02) Item number (AA01) item description (aaaaaaaa) item qty
(12,02)

Type record (02) Item number (BB01) item description (BBBBBBB) item qty
(33,20)



Any suggestions



Thanks in advance



Gio