Re: File definitions transferred from PC to i5/OS

Elvis,

The files exist. I was wondering how they were created.

It seems that the iSeries Access wizard was used - it will create the i5/OS
file from the CSV file without transferring the data.

Thanks to 42 for the answer.
Trevor


On 9/28/07 3:18 PM, "Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

Is SQL DDL acceptable?

If so, use iNav's Generate SQL feature.

Long-winded instructions :)

Start System i Navigator (aka iNav) and expand the LPAR you want to go to.
Expand (Databases)->(LPAR name aka system aka database
name)->(Schemas)->(find library where trigger is; if not there right-click
on Schemas and click on "Select schemas to display" and add your
library)->(expand that library)->(Tables)->(right-click on the table of
interest and select "Generate SQL")->(click on Generate)->(you'll see Run
SQL Script window with the CREATE TABLE source).

I hope I didn't miss your point...

Elvis

RPG & DB2 Summit | Minneapolis | October 1-4
Mike Cain - DB2 for i5/OS Temporary Indexes - The Good, The Bad, The Ugly
October 16
2007 System i Fall Technical Conference | Orlando | November 4-7
Celebrating 10-Years of SQL Performance Excellence on IBM System i, eServer
iSeries and the server affectionately known as the AS/400

-----Original Message-----
Subject: File definitions transferred from PC to i5/OS

I have a set of CSV files with the first row being the column headers.

I have a set of PF-DTA files in a library, that match the CSV file
definitions exactly. There is no data in any of these PF-DTA files.

Does anyone know how these PF-DTA files have been created? There is no
source file. I have been looking in iNav and WDSc for some tool that will
convert file definitions, but no luck yet.