RE: Create dds from fdf

["Gary Kuznitz" <docfxit@xxxxxxxxxxxx>]

Thank you for the reply...

On 15 Jan 2009 at 15:10, Jerry (Jerry Adams <midrange-l@xxxxxxxxxxxx>) commented about RE: Create dds from fdf:

> If you can bring the file up in Excel, you can use the add-in for
> Excel to write the file to the i5.  It doesn't use the column headings
> on Row 1, but fudges its own names, which you can override/define as
> you create the download.  Don't remember if you can save this
> transfer, or not; I've only used it for ad hoc stuff. 

I am trying to use this.  This is where I get the SQL error.  It does use the 
names in Row 1 just fine.  You can save the transfer.  If I could only get past 
this SQL error it looks like it would work.

> This does not create DDS, but the file will be externally defined. 
> You can use iNav to generate DDL from there. 

I have tried without DDS and it gives me an error saying it can't find the file 
even though I selected the option to create the file.

I also tried by creating DDS and creating the file.  That is when I get the SQL 
error.

Thank you,

Gary Kuznitz
 
> Jerry C. Adams
> IBM System i Programmer/Analyst
> B&W Wholesale
> office: 615-995-7024
> email:  jerry@xxxxxxxxxxxxxxx
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Kuznitz
> Sent: Thursday, January 15, 2009 2:38 PM
> To: Midrange Systems Technical Discussion
> Subject: Create dds from fdf
>
> I have a csv file with a lot of fields in it that I would like to got onto an 
> i5.  I can bring up the file in Excel and create an FDF with the field names.
>
> Does anyone know of a program on the i5 that will convert an FDF file to DDS.
> I don't have the file created on the i5.  Client Access won't create the file 
> on the i5 from Excel
>
> Thank you,
>
> Gary Kuznitz
>
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.