I don't see a question in your post. I don't want to sound like Alex Trebek, but a question would help... As it is, I must first guess at your question and then provide an answer.
My guess: How to use a ksh coprocess? I don't know mysql, so I'll use a program that I do know: adb. Here is an interactive adb session on an HP-UX 11.0 system...
The stuff in bold is what I typed. $q looks odd, but that is an adb command to quit. Notice that I get two lines of output with the first line being rather useless. My script will need to eat that line. I must take the output as it comes. So here is the script...
So "print -p" sends stuff to the coprocess. And "read -p" gets the results. I don't need to "get back" to the script...I never go anywhere. I don't really need to wait for the coprocess to exit, but I always do...just habit.
I hope that you weren't actually asking an sql question.
Hi,
I have a UNIX script which calls SQL Select statement:
Now i want to use the output of that select statement within my UNIX script so as to call different shell script depending upon the output of the select statement.
Can anyone help me in this regard.
TIA
Akhil Goel (4 Replies)
Hi
I have a shell script in which a string variable is saving following query.
SqlQuery="select a||'|'||b||'|'||c from dual"
I am trying to pass above query as a parameter to some script but its giving me error for "single quote". I tried suppressing it using \' instead of just ' but it... (1 Reply)
Hi
I want to get the a field from a SQL query into unix shell script variable. the whole situation is like this.
1. Opened a cursor to a table in DB2 databse.
2. Fetching individual rows with the help of cursor.
3. Each row has 4 fields.
I want each of the field in individual shell... (1 Reply)
Hi there
I have a database on a remote box and i have been using shell script to insert data into it for example, i could have a script that did this
SN=123456
n=server1
m=x4140
sql="UPDATE main SET hostname='$n',model='$m' WHERE serial='$SN';"
echo $sql |/usr/sfw/bin/mysql -h... (4 Replies)
Hi Guys..
need some urgent help... I am stuck in something badly
I need to write a script which would read a sql statement (which might be a join/inner join/select/sub select etc. )
I need to read that sql statement ... and in the output I want all the table names and columns (doesn't... (4 Replies)
Hi,
I need to connect to the database and retrieve two variables from the database and store them in a variable,out of these two variables I need to get lastdigit appended to the variable 1 retrieved and variable 2 with out any modification
in short
select var,data from usage;
o/p=... (1 Reply)
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
Hi,
I have the following basic script. However, the statement (line 5) is not work. The output data is not able to set my request format a30. Any advise? :mad:
echo " Column filename format a30"|sqlplus4
echo Input file list to check:
read filelist
for file in `cat $filelist.txt`
do... (1 Reply)
Hi Forum.
Need your expertise on the following question.
I have the following file which I would like to parse, find first block of SELECT statment and concatenate all input fields as 1 field (~ delimited):
Old File:
SELECT /*+ USE_HASH(CCOMM ICAR IMAP IAS IP IMAS IMPS IAP SPCA) */
... (5 Replies)
Hello All,
I am writing the below unix script to email the result of a small pl sql procedure:
#!/bin/bash
ORACLE_HOME=/opt/oracle/orcts/product/9.2.0; export ORACLE_HOME
SQLPLUS=$ORACLE_HOME/bin/sqlplus
sqlplus -s user/pass@Db_instance<<EOF
set echo off
set feedback off
set pages 0... (9 Replies)
Discussion started by: Bunty bedi
9 Replies
LEARN ABOUT OSX
adb
adb(1) User Commands adb(1)NAME
adb - general-purpose debugger
SYNOPSIS
adb [-kw] [-I dir] [-P prompt] [-V mode] [ object [ core]]
DESCRIPTION
The adb utility is an interactive, general-purpose debugger. It can be used to examine files and provides a controlled environment for the
execution of programs.
The adb utility is now implemented as a link to the mdb(1) utility in Solaris 9. mdb(1) is a low-level debugging utility that can be used
to examine user processes as well as the live operating system or operating system crash dumps. The new mdb(1) utility provides complete
backwards compatibility with the existing syntax and features of adb, including support for processing adb macro files. The Solaris Modular
Debugger Guide and mdb(1) man page describes the features of mdb, including its adb compatibility mode. This mode will be activated by
default when the adb link is executed.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWmdb |
+-----------------------------+-----------------------------+
SEE ALSO mdb(1), attributes(5)
Solaris Modular Debugger Guide
SunOS 5.10 19 Aug 2003 adb(1)