RE: IFS to Integrated Server

["Bob Cozzi" <cozzi@xxxxxxxxx>]

Steve,
Normally you use the CpyToCSVIFS() to copy all or part of a file to the IFS
in CSV format. The individual csvOpen, csvWrite procedures are used for more
granular control.

The all require a format file (externally described database file) to work.
Having said that, you could use the csvOpen with the name of the file you
used to define your Externally Described Data Structure, then populate the
data structure with your data, then call csvWrite with the data structure as
the parameter. It will convert it to CSV and write it to the IFS file you've
specified.

-Bob Cozzi
www.RPGxTools.com
RPG xTools - Enjoy programming again.


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of sjones@xxxxxxxxxxxxxx
Sent: Friday, October 07, 2005 2:05 PM
To: RPG programming on the AS400 / iSeries
Subject: IFS to Integrated Server

Hello group:

I would like to create a csv file & have it appear on either our 
integrated Linux server or integrated NT server.  I can get the file to 
the IFS, but can't find a method to get it from the IFS to one of the 
servers.

The reason I want it on our integrated servers is because our users 
network drives are mapped to one/both of those servers & I am thinking it 
would be easy for them to find the file.

Another question:  I am currently using this statement to create the 
record:

Eval ExcelOut = %Trim(%Editc(Sadakdt:'Y')) + ',"  ' + %Trim(Adcvnb) + '"'
Except WriteExel

Once I get all the records created, I do a Callp CpyToCsvIFS from Bob's 
X-Tools product...

Not so bad for a couple fields, but I can see if I needed more fields this 
will be a big pain to code.  I found in Bob's X-Tools the csvWrite 
procedure which looks like I can define all my fields in a data structure 
& then just do a callp, is that correct Bob????

Thanks for all your help!!

Steve Jones