Re: Help ­CPYTOIMPF

On 24 Feb 2013 09:38, Billy Waters wrote:

Results from a previous post did not provide help, or at least help
that I could follow.

The reference to CPYTOIMPF in the prior thread "Subject: csv" was poor advice; misdirection, effectively.

I have an AS400, file 1 column 80 characters:

8,xxxxxxxxx,999.99,2013/02/18

This information could have been helpful in that prior message thread. I will respond to the other thread.

I need to “send” this to SQL server.

Transport that text\csv data to the system where the SQL Server resides, and ask that SQL to /import/ that data. That /transport/ can be effected via a network protocol\feature that presents the data at the other system as a /file/ of the data, or the /transport/ could send a copy of the physical data to be placed in a /file/ on the target system such as via FTP.

I am trying the CPYTOIMPF command. Please excuse my ignorance, this
is new territory for me!

The CPYTOIMPF would be used to /export/ database file[.member] data to a text file. Because the "timekeeping package creates a coma delimited file" as noted in the other thread, the /export/ has already been effected, so CPYTOIMPF is not the feature to be used at this point.