|
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::=%
|