RE: CPYTOIMPF and CSV Format

[qsrvbas@xxxxxxxxxxxx (Tom Liotta)]

midrange-l-request@xxxxxxxxxxxx wrote:

>   4. Re: CPYTOIMPF and CSV Format (Ken.Slaugh)
>
>
>Scott says:
>
>Though, on the other hand, people typically do have spaces in their PF,
>and people typically don't have spaces in their CSV's...  so, in the real
>world, this isn't very practical.   Someone should really point that out
>to IBM, maybe they'll add a new feature to the command...
>
> And a reply was:
>
>I totally agree. I wonder why IBM even has to be told. To me, this is
>another classic reason the 'iSeries doesn't play well with others'. Too bad
>it could have been avoided in Rochester.

Sorry, Ken, perhaps the wrong perspective. Given how much of the business 
world's data is stored in EBCDIC in fix-length record format not just on 
iSeries, it's possibly more correct to wonder why so many other systems can't 
accept input properly. Those other systems don't play well.

I'm curious how I can FTP a table out of an SQL Server database into an iSeries 
table? Now that's a reasonable "rest of the world" example. Or perhaps after 
I've spooled a report out of Excel on my Win2K system, I've decided I want to 
e-mail it to someone before printing it and then print it later. How many know 
how?

But CSVs are fairly recent in this (the iSeries) world. There are a number of 
ways to accomplish them though. On a Windows system, you better hope you've 
bought something that knows how to create them and/or import them or you'll be 
in the same position you'll be in on the iSeries; that is, you'll have to 
program a function to do it. Oh, wait... no... iSeries supplies a native 
command to export and import via CSVs.

Sorry, nevermind.

Tom Liotta

-- 
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertechgroup.com



__________________________________________________________________
McAfee VirusScan Online from the Netscape Network.
Comprehensive protection for your entire computer. Get your free trial today!
http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397

Get AOL Instant Messenger 5.1 free of charge.  Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455