Search Results

I did your suggestion but I still encountered the error. I was able to work around it by taking out the $ sign. Thanks! :D

Thanks for your reply. Does this mean that ksh doesn't interpret the $ symbol?

I am currently returning an sql result with a number value that I want to format as an amount. The sql runs smoothly on its own, but when run inside my ksh script an error is encountered:

ERROR at...

Thank you for your replies! I was able to do workaround on my sql. Instead of fixing the file, I took out the spaces on my sql results and it worked perfectly. :)

Sorry, I'm afraid I don't know how to use sed correctly..

I tried your suggestions but the compiler was trying to access the first word (4531010001) inside the file instead of the file itself..
...

I'm currently writing my sql results to a file and they have trailing spaces after each field. I want to get rid of these spaces and I'm using this code:

TVXTEMP=$(echo $TVXTEMP|sed -e 's/\ //g')...

I'm having problems with writing my sql results to a file:



sqlplus -S username/password@DB <<!!

set echo off
set verify off
set showmode off
set feedback off
set timing off
set...