Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Parameter passing in a function
Top Forums UNIX for Advanced & Expert Users Parameter passing in a function Post 302080291 by fastgoon on Monday 17th of July 2006 02:06:03 PM
Old 07-17-2006
Parameter passing in a function
I need to pass a parameter to a function in a script. My parameter is a string. When I display the parameter within my function, I only get the first word from string I pass in.

How can I make the function receive the whole string (and not terminate at the first space it encounters)?.

part of the script I am executing

$strExtractQuery="select TRAN_I from TRAN with UR"
echo "SQL to be validated: " ${strExtractQuery}
sql_validate ${strExtractQuery}

function sql_validate # Accepts 1 parameter
{
Sqltext=$1
echo "In sql validate " : ${Sqltext}
}

Output
SQL to be validated: select TRAN_I from TRAN with UR
In sql validate 1 : select


Any help?


Thanks
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Passing a string parameter to a function

I need to pass a parameter to a function in a script. My parameter is a string. When I display the parameter within my function, I only get the first word from string I pass in. How can I make the function receive the whole string (and not terminate at the first space it encounters)?. part of... (1 Reply)
Discussion started by: fastgoon
1 Replies

2. Shell Programming and Scripting

parameter passing

Hallo everyone, This is my problem below: /home/cerebrus/pax=>vat class2.sh ksh: vat: not found /home/cerebrus/pax=>cat class2.sh #!/bin/ksh set -x bdf|grep appsdev|awk '{ print $5 }'> class3 dd={cat class3} echo $dd /home/cerebrus/pax=> /home/cerebrus/pax=>./class2.sh + bdf +... (8 Replies)
Discussion started by: kekanap
8 Replies

3. Shell Programming and Scripting

wrong parameter passing!

Hi all I have a script which will take input as filename and passes it to a java program. It is as follows -------------------------------- FILENAME=$1 echo $FILENAME ${JAVA_HOME}/bin/java -cp DateProvider $FILENAME ------------------------------------------------- when I execute the same... (2 Replies)
Discussion started by: malle
2 Replies

4. Shell Programming and Scripting

Passing global variable to a function which is called by another function

Hi , I have three funcions f1, f2 and f3 . f1 calls f2 and f2 calls f3 . I have a global variable "period" which i want to pass to f3 . Can i pass the variable directly in the definition of f3 ? Pls help . sars (4 Replies)
Discussion started by: sars
4 Replies

5. Shell Programming and Scripting

Positional parameter passing

Hi All, When passing parameters to a sheel script, the parameters are referenced by their positions such as $1 for first parameter, $2 for second parameter. these positional values can only have values ranging from $0-$9 (0,1,2,3...9). I have a shell script meant to accept 20 parameters. for... (3 Replies)
Discussion started by: ogologoma
3 Replies

6. Shell Programming and Scripting

Passing sql as parameter to unix function

Hi, I have a function which connects to the db and runs the sql. it works fine when I run it like: function "select empname from emp;" but when I try to pass the sql string to a variable which in turn in fed to the function , it throws error. please advise. Thanks, Arnie. (1 Reply)
Discussion started by: itsarnie
1 Replies

7. Shell Programming and Scripting

Passing parameter to script, and split the parameter

i am passing input parameter 'one_two' to the script , the script output should display the result as below one_1two one_2two one_3two if then echo " Usage : <$0> <DATABASE> " exit 0 else for DB in 1 2 3 do DBname=`$DATABASE | awk -F "_" '{print $1_${DB}_$2}` done fi (5 Replies)
Discussion started by: only4satish
5 Replies

8. Shell Programming and Scripting

Passing parameter more than 9

Hi, I've written a script where eleven parameter to be passed from command line which is inserting into an oracle table, it is working but the tenth and 11th parameter are not accepting as given it is referring to 1st parameter. HERE IS THE SCRIPT #!/bin/ksh #set -o echo $*... (4 Replies)
Discussion started by: sankar
4 Replies

9. Shell Programming and Scripting

Passing command as a function parameter

Hi All, Just trying to implement the below shell script using AIX ksh shell. myfunc { eval "$*" } CMD='ls -la /etc/hosts | awk '{print $9"|"$5}'' myfunc $CMD Keeping getting "|}: not found" errors, any pointers would greatly be appreciated. Kind Regards Ed Please... (2 Replies)
Discussion started by: eo29
2 Replies

10. Programming

Parameter passing to function with void * as Argument

Earlier I had one structure C typedef struct c { int cc; }CS; I used to call a library function say int GetData(CS *x) which was returning me the above structure C with data. GetData(CS *x) Function call used to be like: CS CSobj; GetData(&CSObj); Now there are two... (12 Replies)
Discussion started by: rupeshkp728
12 Replies

LEARN ABOUT DEBIAN

oar-database

oar-database(1) 						   OAR commands 						   oar-database(1)

NAME

       oar-database - create/initialize/upgrade/reset/drop the oar database

SYNOPSIS

       oar-database --create  [OPTIONS]

       oar-database --drop    [OPTIONS]

       oar-database --setup   [OPTIONS]

       oar-database --reset   [OPTIONS]

DESCRIPTION

       Manage the oar database.

       --setup
	   Initialize/Upgrade an existing database.

       --reset
	   Reset an existing database.

       --create
	   Create and initialize a new database/user.

       --drop
	   Drop an existing database/user.

OPTIONS

   General parameters
       --conf=OAR_CONF_FILE
	   Define the oar configuration file to use. By default /etc/oar/oar.conf is used. This file doesn't exist, the default parameters for
	   each value are used.

       --update-conf
	   The database parameters given in the command line are writen to the OAR_CONF_FILE

       -h,--help
	   Display this help.

       -d,--debug
	   Display more information during the script execution

       -f,--force-sql
	   Force to resume the execution even if an sql instruction fails

       -y,--force-yes
	   This option will cause oar-database to continue without prompting if it is doins something potentially harmful

   Database admin parameters
       These parameters are only needed for database/user creation or removing.

       --db-is-local
	   For --create or --drop, this option tells that the database is local. oar-database can use local admin account to execute command
	   (useful for postgres).

       --db-admin-user=DB_ADMIN_USER
	   For --create or --drop, this option gives the privilegied user to use.

       --db-admin-pass=DB_ADMIN_PASS
	   For --create or --drop, this option gives the privilegied user pass to use.

   SQL parameters
       By default, if not specified, all the sql parameters are taken from the OAR_CONF_FILE. It is preferable to set these values directly to
       this file.

       --db-type=DB_TYPE
	   The type of the SQL database. It can be currently, mysql or Pg (for postgresql).

       --db-user=DB_USER
	   Connect to the database as the user DB_USER instead of the one given in OAR_CONF_FILE. By default, if OAR_CONF_FILE doesn't specify a
	   user, it is oar.

       --db-pass=DB_PASS
	   Connect to the database with the password DB_PASS instead of the one given in OAR_CONF_FILE.

       --db-host=DB_HOST
	   Connect to the database on the host DB_HOST, By default, if OAR_CONF_FILE doesn't specify a host, it is localhost.

       --db-port=DB_PORT
	   Connect to the database on the port DB_PORT, By default, if OAR_CONF_FILE doesn't specify a port, the value depend on the DB_TYPE. if
	   DB_TYPE is mysql, DB_PORT is 3306. If DB_TYPE is postgresql, DB_PORT is 5432.

       --db-name=DB_NAME
	   Connect to the database on the host DB_HOST, By default, if OAR_CONF_FILE doesn't specify a database name, it is oar.

       --db-ro-user=DB_RO_USER
	   same as --db-user except that it is for the read only access.

       --db-ro-pass=DB_RO_PASS
	   same as --db-pass except that it is for the read only access.

EXAMPLES

   Mysql
       First you need to specify the sql parameters in /etc/oar/oar.conf. These parameters will be used by oar-database.

       To create a new database (assuming that the sql root password is PASS):

       oar-database --create --db-admin-user root --db-admin-pass PASS

       To upgrade an existing database:

       oar-database --setup

   Postgresql
       First you need to specify the sql parameters in /etc/oar/oar.conf. These parameters will be used by oar-database. Then if your postgresql
       database is on the local system, you can use the option --db-is-local (otherwise, the procedure is the same as Mysql). So oar-database will
       use the postgres unix user to administrate the database (you need privilegied access to the local system).

       To create a new database:

       oar-database --create --db-is-local

       To upgrade an existing database:

       oar-database --setup

   Advanced usages
       To make some tests or to administrate several databases, you can also specify the sql parameters on the command line. For example:

       oar-database --create --db-type=Pg --db-host=HOST 
		      --db-user=oar --db-pass=PASS 
		      --db-admin-user=ADMIN_USER --db-admin-pass=ADMIN_PASS

       will create the oar database and the oar user on the postgresql system hosted by HOST. The user ADMIN_USER must have the right to create
       new databases and new roles on this system.

FILES

       /usr/lib/oar/database/mysql_structure.sql, /usr/lib/oar/database/pg_structure.sql
	   SQL instructions for creating the structure of the oar database.

       /usr/lib/oar/database/mysql_default_admission_rules.sql, /usr/lib/oar/database/pg_default_admission_rules.sql
	   SQL instructions for inserting the default admission rules in the oar database.

       /usr/lib/oar/database/default_data.sql
	   SQL instructions for inserting the default data in the oar database.

       /usr/lib/oar/database/mysql_reset_structure.sql, /usr/lib/oar/database/pg_reset_structure.sql
	   SQL instruction for emptying an existing oar database.

       /usr/lib/oar/database/mysql_structure_upgrade_*.sql, /usr/lib/oar/database/pg_structure_upgrade_*.sql
	   SQL instructions for upgrading an existing database.

oar-database							    2012-06-26							   oar-database(1)
All times are GMT -4. The time now is 01:49 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy