Hi Guys !
I am new to unix and want to find out how we can make sql statement data to shell script variable?
Any help/suggestion is greatly appreciated
-Chandra (1 Reply)
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... (4 Replies)
Dear All,
we have a command output which looks like :
Total 200 queues in 30000 Kbytes
and we're going to get "200" and "30000" for further process. currently, i'm using :
numA=echo $OUTPUT | awk '{print $2}'
numB=echo $OUTPUT | awk '{print $5}'
my question is : can I use just one... (4 Replies)
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)));... (4 Replies)
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... (1 Reply)
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... (0 Replies)
i have 1 file say
LogDirectory='/var/tmp/logs'
DataDirectory='/var/tmp/data'
DBUSER='scott'
now i want to access these variables in many files where
#!/bin/bash
${DBUSER} , ${DataDirectory}
are called how do i do that?
Video tutorial on how to use code tags in The UNIX and Linux... (2 Replies)
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... (8 Replies)
Hi Gurus,
I have a script which assign awk output to shell variable. current it uses two awk command to assign value to two variables. I want to use one command to assign two values to two variables. I tried the code, but it does't work. kindly provide your suggestion.
current code... (2 Replies)
Discussion started by: green_k
2 Replies
LEARN ABOUT DEBIAN
car
car(1) GNU Telephony car(1)NAME
car - crytographic archiver.
SYNOPSIS
car [options] [paths...]
car --decode [.carfile]
DESCRIPTION
Creates and decodes portable cross-platform crytographic archives. An archive can be a collection of files, or an in-stream message that
is piped. Output can be to a binary .car file, or ascified text. A symetric cipher is used, and the passhrase is hashed to form a key.
OPTIONS --cipher=name
Specify symetric cipher. By default 256 bit aes is used.
--decrypt
Specify decryption operation on an existing car stream or file. If no file is specified, stdin is used.
--digest=name
Specify name of digest algorithm. By default sha will be used.
--follow
Dereference and follow symlinks. Otherwise they are ignored.
--output=filename
Specify output file for a new archive. By default stdout is used.
--overwrite
Always overwrite existing files without prompting.
--quiet
Non-interactive and no status output.
--recursive
If argument is a directory, recursively scan directory and any subdirectory contents as arguments.
--help Outputs help screen for the user.
AUTHOR
car was written by David Sugar <dyfet@gnutelephony.org>.
REPORTING BUGS
Report bugs to bug-commoncpp@gnu.org.
COPYRIGHT
Copyright (C) 2010 David Sugar, Tycho Softworks.
This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
LAR PURPOSE.
GNU uCommon January 2010 car(1)