Pass multiple variables to SQL script Post: 30694

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

put value of multiple sql statements into unix variables

i want to use multple sql count statements and store these count values in unix variable but in one connection only i.e. in only 1 time database should be hit ,which is the main requirement.

2. Shell Programming and Scripting

pass variables from one script to another

HI all I am calling a script "b" from script "a". In script "a", i connect to database and get month and year. I have to pass these same values to script b. How can i do that. How can i pass parameters from one script to another

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

sql output from multiple rows and columns as variables in a script

This is for an Oracle journal import. I was using a pl/sql package and oracle API's. Oracle added invoker rights to their API's and now my package won't run. I didn't want to use their API's anyway. The only reason i was using pl/sql and the API's (just a package) was to utilize a cursor. How...

5. UNIX for Advanced & Expert Users

How to use parameter in sql script pass from unix script?

Hi, I am unable to use parameter in sql script passed from unix script. my sql script CREATE_SBI_LIST_GROUP.sql is like this - ------------------------------- SELECT SDS.ID "SO_ID", SDS.SO a1, sgp.sga__code SGA_CODE, FROM sga sga,sales_genl_provision sgp , comm_product_condn cpc...

6. Shell Programming and Scripting

pass null value to sql script from korn shell script

There are 4 parameters that I have to pass from korn shell to sql script. 1) I have to check if $1 , $2 , $3 and $4 are null values or not . How can I do that ? 2) Once its determined that these values are null (in the sense they are empty) how can I pass null values to sql script...

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

How to store results of multiple sql queries in shell variables in ksh?

Hi, I have a script where I make a sqlplus connection. In the script I have multiple sql queries within that sqlplus connection. I want the result of the queries to be stored in shell variables declared earlier. I dont want to use procedures. Is there anyway else. Thanks in advance.. Cheers

9. Shell Programming and Scripting

How to pass Oracle sql script as argument to UNIX shell script?

Hi all, $ echo $SHELL /bin/bash Requirement - How to pass oracle sql script as argument to unix shell script? $ ./output.sh users.sql Below are the shell scripts and the oracle sql file in the same folder. Shell Script $ cat output.sh #!/bin/bash ....

10. UNIX for Advanced & Expert Users

To pass one month range in sql script

Hi Guys, i am having .sql script which inserts data from one table to another table based on date condition, i need to pass range on based on how many number of months, for e.g set timing on; whenever sqlerror exit failure; spool myscript.log append accept start_date...

LEARN ABOUT REDHAT

xltworking

XltWorking(3X)															    XltWorking(3X)

NAME

       XltWorking - Convenience function to display a Working dialog, and update the bar graph in the dialog.

SYNOPSIS

       #include <Xlt/Xlt.h>

       Boolean XltWorking(widget, question, percent_done)
	    Widget    widget;
	    String    question;
	    int       percentdone;

DESCRIPTION

       XltWorking  Creates  a  dialog  containing  a  message string, a bar showing the percentage of the task complete, and an abort button. When
       called with a percent_done value of zero the dialog is managed, and a timer installed to update the bar every second. If  question  is  not
       NULL,  the message string in the dialog is set to this. When called with a percent_done of 100, the dialog is un-managed.  If called with a
       percent_done of -1, only the message is changed. Any value between 0 and 100 will cause the bar graph to be updated the next time the timer
       fires, and processes any pending timer and X events. If the return value is True, the user has requested that the task should be aborted.

       widget The widget to wait for.

       question
	      The message to display in the working dialog. Or NULL, meaning no change.

       percent_done
	      The  percentage  of  the	task complete. 0 will cause the dialog to be managed.  100 will cause the dialog to be un-managed. -1 will
	      update the question only.  Any value between 0 and 100 will update the bar graph.

RETURN VALUE

       Boolean, if True the abort button was pushed, or the window was closed by the window manager.

RELATED INFORMATION

																    XltWorking(3X)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

put value of multiple sql statements into unix variables

Discussion started by: sw@pnil

2. Shell Programming and Scripting

pass variables from one script to another

Discussion started by: vasuarjula

3. Shell Programming and Scripting

Pass a variable to SQL script

Discussion started by: mac4rfree

4. Shell Programming and Scripting

sql output from multiple rows and columns as variables in a script

Discussion started by: lmu