Search Results

Thanks everyone for prompt response.
Found that it was issue while copying the file from unix to local system and opening in Notepad. converting the file into text mode while copying solved the...

Below is the SQL:
SELECT &&1 || '|' || to_char(sysdate, 'YYYYMMDD') || 'T' ||
to_char(sysdate, 'HH24MM') || '00' || '|' || item.segment1 || '|' || 'IM' || '|' ||
...

Hi,

I am new to shell script programming. I have written a ksh script to run the sql File placed in server directory and spool the output in destination directory.
Below Command:...