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 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,
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)
Hi All,
bash-3.00$ gzgrep -i '\ ExecuteThread:' /******/******/******/******/stdout.log.txt.gz
<Jan 7, 2012 5:54:55 PM UTC> <Error> <WebLogicServer> <BEA-000337> < ExecuteThread: '414' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "696" seconds working on the request... (4 Replies)
HI,
I want to connect to database and fetch the count from a table.
The sql query is as below :
select count(*) from table_test where test_column='read';
How can I print the output of this statement using shell script.
Thanks in advance. (4 Replies)
Hi team,
I have two select statements and need to run them using SYSDBA user
select * from temp_temp_seg_usage;
select segment_name, tablespace_name, bytes/ (1024*1024) UsedMb from
dba_segments where segment_name='TEMP_TEMP_SEG_USAGE';
Need to run this using a shell script say named... (1 Reply)
cd /opt/et/WAS/apps/8.0
find . -name "HostIntegration.properties" -o -name "HostSocket.properties" -o -name "environment.properties" 2> /dev/null | awk -F '' '{print $4}'|awk '!x++' | cat>/home/cbadmin/file1.txt
cd /home/cbadmin/
PS3='Please enter a number from list of applications==>:'
select... (3 Replies)
I have a text file in this format
Some lines....
Question no: 1
The question?
A. Answer 1
B. Answer 2
C. Answer 3
D. Answer 4
Answer:B
Some lines....
Question no: 2
The question? (choose 2) (10 Replies)
Hello,
I have script which work 70% of the desired task , the output from script.sh is following , however the desired output I require is following .
Any piece of suggestion would be great..
thanks in advance,
emily
#!/bin/bash ... (8 Replies)
Discussion started by: emily
8 Replies
LEARN ABOUT SUSE
recordio
recordio(1) General Commands Manual recordio(1)NAME
recordio - record the input and output of a program
SYNTAX
recordio program [ arg ... ]
DESCRIPTION
recordio runs program with the given arguments. It prints lines to stderr showing the input and output of program.
At the beginning of each line on stderr, recordio inserts the program process ID, along with < for input or > for output. At the end of
each line it inserts a space, a plus sign, or [EOF]; a space indicates that there was a newline in the input or output, and [EOF] indicates
the end of input or output.
recordio prints every packet of input and output immediately. It does not attempt to combine packets into coherent stderr lines. For
example,
recordio sh -c 'cat /dev/fd/8 2>&1' > /dev/null
could produce
5135 > cat: /dev/fd/8: Bad file descriptor
5135 > [EOF]
or
5135 > cat: +
5135 > /dev/fd/8+
5135 > : +
5135 > Bad file descriptor
5135 > [EOF]
recordio uses several lines for long packets to guarantee that each line is printed atomically to stderr.
recordio runs as a child of program. It exits when it sees the end of program's output.
SEE ALSO tcpserver(1)recordio(1)