09-01-2009
How to execute the multiple line sql using shell script
Hi All,
Please help me to write a shell script to execute the below sql query.
select c.account_no,b.bill_no,a.pay_type,(b.total_due + b.recvd + b.adjusted + b.disputed + b.transferred) as amt_not_billed,d.cash_on_delivery,
(select j.bill_no from
billinfo_T y,
bill_t j
where
y.poid_id0 = j.BILLINFO_OBJ_ID0
and
y.LAST_BILL_T = 1249077600
and
y.bill_info_id = 'COD'
and
y.account_obj_id0 = c.poid_id0
and
j.bill_no is not null
) as COD_BILL_NO,
a.billing_status_flags as is_suspended
from billinfo_T a,
bill_t b,
account_t c,
pr_contract_profile_t d
where
a.POID_ID0 = b.billinfo_obj_id0
and c.poid_id0 = a.account_obj_id0
and c.aac_source = 'PR Billing Account'
and a.pay_type = 10005
and b.bill_no is not null
and (b.total_due + b.recvd + b.adjusted + b.disputed + b.transferred) < 0.2
and d.order_num ='test'
and a.bill_info_id = 'Default Bill';
Thanks in advance.
Giri
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi everybody...
can anyone help me in executing the .sql file with shell scripting....
thanx in advance (2 Replies)
Discussion started by: abuanas
2 Replies
2. Shell Programming and Scripting
Hi people, i need youre help on this.
I need to create an Shell SCript to list in a directory some sql files and then execute them one by one .
Also i need to have Logs from the executed Sql's to send to our costummers.
Can anyone help me on this
Regards,
osramos (2 Replies)
Discussion started by: osramos
2 Replies
3. Shell Programming and Scripting
hi all,
how to execute shell script in another server that contain sql script. i tried using "ssh -l" option.. but i am unable to load the environment variable of the remote host.
please suggest how execute the shell script contain sql part inside it. (2 Replies)
Discussion started by: sandeep909
2 Replies
4. Programming
hi all,
I'm new to shell scripting, i want to know how to use the sql statements from the shell script? is there any documents or pdf to learn from the begining? plese provide me some useful links on the same.
Thanks all in advance..,:b: (3 Replies)
Discussion started by: vij_krr
3 Replies
5. Shell Programming and Scripting
I am using HP-UX:
I have written a ksh script where I need to connect to sqlplus and execute few sql scripts. Part of this code is -
sqlplus user/temp1234 <<!
set serverout on
set feedback off
set pages 1000
set colsep ,
set echo off
spool /home/supp1/pks/output.csv... (8 Replies)
Discussion started by: Sriranga
8 Replies
6. Shell Programming and Scripting
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies
7. UNIX and Linux Applications
using sqlplus I want to execute a .sql script that has dbms_output statments in rhe script. I want to write the dbms_output statements from .sql file to a log file. is this possible. thanks
any help would be appreciated
:wall: (1 Reply)
Discussion started by: TRS80
1 Replies
8. Shell Programming and Scripting
hello forum ,
I am new to shell scripting. as part of my assignment i have to execute a sql querry from the shell script. please help me.
example.
sql queerry:db2 "select emp_id from tsble emp".
i have to execute the above querry from the script.
advance thanks to forum
Siva ranganath (1 Reply)
Discussion started by: workforsiva
1 Replies
9. Shell Programming and Scripting
Hi All,
I want some help in writing a shell script which will be in the below form:
A logical representation of shell scripts:
->Shell scripts start
->Connect to database
->Execute a sql and store the output in a cursor(need to know is there any concept of cursor in unix)
->Using a loop... (2 Replies)
Discussion started by: Chitragupta
2 Replies
10. Shell Programming and Scripting
Hi Experts,
Need your support.
Not able to use sql query alias in shell script.
Could you please help me in finding right way to use alias with sql query in shell script.
Below is the code i am using.
#!/bin/bash
sqlplus -s abc/abc@abc << EOF> bcd.csv
set trimspool on
select zone_id... (4 Replies)
Discussion started by: as7951
4 Replies
uupick(8) System Manager's Manual uupick(8)
NAME
uupick - retrieve files transferred by uuto
SYNOPSIS
uupick [-s system] [--system system]
DESCRIPTION
The uupick program is used to conveniently retrieve files transferred by the uuto program.
For each file transferred by uuto, uupick will display the source system, the file name, and whether the name refers to a regular file or a
directory. It will then wait for the user to specify an action to take. One of the following commands must be entered:
`q'
Quit out of `uupick'.
`RETURN'
Skip the file.
`m [directory]'
Move the file or directory to the specified directory. If no
directory is specified, the file is moved to the current directory.
`a [directory]'
Move all files from this system to the specified directory. If no
directory is specified, the files are moved to the current
directory.
`p'
List the file on standard output.
`d'
Delete the file.
`! [command]'
Execute `command' as a shell escape.
OPTIONS
-s system, --system system
Used to restrict `uupick' to only present files transferred from a particular system.
Standard UUCP options:
-x type, --debug type
Turn on particular debugging types. The following types are recognized: abnormal, chat, handshake, uucp-proto, proto, port, config,
spooldir, execute, incoming, outgoing.
-I file, --config
Set configuration file to use.
-v, --version
Report version information and exit.
--help
Print a help message and exit.
SEE ALSO
uucp(1), uuto(1)
AUTHOR
Ian Lance Taylor <ian@airs.com>. Text for this Manpage comes from Taylor UUCP, version 1.07 Info documentation.
Taylor UUCP 1.07 uupick(8)