Search Results

Are you providing the files full path?
Are you passing the file name directly or through variable?
if it is rm ${file}, the reason could be the '$'. You need to escape the '$'

Since its a log file you may not be the owner (informatica?) and worse it may be open (STDERR...)
One way of knowing if its informatica stoping you is to stop the application and try to remove the...

Hello,

Following may also help.


echo "T_SYSTEM_XXXXX_YYYY_ZZZ" | awk -F"\_" '{print $3 $4 $5}'


Output wil lbe as follows.


XXXXXYYYYZZZ



Thanks,
R. Singh

try with below options

set feedback off
set verify off
set termout off
set trimspool on
set linesize 500
set pages 0

for query

select rpad(substr(col_name,1,16),18,' ') from...