Need help!!

How do I get to FTP AS400 data? My source table is called F091x.
I'm really a AS400 newbie, so, what do I ask my AS400 administrator for?
They are asking me if I want it exported to a text file now, Do I? Can I FTP
the production File? Will it lock the table for other users access??
How do I read it afterwards?
My process reads 1 million rows from this table every day and it is getting
very annoying (takes an hour!)
I really need a better way to extract my information.

Thanks in advance

Hi Miguel,

There are a lot of questions here....

First, ftp works to the AS/400 just like most other systems. To test it just
enter ftp as400name at the command prompt and you'll be promoted to signon
to the AS/400. If you're not then the AS/400 FTP host server is probably not
started. You start it using the STRTCP command.
If you get connected, the FTP GET subcommand is used to retrieve a file. One
thing to look out for is the fact that FTP from the AS/400 doesn't convert
packed data fields. If your file has them you'll need to make a workaround.

The table is not locked for other users access while FTP is running.

Afterward you'll end up with a text file on your Windows system. You'll have
to use that file to import to SQL Server.

If you're currently using DTS for this job and the IBM ODBC driver I'd
suggest first going into the Driver Manager | Performance Tab | Advanced and
increasing the Block Size value. The default is 32K but you'll get better
performance going to 1024K or even higher. Also make sure the Enable data
compression setting is checked on the Performance tab.


Michael Otey

"Miguel Salles" <MiguelSalles (AT) discussions (DOT) microsoft.com> wrote

Perhaps need this soon:

Was DTS / ODBC and alternative and should this be chosen or should you just
get
file dumps (format ?) from AS400 ?

"Michael Otey" <mikeo (AT) teca (DOT) com> wrote