×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
