Login or Register to Ask a Question and Join Our Community


HP-UX

Unix sheel script to run report

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems HP-UX Unix sheel script to run report
# 1  
Old 06-28-2006
Unix sheel script to run report
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
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Windows & DOS: Issues & Discussions

Run UNIX Script from Excel

How to run scripts from Excel and bring results back to excel? (10 Replies)
Discussion started by: santoshdrkr
10 Replies

2. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies

3. Shell Programming and Scripting

Run the UNIX script only in specified timelines

Hi, I have an UNIX script which runs in every 20 mins of all the days scheduled through CRON. But i need to modify the CRON entry such that it should run from 00:00 AM to 18:00 and again from 22:30 to 23:59 on Saturday. Remaning days, it should run as usual in every 20 mins. Could anybody... (1 Reply)
Discussion started by: rjanardhan83
1 Replies

4. Shell Programming and Scripting

Sheel script to Delete a set of files from a given directory

I have a file <filestodelete> containing names of files to to be deleted from a directory <filesstore>. I want a script file which accptes the <filestodelete> and also the location of the directory(<filestore>) and deletes all files matching. Thanks in Advance.. (3 Replies)
Discussion started by: VardhiniVenkat
3 Replies

5. Shell Programming and Scripting

Unix script to run a query

Hi , I need help in creating the shell script for querying using a loop. I haev written the code as follows . But i am getting an error : Line doesn't required '(' . i have chagned but am getting again #!/bin/ksh ##checking the Command Line Parameter if test $1 = "" then ... (3 Replies)
Discussion started by: ramji_leo
3 Replies

6. Shell Programming and Scripting

Need a sheel script to compare no of file on diffrent servers

i have serverA and serverB and i have a folder with same name an location in both servers.... Now i want to compare files in folder(serverA) with folder (serverB) if there are files missing in folderB then copy those files from folder(serverA) to folder(serverB) (1 Reply)
Discussion started by: ashahzad
1 Replies

7. Shell Programming and Scripting

How to check succeesfull finish of a executable from the sheel script

Hi, I want to know is there a way out wherein we can know that the C++ executable has finished its task. Following is the steps: 1.Shell script calls a executable after setting all the env variables. 2.Now after the executable has done its job(basically to create some outpur files).The... (2 Replies)
Discussion started by: electroon
2 Replies

8. Shell Programming and Scripting

check in unix shell script so that no one is able to run the script manually

I want to create an automated script which is called by another maually executed script. The condition is that the no one should be able to manually execute the automated script. The automated script can be on the same machine or it can be on a remote machine. Can any one suggest a check in the... (1 Reply)
Discussion started by: adi_bang76
1 Replies

9. Shell Programming and Scripting

chaging a environment varible using sheel script

hi How can one change an environment varaible inside a shell script say my bash shell has a env variable export FOO="Day" no i want to write a script inside which the FOO variable is modified to say export FOO=NIGHT after this script finishes te bash shell should show me NIGHT when i... (1 Reply)
Discussion started by: wojtyla
1 Replies

10. Shell Programming and Scripting

need help on unix script to run report

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... (2 Replies)
Discussion started by: isingh786
2 Replies
Login or Register to Ask a Question

LEARN ABOUT CENTOS

mysqlbug

MYSQLBUG(1)						       MySQL Database System						       MYSQLBUG(1)

NAME

       mysqlbug - generate bug report

SYNOPSIS

       mysqlbug

DESCRIPTION

       This program enables you to generate a bug report and send it to Oracle Corporation. It is a shell script and runs on Unix.

       The normal way to report bugs is to visit http://bugs.mysql.com/, which is the address for our bugs database. This database is public and
       can be browsed and searched by anyone. If you log in to the system, you can enter new reports. If you have no Web access, you can generate
       a bug report by using the mysqlbug script.

       mysqlbug helps you generate a report by determining much of the following information automatically, but if something important is missing,
       please include it with your message.  mysqlbug can be found in the scripts directory (source distribution) and in the bin directory under
       your MySQL installation directory (binary distribution).

       Invoke mysqlbug without arguments:

	   shell> mysqlbug

       The script will place you in an editor with a copy of the report to be sent. Edit the lines near the beginning that indicate the nature of
       the problem. Then write the file to save your changes, quit the editor, and mysqlbug will send the report by email.

COPYRIGHT

       Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.

       This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
       published by the Free Software Foundation; version 2 of the License.

       This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
       Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

SEE ALSO

       For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
       at http://dev.mysql.com/doc/.

AUTHOR

       Sun Microsystems, Inc. (http://www.mysql.com/).

MySQL 5.1							    04/06/2010							       MYSQLBUG(1)