| Shell Script [message #685344] |
Mon, 13 December 2021 07:08  |
knd.prasad
Messages: 35
Registered: December 2009
Location: HYDERABAD
|
Member |
|
|
Hi,
#!/bin/ksh
userid="apps"
psw="apps"
cstring="TEST122"
filena="inbnd.csv"
folder="/home/applmgr/inbound/"
desfolder="/home/applmgr/inbound/processed"
datafilename="/home/applmgr/inbound/inbnd.csv"
ctlfilename="/u03/oracle/TEST122/fs1/EBSapps/appl/fnd/12.0.0/bin/inbound_int_sh.ctl"
logfilename="/home/applmgr/inbound/sqllog_sh.log"
badlogname="/home/applmgr/inbound/sqlbadlog_sh.log"
sqlldr userid=apps/apps@TEST122 data=$datafilename control=$ctlfilename log=$logfilename bad=$badlogname
mv $datafilename $desfolder/inbnd_${CURR_DATE}.csv
Commit point reached - logical record count 22
mv: cannot stat `/home/applmgr/inbound/inbnd.csv\r': No such file or directory
I am getting error in mv command.
Please help me.
|
|
|
|
| Re: Shell Script [message #685345 is a reply to message #685344] |
Mon, 13 December 2021 07:54  |
 |
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
You have an hidden character (\r) in this line
datafilename="/home/applmgr/inbound/inbnd.csv"
Note: this an Oracle db related forum.
In addition, if you don't feedback in your topics you won't have more help.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
