Thanks to everybody who replied!!!!



-----Original Message-----
From: Jeff
[mailto:oracledba-ezmlmshield-x30160520.[Email address protected]
Sent: Thursday, June 29, 2006 11:10 AM
To: LazyDBA Discussion
Subject: Re: FW: unix script to run report using concsub

Try something like this:



# FCP_USERNAME=`echo $* | awk ' { print $5 } ' | cut -d\" -f2`
FCP_USERNAME=NJ_SCHEDULE FCP_LOGIN=APPS/xxxxx ORDER_LIST=a.txt


export PATH
ORACLE_HOME=/d1app03/oracle/testora/8.0.6
TNS_ADMIN=/d1app03/oracle/testora/8.0.6/network/admin/test_uxprd
export TNS_ADMIN
ORACLE_SID=test

while read -r order_number
do

ORD_LOW=$order_number
ORD_HIGH=$order_number


CONCSUB ${FCP_LOGIN} "OE" "Order Entry USA Expedite" ${FCP_USERNAME}
WAIT=Y CON CURRENT ARO AROOEACK PRINTER=isdl NUMBER_OF_COPIES=1
PRINT_STYLE=LANDSCAPE {'1'
,'191','MSTK','D','ORDER','""',${ORD_LOW},${ORD_HIGH},'""','""','""','""
','""','
""','""','""','""','""','N'}

done < $ORDER_LIST





"Inder Singh " <oracledba-ezmlmshield-x95591008.[Email address
protected]
06/28/2006 11:45 AM

To
"LazyDBA Discussion" <[Email address protected] cc

Subject
FW: unix script to run report using concsub







Hi,

I am resending this question again.

Any suggestions please.

-Inder

-----Original Message-----
From: Inder Singh
[mailto:oracledba-ezmlmshield-x54262705.[Email address protected]
Sent: Wednesday, June 28, 2006 11:36 AM
To: LazyDBA Discussion
Subject: unix script to run

Hi All,

I have a report which I am running from unix shell script using CONCSUB
utility.

Just for testing I put the order number in shell script as ord_low and
ord_high.

But Actually what is going to happen is that the order numbers will be
in a file say a.txt

and this CONCSUB should read the order numbers from a.txt and then run
the report.

Or May be there is some more efficient way to acheive this.....

Please help me as this is urgent.


$ more xxxx_ORDERACK_SCH
# FCP_USERNAME=`echo $* | awk ' { print $5 } ' | cut -d\" -f2`
FCP_USERNAME=NJ_SCHEDULE FCP_LOGIN=APPS/xxxxx

ORD_LOW=743114
ORD_HIGH=743114

export PATH
ORACLE_HOME=/d1app03/oracle/testora/8.0.6
TNS_ADMIN=/d1app03/oracle/testora/8.0.6/network/admin/test_uxprd
export TNS_ADMIN
ORACLE_SID=test


CONCSUB ${FCP_LOGIN} "OE" "Order Entry USA Expedite" ${FCP_USERNAME}
WAIT=Y CON CURRENT ARO AROOEACK PRINTER=isdl NUMBER_OF_COPIES=1
PRINT_STYLE=LANDSCAPE {'1'
,'191','MSTK','D','ORDER','""',${ORD_LOW},${ORD_HIGH},'""','""','""','""
','""','
""','""','""','""','""','N'}

and here is a.txt

743114
743115
743164

For tesing I just put three order numbers.

Regards,
Inder


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:
http://www.lazydba.com/legal.html






**********************************************************************
This e-mail message is intended only for the personal use of the
recipient(s) named above. This message is confidential. If you are not
an
intended recipient, you may not review, copy or distribute this message.

If you have received this communication in error, please notify the
sender
immediately by e-mail and delete the original message.
**********************************************************************


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page