how to assign sql output data to shell script variable Post: 302079239

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to assign the result of a SQL command to more than one variable in shell script.

Hi Friends... Please assist me to assign the result of a SQL query that results two column, to two variables. Pls find the below code that I write for assigning one column to one variable. and please correct if anything wrong.. #! /bin/sh no=' sqlplus -s uname/password@DBname...

2. Shell Programming and Scripting

how to assign the output of the interective script to the variable

Hi, I work in ksh88. I have an interective script which prompts the user for the input and returns numeric value depending on the input provided. I need to call this script inside another script and then assign the resulting output the the variable. The call like that A=`my script` obviously...

3. Shell Programming and Scripting

How to assign record count output of isql to a shell variable ?

isql select count(*) from Table eof How to assign record count output of isql query to a shell variable ?

4. Shell Programming and Scripting

Assign perl output to ksh shell variable

Hello, I am writing a ksh script on an AIX system. I need to get the date and time from a file into a variable. I found the following perl script from another post on this site and modified it slightly to output the format I need: perl -e '@d=localtime ((stat(shift)));...

5. Shell Programming and Scripting

sql output to shell variable

Hi I tried searching but I used to see , this has been answered may times. But I could not find. I am looking a SQLPLUS output to be assigned to shell variable. This is what I coded. ##/bin/ksh sqlplus dmishr/mishra#09@ps004d.world <<ENDOFSQL spool abc.log SET ECHO OFF NEWP...

6. UNIX for Dummies Questions & Answers

Assign SQL result in shell variable

Hi im trying to assign the result of the db2 command to a variable inside a shell script... : tab_cnt=`db2 "select count(*) from syscat.tables where tabname = 'ABC' and tabschema = 'MATT01'" |head -4|tail +4|cut -c 11` : echo $tab_cnt when i echo im getting a blank value.. im expecting...

7. Shell Programming and Scripting

How to assign a shell variable to a NUMBER parameter in pl/sql?

I have the below script running for generating file from PL/SQL stored procedure. I need to declare a shell variable and then pass this to sqlplus command to pass the same as a INPUT parameter for the stored procedure. Please help to do this. #!/bin/sh minlimit=0 maxlimit=10 size=100 while...

8. Shell Programming and Scripting

Run sql query in shell script and output data save as delimited text

I want to run sql query in shell script and output data save as delimited text (delimited text would be comma) Code: SPOOL_FILE=/pgedw/dan.txt SQL=/pgedw/dan.sql sqlplus -s username/password@myhost:port/servicename <<EOF set head on set COLSEP , set linesize 32767 SET TRIMSPOOL ON SET...

9. Shell Programming and Scripting

How to Assign the Output of an SQL Query to a Variable?

Hi iam new to shell scripting how to declare variables as redshift query and I have to compare two counts by using if condition . ex:count=select count(*) from prd; select count(*) from prd; select count(*) from tag; can any one help me . Please use CODE tags when displaying...

10. UNIX for Beginners Questions & Answers

How can I assign awk's variable to shell script's variable?

I have the following script, and I want to assign the output ($10 and $5) from awk to N and L: grdinfo data.grd | awk '{print $10,$5}'| read N L output from gridinfo data.grd is: data.grd 50 100 41 82 -2796 6944 0.016 0.016 3001 2461. where N and L is suppose to be 3001 and 100. I use...

LEARN ABOUT DEBIAN

ttyrec

TTYREC(1)						      General Commands Manual							 TTYREC(1)

NAME

       ttyrec - a tty recorder

SYNOPSIS

       ttyrec [-a] [-u] [-e command] [file]

DESCRIPTION

       Ttyrec  is a tty recorder.  It is a derivative of script(1) command for recording timing information with microsecond accuracy as well.	It
       can record emacs -nw, vi, lynx, or any programs running on tty.

       Ttyrec invokes a shell and records the session until the shell exits.  Recorded data can be played back with ttyplay(1).  If  the  argument
       file is given, the session will be recorded in that file.  Otherwise, ttyrecord is used as default.

OPTIONS

       -a     Append the output to file or ttyrecord, rather than overwriting it.

       -u     With  this  option, ttyrec automatically calls uudecode(1) and saves its output when uuencoded data appear on the session.  It allow
	      you to transfer files from remote host.  You can call ttyrec with this option, login to the remote host and invoke uuencode(1) on it
	      for the file you want to transfer.

       -e command
	      Invoke command when ttyrec starts.

ENVIRONMENT

       SHELL  If  the  variable SHELL exists, the shell forked by ttyrec will be that shell.  If it's not set, the Bourne shell is assumed.  (Most
	      shells set this variable automatically).

SEE ALSO

       script(1), ttyplay(1), ttytime(1), uuencode(1), uudecode(1)

																	 TTYREC(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to assign the result of a SQL command to more than one variable in shell script.

Discussion started by: little_wonder

2. Shell Programming and Scripting

how to assign the output of the interective script to the variable

Discussion started by: aoussenko

3. Shell Programming and Scripting

How to assign record count output of isql to a shell variable ?

Discussion started by: vikram3.r

4. Shell Programming and Scripting

Assign perl output to ksh shell variable

Discussion started by: swimp