RE: Moving a text file to a physical file

["Brian Piotrowski" <bpiotrowski@xxxxxxxxxxxxxxx>]

Awesome.  Thanks, guys.

Brian.

-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx] 
Sent: Monday, January 09, 2006 12:42 PM
To: Midrange Systems Technical Discussion
Subject: Re: Moving a text file to a physical file

CPYFRMIMPF FROMSTMF('/IFS.TXT') TOFILE(MYLIB/MYFILE) RCDDLM(*CRLF) 
FLDDLM(';')

However this has some "anomolies" with V5R3.  Some people even prefer to

rolling their own using API's.  Scott Klement has some great examples on

this with RPG.
<shameless LUG plug>
He will be presenting to the Fort Wayne Indiana user group on the
evening 
of Tuesday January 10, 2006.
http://www.statususer.org/statususer/html/20060110.html

Since it's rather late for reservations I'd suggest contacting the 
Arrangements chairman at 
http://www.statususer.org/statususer/html/board.html

</shameless LUG plug>

You could create a share on your SQL server, and use
CPY OBJ('/MyIfsDir/MyFile.txt') 
    TOOBJ('/QNTC/MySQLServer/ItsDirectory/MyFile.txt')
And then use 
RUNRMTCMD CMD('PostIt.exe') 
          RMTLOCNAME(MYSQLSERVER *IP)


Rob Berendt