9 More Discussions You Might Find Interesting
I am using DB2 and wish to capture the ETL status on daily basis so that i can run the query and share the details in xls format to respective mail ids .
Currently i am using below query but this displays table name and counts for latest run.
select name ,CARD from... (0 Replies)
Discussion started by: Perlbaby
I am trying to run sql query from solaris in csh script and send the output to email. Below is my sql query
select p.spid,se.program seprogram, se.machine, se.username, sq.sql_text,sq.retrows from v$process p
inner join v$session se on p.addr = se.paddr
( select... (2 Replies)
Discussion started by: tharmendran
3. Shell Programming and Scripting
#] && . ./.profile 2>/dev/null
if test -f '.profile'; then . ./.profile; fi;
pzCType="$1"; pzTitle="$2"; pzMsg="$3"; pzFrom="$4"; pzTo="$5"; pzFiles="$6"; pzReplyTo="$7"
... (21 Replies)
Discussion started by: ankit.mca.aaidu
4. Shell Programming and Scripting
I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to 20 columns.
So my requirement is to generate a output query which will have 20 columns all the... (7 Replies)
Discussion started by: vikas_trl
5. Shell Programming and Scripting
I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.
SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription';
Please use code tags next time for your code and data.... (9 Replies)
Discussion started by: Sharanakumar
6. UNIX for Dummies Questions & Answers
if ; then
echo "inside if"
echo "not inside if"
The size of the file /xxx/yyy/abc.txt is 1 mb
If i exec the above if condition, what is the output that i will get?
what does "-o " means in the if condition
The... (1 Reply)
Discussion started by: kmanivan82
7. Shell Programming and Scripting
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
8. Shell Programming and Scripting
Hi, unix gurnis
I need help for following requirement for writing a shell scritp.
log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file.
Thanks in advance (2 Replies)
Discussion started by: ken002
9. Shell Programming and Scripting
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
sqlplus -s... (2 Replies)
Discussion started by: Nareshp