How to pass a shellscript variable to a sql file? Post: 302896541

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to pass enviroment variable from csh to Informix sql script

Hello, I have a csh script that creates an environment variable. I want to pass the environment variable(CURR_TABLE_DATE) to an Informix sql script. Here is the csh: #!/bin/csh -f setenv INFORMIXSERVER market3_tcp setenv CURR_TABLE_DATE 20090714 set DATABASE = gm_cdr set SQL_DIR =...

2. Shell Programming and Scripting

Pass variable to sql

Please help. I got these error. I'm try to pass variable extract from data-file.txt to sql file(select.sql). cat: cannot open select cat: cannot open * cat: cannot open from cat: cannot open user cat: cannot open where cat: cannot open name=$list; #!/bin/bash list=`sed q...

3. Shell Programming and Scripting

Pass a variable to SQL script

Hi Guys, I like to pass a variable to a sql file in a unix script.. I tried a below code.. var=200903 db2 -vf test.sql 200903 test.sql is as below. select * from db2.users where quarter = $1; Please tell me where i go wrong.. Thanks in advance, Magesh

4. Shell Programming and Scripting

how to pass a variable to an update sql statement inside a loop

hi all, i am experiencing an error which i think an incorrect syntax for the where clause passing a variable was given. under is my code. sqlplus -s ${USERNAME}/${PASSWORD}@${SID} << END1 >> $LOGFILE whenever sqlerror exit set serveroutput on size 1000000 declare l_rc ...

5. Shell Programming and Scripting

How to pass arguments to SQL file passed in shell script?

Hi, I am using SYBASE database. in my script i am connecting to DB via using isql. isql -U${S_USER} -S${S_SERV} -D${S_DB} -P${S_PWD} -b0 -w3000 -h0 -s"|" -i${MYDIR}/ABC.sql -oXYZ.txt << FINSQL i am taking a ABC.sql file to use the queries written in it and storing the output in...

6. Red Hat

How to pass value of pwd as variable in SED to replace variable in a script file

Hi all, Hereby wish to have your advise for below: Main concept is I intend to get current directory of my script file. This script file will be copied to /etc/init.d. A string in this copy will be replaced with current directory value. Below is original script file: ...

7. UNIX for Dummies Questions & Answers

To pass multiple arguments from file in to an sql query

Hi all , I want to pass contents from a file say f1 as arguments to a sql query which has In statement using a script example select * from table_1 where login in ( `cat f1`) ; will this work or is there any other way to do it.

8. Shell Programming and Scripting

Pass command line arg to sql file

Hi all, How to pass the command line argument to a sql file Script: #!/bin/ksh if ] ; then test.sql fi My Sql Informix DB: echo "select * from table where col1 = 2234 and col2 = '$3'"|dbaccess ddname But im getting `:' unexpected error

9. Shell Programming and Scripting

Unable to pass value from .Shell script to .SQL file

Hi All, I am new to shell script. I am trying to pass value from .sh file to .sql file . But I am able to run the .sql file from .sh file with values in sql file. But I am unable to pass the values from .sh file. can some one please help to resolve this. here is my .sh file s1.sh ...

10. Shell Programming and Scripting

Need script to pass all sql file names in a directory to DB query

Hi All, In this path /home/all_files we have follwing files and direcotries proc_edf_sot.sql proc_ssc_sot.sql func_dfg_sot.sql sot unic cmr sdc under sot directory we have other directories sql pas ref under sql directory we have sql_sot sql_mat

LEARN ABOUT REDHAT

xtnumber

XtOffset(3Xt)							   XT FUNCTIONS 						     XtOffset(3Xt)

NAME

       XtOffset, XtOffsetOf, XtNumber - determine the byte offset or number of array elements

SYNTAX

       Cardinal XtOffset(pointer_type, field_name)
	     Type pointer_type;
	     Field field_name;

       Cardinal XtOffsetOf(structure_type, field_name)
	     Type structure_type;
	     Field field_name;

       Cardinal XtNumber(array)
	     ArrayVariable array;

ARGUMENTS

       array	 Specifies a fixed-size array.

       field_name
		 Specifies the name of the field for which to calculate the byte offset.

       pointer_type
		 Specifies a type that is declared as a pointer to the structure.

       structure_type
		 Specifies a type that is declared as a structure.

DESCRIPTION

       The XtOffset macro is usually used to determine the offset of various resource fields from the beginning of a widget and can be used at
       compile time in static initializations.

       The XtOffsetOf macro expands to a constant expression that gives the offset in bytes to the specified structure member rom the beginning of
       the structure.  It is normally used to statically initialize resource lists and is more portable than XtOffset, which serves the same func-
       tion.

       The XtNumber macro returns the number of elements in the specified argument lists, resources lists, and other counted arrays.

SEE ALSO

       XtGetResourceList(3Xt), XtSetArg(3Xt)
       X Toolkit Intrinsics - C Language Interface
       Xlib - C Language X Interface

X Version 11							    Release 6.6 						     XtOffset(3Xt)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to pass enviroment variable from csh to Informix sql script

Discussion started by: jwoj

2. Shell Programming and Scripting

Pass variable to sql

Discussion started by: killboy

3. Shell Programming and Scripting

Pass a variable to SQL script

Discussion started by: mac4rfree

4. Shell Programming and Scripting

how to pass a variable to an update sql statement inside a loop

Discussion started by: ryukishin_17