Hi
I want to get the a field from a SQL query into unix shell script variable. the whole situation is like this.
1. Opened a cursor to a table in DB2 databse.
2. Fetching individual rows with the help of cursor.
3. Each row has 4 fields.
I want each of the field in individual shell... (1 Reply)
Hi
I would like to know if there is a way to just have one ORACLE connection established, using which we can execute different queries and store the results under different variables.
For e.g the following uses to two silent ORACLE connection to store the result under two different... (4 Replies)
Can someone tell me why I'm getting error when I try to run this?
#!/bin/csh -f
source ~/.cshrc
#
set SQLPLUS = ${ORACLE_HOME}/bin/sqlplus
#
set count=`$SQLPLUS -s ${DB_LOGIN} << END
select count(1) from put_groups where group_name='PC' and description='EOD_EVENT' and serial_number=1;... (7 Replies)
I want to store the sql query output into a variable
#!/bin/ksh
ORACLE_SID=DB01;
export ORACLE_SID;
export FILE_PATH=/home/asg/Tmp
# Order Checking
echo " removing old files "
rm $FILE_PATH/Malformed_Order.txt
echo " Enter the Malformed Order ....!"
read orders
echo "Regrade... (5 Replies)
While assisting a forum member, I recommended running SQL/Plus in a coprocess (to make database connections and run a test script) for the duration of his script rather than starting/stopping it once for every row in a file he was processing.
I recalled I made a coprocess example for folks at... (2 Replies)
Hello everyone,
I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected.
I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
Hello,
I am very new to shell scripting and I am not sure of how best to handle the following scenario. I need to query a list of values from a table. I need to store those results and use them to selectively delete values in yet another table in a separate database. I do know how to store the... (3 Replies)
Hi,
I am new to linux...
How to Assign SQL Query Results to Variables in Linux,i want ti generate it in param files, Can anyone please explain me.
Ex: SQL> Select * from EMP;
O/P: Emp_No Emp_Name
1 AAA
2 BBB
3 CCC
and I want expected... (5 Replies)
Using ksh, I am using SQLPlus to execute a query with a filter using a string variable.
REPO_DB=DEV1
FOLDER_NM='U_nmalencia'
FOLDER_CHECK=$(sqlplus -s /nolog <<EOF
CONNECT user/pswd_select@${REPO_DB}
set echo off heading off feedback off
select subj_name
from subject
where... (5 Replies)
Discussion started by: nkm0brm
5 Replies
LEARN ABOUT DEBIAN
wiki::toolkit::setup::mysql
Wiki::Toolkit::Setup::MySQL(3pm) User Contributed Perl Documentation Wiki::Toolkit::Setup::MySQL(3pm)NAME
Wiki::Toolkit::Setup::MySQL - Set up tables for a Wiki::Toolkit store in a MySQL database.
SYNOPSIS
use Wiki::Toolkit::Setup::MySQL;
Wiki::Toolkit::Setup::MySQL::setup($dbname, $dbuser, $dbpass, $dbhost);
Omit $dbhost if the database is local.
DESCRIPTION
Set up a MySQL database for use as a Wiki::Toolkit store.
FUNCTIONS
setup
use Wiki::Toolkit::Setup::MySQL;
Wiki::Toolkit::Setup::MySQL::setup($dbname, $dbuser, $dbpass, $dbhost);
or
Wiki::Toolkit::Setup::Mysql::setup( $dbh );
You can either provide an active database handle $dbh or connection parameters.
If you provide connection parameters the following arguments are mandatory -- the database name, the username and the password. The
username must be able to create and drop tables in the database.
The $dbhost argument is optional -- omit it if the database is local.
NOTE: If a table that the module wants to create already exists, "setup" will leave it alone. This means that you can safely run this
on an existing Wiki::Toolkit database to bring the schema up to date with the current Wiki::Toolkit version. If you wish to completely
start again with a fresh database, run "cleardb" first.
cleardb
use Wiki::Toolkit::Setup::MySQL;
# Clear out all Wiki::Toolkit tables from the database.
Wiki::Toolkit::Setup::MySQL::cleardb($dbname, $dbuser, $dbpass, $dbhost);
or
Wiki::Toolkit::Setup::Mysql::cleardb( $dbh );
You can either provide an active database handle $dbh or connection parameters.
If you provide connection parameters the following arguments are mandatory -- the database name, the username and the password. The
username must be able to drop tables in the database.
The $dbhost argument is optional -- omit if the database is local.
Clears out all Wiki::Toolkit store tables from the database. NOTE that this will lose all your data; you probably only want to use this
for testing purposes or if you really screwed up somewhere. Note also that it doesn't touch any Wiki::Toolkit search backend tables; if
you have any of those in the same or a different database see either Wiki::Toolkit::Setup::DBIxFTS or Wiki::Toolkit::Setup::SII,
depending on which search backend you're using.
ALTERNATIVE CALLING SYNTAX
As requested by Podmaster. Instead of passing arguments to the methods as
($dbname, $dbuser, $dbpass, $dbhost)
you can pass them as
( { dbname => $dbname,
dbuser => $dbuser,
dbpass => $dbpass,
dbhost => $dbhost
}
)
or indeed as
( { dbh => $dbh } )
Note that's a hashref, not a hash.
AUTHOR
Kake Pugh (kake@earth.li).
COPYRIGHT
Copyright (C) 2002-2004 Kake Pugh. All Rights Reserved.
Copyright (C) 2006-2008 the Wiki::Toolkit team. All Rights Reserved.
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
Wiki::Toolkit, Wiki::Toolkit::Setup::DBIxMySQL, Wiki::Toolkit::Setup::SII
perl v5.14.2 2011-09-25 Wiki::Toolkit::Setup::MySQL(3pm)