Setting variable for query using iSql / Korn Shell Post: 302285699

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Setting value of Shell variable from within ISQL

Hi Guys, Need help. I am using ISQL inside a shell script. Is there a way to set the value of shell script variable from inside the ISQL code. I do not want to write the results from the SQL to an output file. Please let me know. Regards, Tipsy.

2. Shell Programming and Scripting

compound variable in korn shell

in a text " Korn Shell Unix programming Manual 3� Edition" i have found this sintax to declare a compoud variable: variable=( fild1 fild1 ) but this sintax in ksh and sh (HP-UNIX) not work... why?? exist another solution for this type of variable ???

3. Shell Programming and Scripting

isql query in unix shell script

Dear all I want to execute some isql command from unix shell script. Kindly suggest me. isql command mention below. isql -U -P use gdb_1 go select count (*) from table_x go

4. UNIX for Dummies Questions & Answers

Using isql in korn shell

Hi all, I have two accounts in a Unix server, the first one uses .tcsh as default shell and the other uses .ksh (korn shell) as default. When I login using the account with .tcsh default, I can use the isql command and connect to our database server. However, when I use the other...

5. Shell Programming and Scripting

Isql query in unix shell

Hi i want write a script for list of sysbase are having access or open. then i wrote like: USER="abc" PASS="xyz" SERVER="SCCS" DB="blue" WORK_DIR="/usr/home/ramakrishna" set -x isql -U${USER} -P${PASS} -S${SERVER}<<EOF>$WORK_DIR/output.log go use blue (database name) go use...

6. UNIX for Dummies Questions & Answers

Korn Shell Script / Clearcase Query

Hi, I wonder can you help me ... I have the following clearcase code that works on the command line: ct mkattr -replace Four_Legs '"cat dog"' lbtype:Animal however when i try to use it in my script it fails with the following error message: + ct mkattr -replace Four_Legs "cat dog"...

7. 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 ?

8. Programming

How to refer to variable (korn shell)?

Hi I have the following block of code in korn shell and don't now how to refer to variable `print variable1.$dvd` ? --- integer dvd=4 integer number=0 while (( dvd!=0 )) do print "Iteracja numer : $dvd" print "$_" #it refers to $dvd var but want to refer...

9. UNIX for Dummies Questions & Answers

how to use shell variable in isql

Hi , I want to use shell variable in isql. example.. $ksh ./sudh.ksh "2041qwer" sudh.ksh is my script passing the perameter "2041qwer" Code in my script : =========== $SYBASE/$SYBASE_OCS/bin/isql -I$SYBASE/interfaces -S$OTHRSRVR -U$SYBUSER -P$SYBPASS -w...

10. Shell Programming and Scripting

Return value inside isql to a shell variable in ksh

Hello, I have a shell script where I am doing an isql to select some records. the result i get from the select statement is directed to an output file. I want to assign the result to a Shell variable so that I can use the retrieved in another routine. e.g. "isql -U${USER} -P${PASSWD} -S${SERVER}...

LEARN ABOUT DEBIAN

surfraw-update-path

SURFRAW-UPDATE-PATH(1)					User Contributed Perl Documentation				    SURFRAW-UPDATE-PATH(1)

NAME

       surfraw-update-path - updates PATH in shell config files

SYNOPSIS

       surfraw-update-path [-add] [-remove] [-check] [-sys] [-all] [-help] [-shell=SHELL]

DESCRIPTION

       surfraw-update-path adds the surfraw elvi directory (/usr/lib/surfraw) to your PATH in your shell's config file.

       Currently it supports bash, sh, csh, tcsh, ash, dash, ksh, pdksh, zsh, rc, and es

       Don't forget to login again or source your login files for it to take effect.

OPTIONS

       -check
	   Checks to see if the surfraw config code is present.  This is the default.

       -add
	   Adds the surfraw config code.

       -remove
	   Removes the surfraw config code

       -sys
	   Updates the system-wide shell config instead of the user.  Must be done as root.

       -shell=SHELL
	   Selects the shell to configure. Defaults to the value of the $SHELL environment variable.

	   Currently supported shells are:

	   sh, ash, bash, dash, csh, tcsh, ksh, pdksh, zsh, rc, and es.

       -all
	   Attempts to configure the startup files for all known shells

       -help
	   Gives a usage message

RETURN VALUE

       -check returns 0 if the surfraw code is present in the file, 1 if it is not found, or 2 on error.

       All other options return 0 on success, or 2 on error.

ENVIRONMENT

       SHELL
	   Used to determine which shell to configure, if -shell is not given.

       HOME
	   Used to find users config files.

       ENV Used by posix-compliant shells to specify a startup rc file.

       ZDOTDIR
	   Used to find user config files for zsh. If not set, defaults to HOME.

SEE ALSO

       surfraw(1), sh(1), ash(1), bash(1), dash(1), csh(1), tcsh(1), ksh(1), pdksh(1), zsh(1), rc(1), es(1)

AUTHOR

       Ian Beckwith <ianb@erislabs.net>

perl v5.12.4							    2011-07-12						    SURFRAW-UPDATE-PATH(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Setting value of Shell variable from within ISQL

Discussion started by: tipsy

2. Shell Programming and Scripting

compound variable in korn shell

Discussion started by: ZINGARO

3. Shell Programming and Scripting

isql query in unix shell script

Discussion started by: jaydeep_sadaria

4. UNIX for Dummies Questions & Answers

Using isql in korn shell

Discussion started by: risk_sly