06-28-2006
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 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
10 More Discussions You Might Find Interesting
1. HP-UX
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... (0 Replies)
Discussion started by: isingh786
0 Replies
2. Shell Programming and Scripting
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
3. Shell Programming and Scripting
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
4. Shell Programming and Scripting
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:00 to 23:59 on Saturday. Remaning days, it should run as usual in every 20 mins.
Could... (1 Reply)
Discussion started by: rjanardhan83
1 Replies
5. Shell Programming and Scripting
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
6. Shell Programming and Scripting
Hi
I am trying to run the below unix script in informatica comamnd task
the script is in placed in the path (this script checks if the files are present in other server )
------------------------------------------------------------------... (1 Reply)
Discussion started by: laxmi131
1 Replies
7. UNIX for Dummies Questions & Answers
Hi,I'm currently working on an dev environment that has no jobs to run the scripts.How can I manual run the scripts. on Unix?
---------- Post updated at 05:45 AM ---------- Previous update was at 05:43 AM ----------
Is it something like this....
../int/inbound>./filename.sh inputfilename
... (5 Replies)
Discussion started by: sonja
5 Replies
8. Shell Programming and Scripting
Hello Guys
I have to run a perl script from unix one
The reason for this is I have to connect to remote server and then execute the perl script.
In unix script I am able to connect to remote server without any password via ssh
ssh -o 'PasswordAuthentication yes' -o... (5 Replies)
Discussion started by: Pratik4891
5 Replies
9. Shell Programming and Scripting
Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies
10. Windows & DOS: Issues & Discussions
How to run scripts from Excel and bring results back to excel? (10 Replies)
Discussion started by: santoshdrkr
10 Replies
LEARN ABOUT DEBIAN
radsqlrelay
RADSQLRELAY(8) FreeRADIUS helper program RADSQLRELAY(8)
NAME
radsqlrelay - relay SQL queries to a central database server
SYNOPSIS
radsqlrelay [-?] [-d sql_driver] [-b database] [-f file] [-h host] [-u user] [-P port] [-p password] [-1] [-x] file_path
DESCRIPTION
radsqlrelay tails a SQL logfile and forwards the queries to a database server. Used to replicate accounting records to one (central) data-
base, even if the database has extended downtime.
The SQL logfile is created by the rlm_sql_log module. The module must be configured in the radiusd server before you can use radsqlrelay.
OPTIONS
-? Print usage help information.
-d sql_driver
Driver to use: mysql, pg, oracle.
-b database
Name of the database to use.
-f file
Read password from file, instead of command line.
-h host
Connect to host.
-u user
User for login.
-P port
Port number to use for connection.
-p password
Password to use when connecting to server.
-1 One-shot mode: push the file to database and exit.
-x Turn on debugging.
file_path
The pathname of the SQL logfile to use.
NOTES
Oracle driver
The command "radsqlrelay -d oracle -b db.domain.tld sql-relay" reads the database description stored in $TNS_ADMIN/tnsnames.ora:
db.domain.tld =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db.domain.tld)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = <DB SID>)
)
)
SEE ALSO
rlm_sql_log(5)
AUTHOR
Nicolas Baradakis <nicolas.baradakis@cegetel.net>
19 June 2005 RADSQLRELAY(8)