Dear Friends,
Please help me to achieve the following:
I want to pass one parameter from Shell-script to Sql-script.
Example:
My ShellScript.sh is calling report.sql like this:
/bin/sqlplus /reports.sql
And
My report.sql is calling many Stored-Procedures like this:
exec... (0 Replies)
hi all
please tell me how to pass parameters 4m shell script to a DataBase stored procedure.
To be specific i have sybase DB.
i mean i want the syntax of the command..
how to connect to DB, pass user id and password, pass the required parameter to SP..
..
need ur help frnds..
hema (0 Replies)
Hi All,
I have a 2 files. File1 i am generating using an ETL tool, which is a comman seperated delimited file which contains country code & load date.
everytime, this country code will be updated from a table. It might be AB or BA & ld_date will be for which date we need to load the file.
... (7 Replies)
Hi,
I've been trying to write a regex to use in egrep (in a shell script) that'll fetch the names of all the files that match a particular pattern. I expect to match the following line in a file:
Name = "abc"
The regex I'm using to match the same is:
egrep -l '(^) *= *" ** *"$' /PATH_TO_SEARCH... (6 Replies)
I would like to run a compress script on files in certain directories.
My compress_script.sh is just basically
compress file*
In order for me to use this I have to copy it into each directory and run it.
How can I state the directory on the command line with the compress script so it... (2 Replies)
OS SCO Open Server 6.0 MP4
I am trying to change the value of a enviornment variable thru a script and want to pass a parameter on the commande line, If I hard code the value inside the script the script changes the enviornment variable
. mytest
where my test is
MYVAR=$1
export MYVAR... (6 Replies)
Hi,
I have one shell script which use two parameter however one of its parameter have space in between.
eg.
a.sh 20110114 b c d
here b c d is one parameter
I used 'b c d' but its not giving correct result.
Also i tried b\c\d but this one also didnt work.
Any help would be... (5 Replies)
Hi
i have a shell script which needs a string as an input parameter. How to pass the string param as an input?
In command line am running the script.
for e.g.,
a="who is a buddy?"
sh sample.sh $a
Inside the script i get this input param as $1 but only the value "who" is accepted... (12 Replies)
Hi All,
I'm new to Linux and scripting, apologies in advance for 'stupid' questions.
Please help... Im writing a script that calls a sqlplus script but the sqlplus requires inputs and i cant seem to get this to work.
here is my code.
#!/bin/sh
TERM=vt100
export TERM... (4 Replies)
I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist.
diff=$1$2.diff
id=$2 new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff |... (1 Reply)
Discussion started by: Sarita Behera
1 Replies
LEARN ABOUT DEBIAN
fsgateway
FSGATEWAY(1) General Commands Manual FSGATEWAY(1)NAME
fsgateway - FUSE module to browse database's metadata, sugar datastores and xml files
SYNOPSIS
mono fsgateway storage_type connection_string [fuse_option] mountpoint
DESCRIPTION
FsGateway allows you to use your preferred directory navigation tool to inspect a database's metadata, sugar datastores and xml files.
FsGateway allows you to compare two database structures in an easy way using the diff tool, or to find where a field is defined using the
grep tool.
storage_type can be:
tagfs
You must provide the root directory of tree to examine as connection_string parameter.
xmlfs
You must provide the need the XML file to read as connection_string parameter.
postgresql
Specify the connection_string parameter like this one:
Server=localhost; Database=mydb; User ID=username; Password=password; Port=5432;
sugar_datastore
You must specify the directory used by the Sugar datastore as connection_string parameter.
MySQL5
Specify the connection_string parameter like this one:
Server=localhost; Database=mydb; User ID=username; Password=password; Port=3306;
SqlServer
Specify the connection_string parameter like this one:
Server=localhost,port; Database=mydb; User ID=username; Password=password;
or like this one:
Server=localhost,port; Database=mydb; User ID=domainnameusername; Password=password; Integrated Security=SSPI
For detail information about the parameters connection look at http://www.mono-project.com/SQLClient
SEE ALSO fusermount(1)AUTHOR
fsgateway was written by Torello Querci <torello@torosoft.com>
This manual page was written by Marco Nenciarini <mnencia@debian.org>, for the Debian project (and may be used by others).
January 2010 FSGATEWAY(1)