script into job CTRLM : trouble Treatment awk

[Ozarm]

Hi,

I'm beginner in CTRLM/EM (v620 syb)
I have a script unix AIX which works .ksh

but I try to schedule this script into a job
parameters job is Ok (memname, PATH,...)

I throw a requete sql
isql -Uuser -Ppwd <<EOF> /produits/TEST/TEST1/TableUpload.txt
select DATA_CENTER,SCHED_TABLE,MODIFIED from DEF_TABLES where MODIFIED="1" and SCHED_TABLE like "%.L1%" and DATA_CENTER not like "DC1" and DATA_CENTER="DC2"
go
EOF

echo "List of Tables has upload"
awk '{print $1,$2}' TableUpload.txt > $LOGFILE

....

I obtain the following error
"+ 0</tmp> /produits/TEST/TEST1/TableUpload.txt
+ echo Voici la liste des Tables a upload
Voici la liste des Tables a upload
+ awk {print $1,$2} TableUpload.txt
+ 1> /produits/TEST/TEST1/UPLOAD.110127.log
awk: 0602-533 Cannot find or open file TableUpload.txt.
The source line number is 1."


Do you have an idea? Syntaxe problem in CTRLM? Treatment of lines by ControlM?

[th_alejandro]

echo "List of Tables has upload"

cat TableUpload.txt | awk '{print $1,$2}' > $LOGFILE

[matom]

Hello Ozarm,

Add a "pwd" command in your script.

Try:
awk '{print $1,$2}' /produits/TEST/TEST1/TableUpload.txt > $LOGFILE


Regards
matom

[Ozarm]

Hi,

thank you for your answer

I try with path /produits/TEST/TEST1/ for each line with awk & sed command

and the job works fine.


Thank's again