Hi ,
I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script
Right now no file is generated on the unix box...it is a... (2 Replies)
I am having a shell script which has to be called from a C program. I have to pass two parameters to this script. HOw can I do that?
eg:
int main()
{
char st1;
char str2;
// call a shell script
call_sh(str1,str2) where call_sh is the name of the shell script.
then i need to get the return... (5 Replies)
Hi All,
Does anyone have any solutions for passing back multiple variables back to the SHELL from a call to an ORACLE procedure:
eg
#username='scott'
#password='tiger'
#database='orcl'
username='ITGCD03D03'
password='tC5epIew'
database='ITGCD03D'
sqlplus -s... (4 Replies)
I am using grep to capture date from a file .
Since i need to use the shell script for different dates ,is it possible to pass the date parameter to the shell script
the Script is as below
grep -E "08 Aug 2008|2008-08-08"* somefile.txt>test.txt
The above script file greps the... (1 Reply)
Hi there
I'm new to UNIX scripting; I’m stuck with the following
I have an Oracle SQL script that takes three parameters
1- File Name
2- File Path
3- File creation date
Under UNIX I have a folder where files will be placed frequently and I need to upload those files to Oracle, what I need... (3 Replies)
Hello,
I have this shell script that runs awk code by passing in parameters however now it doesn't work anymore with the parameters and I don't know why.
It removes duplicates from an input file based on a part of the last field and a key column. It removes the record with the older datetime... (0 Replies)
I am trying to execute a copy command via shell script. However, on occassion, 2 or more files need to copied. How do I code for the multiple arguments? Does it matter how the files are delimited?
Example: I have a script to copy files from 1 dir to another called duplicate.csh
In most... (1 Reply)
how can i make a script to run only when parameters are given,
if parameters are not given it should through an error , saying "please enter a parameter"
for ex: i want a find command to run only when the parameters are given (4 Replies)
Hello All,
I am interested in finding out a way to pass parameters that are entered at the prompt from HP unix and passed to SQLPlus code with a Shell Script. Is this possible?
Thanks (4 Replies)
Hi,
I have a query regarding execution of a sql query having long listing of parameters ..I need to execute this query inside a shell script.
The scenario is like....
Suppose I have a file abc.txt that has the card numbers..it could be in thousands..
then I need to fire a query like
... (12 Replies)
Discussion started by: vsachan
12 Replies
LEARN ABOUT CENTOS
odbcinst
odbcinst(1) unixODBC manual pages odbcinst(1)NAME
odbcinst - An unixODBC tool for manipulating configuration files
SYNOPSIS
odbcinst ACTION OBJECT OPTIONS
DESCRIPTION
odbcinst is a command line tool which has been created for allowing people who are developing the install scripts/RPMs for Drivers to be
able to easily create/remove entries in odbc.ini and odbcinst.ini. This command line tool is a complement to the shared library of the same
name (libodbcinst.so). This tool is a part of the odbcinst component of unixODBC.
OPTIONS
ACTIONS
-i Install (add section to config file) new OBJECT.
-u Uninstall (remove section from config file) existing OBJECT.
-q Query the config files and print the options for specified OBJECT.
-j Prints current configuration of unixODBC, listing (among others) the paths to the configuration files.
-c Calls SQLCreateDataSource
-m Calls SQLManageDataSources
--version
Prints program version and exits.
OBJECTS
-d The ACTION affect drivers (and thus the odbcinst.ini configuration file).
-s The ACTION affect data sources (and thus the user or system odbc.ini configuration file).
OPTIONS
-f FILE
The FILE is template file, describing the configuration of installed OBJECT (only valid for the -i ACTION).
-r Same as the -f OPTION, only take the standard input as the template file.
-n NAME
Specifies the NAME of the OBJECT.
-v Turn off verbose mode. This turns off all information, warning and error messages.
-l The specified data source is system-wide. Has any effect only with the -s OBJECT.
-h The specified data source is user-specific. Has any effect only with the -s OBJECT.
RETURN VALUES
This command returns zero on success and non-zero value on failure.
FILES
/etc/odbinst.ini
Configuration file containing all the database drivers specifications. See odbcinst.ini(5) for more details.
/etc/odbc.ini
System-wide data sources specifications. See odbc.ini(5) for more details.
$HOME/.odbc.ini
User-specific data sources specifications. See odbc.ini(5) for more details.
SEE ALSO odbcinst.ini(5), odbc.ini(5)AUTHORS
The authors of unixODBC are Peter Harvey <pharvey@codebydesign.com> and Nick Gorham <nick@easysoft.com>. For the full list of contributors
see the AUTHORS file.
COPYRIGHT
unixODBC is licensed under the GNU Lesser General Public License. For details about the license, see the COPYING file.
version 2.3.1 Wed 26 Jun 2013 odbcinst(1)