1.

Solve : was unexpected at this time.?

Answer»

I do not use command prompt often so i dont know much about command execution

recently i WROTE a BATCH file(gsm) that copies a file from remote server and rename it

then i use sql loader to load it in ORACLE data base

SET t=%date:=%
ren todaycaf todaycaf%t%
net use y: \\10.8.88.80\nwa\gsm
xcopy "y:\GSM PREPAID REPORT_%t%_*.*" "C:\Documents and Settings\Veer.Singh.IN\Desktop\PPAD OPS\PPAD OPS\GSM Prepaid CAF"
ren "GSM PREPAID REPORT_%t%_*.*" todaycaf.txt
sqlldr smplfy1317/[emailprotected] control =c:/gsm.ctl

the problem while executing this file is
that i get error as

=%
was unexpected at this time.
gsm was unexpected at this time.Change the first row to:

Code: [Select]set t=%date/=%Code: [Select]Set t=%date:/=% or if the separator is a colon
Code: [Select]Set t=%date::=%



Discussion

No Comment Found