Skip to main content

All Questions

1 vote
1 answer
1k views

How to escape a range of wildcards in unix shell script?

I need to execute the following Oracle SQL in unix crontab. The query is as follows: select count(*) from tbaadm.htd where cust_id is not null and pstd_flg = 'Y' and del_flg = 'N' and tran_date = (...
Mistu4u's user avatar
  • 113
1 vote
1 answer
3k views

ksh "<<EOF" script to change user

In the simplest form I am puzzled why this script does not work as expected as a here script changing users with su - user <<EOF. su - db2prd<<EOF PARMDATE=1111111 echo parmdate echo $...
DWill's user avatar
  • 11