Home > IT Answers > AS/400 > excuting sql loader from runrmtcmd from as400...
Rzierler
5 pts.
0
Q:
excuting sql loader from runrmtcmd from as400 to unix
RUNRMTCMD, AS/400, Unix, SQL Loader
I am tryint to execute a sql loader process on a Unix machine from the AS400. Here is the code,
RUNRMTCMD CMD('cd /home/dekbf/e3data;$sqlldr ekbf/ekbf +
control=EPINTORD2CTL.CTL') RMTLOCNAME('191.0.0.9' +
*IP) RMTUSER('dekbf') RMTPWD('ekbf')
Here is the error returned,
ksh: ekbf/ekbf: not found.
ASKED: Apr 22 2009  6:46 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Carlosdl
29350 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Have you tried running the unix commands directly in the unix box (i.e. cd /home/dekbf/e3data;$sqlldr ekbf/ekbf +
control=EPINTORD2CTL.CTL) ?

Why do you need the '$' before SQLLDR ?

Have you tried something likes this ?

RUNRMTCMD CMD('sqlldr ekbf/ekbf control=/home/dekbf/e3data/EPINTORD2CTL.CTL') RMTLOCNAME('191.0.0.9' +
*IP) RMTUSER('dekbf') RMTPWD('ekbf')

-------------------------------------
Last Answered: Apr 22 2009  7:59 PM GMT by Carlosdl   29350 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0