Re: Moving a text file to a physical file

[rob@xxxxxxxxx]

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