|
<snip> 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. </snip> Tom, I wish it were so easy.... You may be right about the EBCDIC fix-length record formats in the business world. But unfortunately for the iSeries this is changing rapidly. Previous posts within this thread have referred to variable length data and attest to the global acceptance. Maybe you haven't had to deal with the different database issues for the past 20 years but I certainly have. Sometimes to import data sometimes to export data. Sometimes as a 'one shot' conversion and sometimes for regular transaction processing. Like any process on a computer, the task has never been too quick to execute and time frames are regularly a concern. I didn't make the ASCII variable-length world either, but I am willing to accept the need to support it. Like it or not. ----- I actually used the CPYTOIMPF command this week to convert the 10.5gb of data contained within 15 PFs. The process included creating a selected EBCDIC recordset with RPG prior to running the command which processed overnight. Then the CPYTOIMPF command took the entire next day to store the space padded data into the IFS as ASCII. Then I used FTP to get the files to an xSeries box in our network which look all night and failed on the 3.6gb file after 3.2gb. Disabling the Token Ring card on the iSeries and executing the FTP again got that file to the xSeries in less than 10 minutes. Then the backup to DLT tape on the xSeries took 13.6 hours. This set of files must be processed four time in the next few weeks so optimizing the environment is of great importance. The biggest issue, at this point, is the size of the resulting data. I haven't been able to get an actual byte count yet on the entire set of data, but I am seeing significant savings when these padded spaces are removed. ----- The sad part of this story is that the midrange community is losing another customer to a M$ solution. This is a long time government account and it's rather disappointing to see this situation happen. Ken Slaugh (707) 795-1512 x118 Chouinard & Myhre, Inc. CA/400 Certified Specialist iSeries Network/MSE Administrator http://www.cm-inc.com/ qsrvbas@xxxxxxxxxxxx (Tom Liotta) To: midrange-l@xxxxxxxxxxxx Sent by: cc: midrange-l-bounces@x Subject: RE: CPYTOIMPF and CSV Format idrange.com 08/15/2003 01:17 AM Please respond to Midrange Systems Technical Discussion 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 _______________________________________________ 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.
As an Amazon Associate we earn from qualifying purchases.
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
