Re: Upload vs. CPYFRMIMPF

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

First, what did you use to upload? I'm assuming FTP.

Second, be sure your shared folder is not in /QDLS - the term suggests that 
location, from the old days. Be sure you are talking about mapped network 
drives and not the old Client Access shared folders.

Third, don't use a mapped network drive. Consider this - every time you 
write to the file you are going across the network over one of the really 
poor protocols - NetBios, esp. as IBM has written it - it's not the best 
thing since sliced bread. Far better to do the PC work native on the PC, 
not over the network, then FTP to IFS or even a PF directly if it's 
formatted for fixed length. Or you can copy from a local drive to a mapped 
drive, once you are done. But FTP is probably faster.

Of course, we have a product or two - RPG2SQL could get involved here - 
there is an ODBC text driver - or our Office Integrator. 
www.rjssoftware.com and look under Solutions, then one of the categories, 
then in Product Overview, which is really a product list.

HTH
Vern

At 06:46 PM 6/9/2005, you wrote:

> 9406-600 running V5R2.  I have a pc program which spits out text files 
> (most 400K, some 1.5gig), then I run them through a VB program to format 
> the data, upload it, then run an RPG program to assimilitate with master 
> file data.
>
> I was thinking the other day that I could have the program spit out the 
> data as comma delimited to a shared folder then assimilate.  I got a small 
> test to work and I'm trying a 400K file now and it's taking much longer 
> than the VB/upload process did.  Shouldn't it be faster?  The other 
> process didn't take that long but took lots of babysitting.  Thoughts?  TIA.
>
>
> Jim Newman
> --
> 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.