05-02-2008
9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
hello -
Is it possible to connect to a database at the command line to an Oracle instance whilst logged in on the unix box i.e. not using a script
Cheers
(Running Solaris)
Also if anyone has any info on how a Citirix ICA client might be helpful here that would be appreciated
Cheers (1 Reply)
Discussion started by: penfold
1 Replies
2. Shell Programming and Scripting
I am trying to connect to database db2 through shell script.
The process I am trying is
> db2
It gives me error Access Denied.
While checking for access I have the rights.
Is there ant other way round..?
Please help. (3 Replies)
Discussion started by: ankitgupta
3 Replies
3. UNIX for Dummies Questions & Answers
Hello ,
i have a problem in writing the shell script..
i have a script already written n just need to make a change in which when the script is not able to connect to the database ..it should print an error msg on the screen.
I have already seen previous posts on how to connect to the... (3 Replies)
Discussion started by: sommer_queen
3 Replies
4. UNIX for Advanced & Expert Users
I am trying to develop a script that can connect to a DB2 database mainframe and Query the database and display the results. I've been researching, but I have yet to find a definitive solution where I can enter in the Mainframe DB2 address db2:// and query the database and return the results. If... (2 Replies)
Discussion started by: developncode
2 Replies
5. Shell Programming and Scripting
Hi,
I have a shell script to query the database to get the statistics of tables like sum,max,min,etc of all numeric columns,max and min of date columns and length of varchar columns for each and every table. There are nearly 1600 tables. My script queries few tables like about 100 tables and... (3 Replies)
Discussion started by: ragavhere
3 Replies
6. Shell Programming and Scripting
Hi all,
I am satyakiran , i am new to the forum. i never done shell scripts for connecting to the data base (oracle) and fetching the data from the database( thru sql select statements ) i want to know
1. how to connect to the data base(oracle) using shell script
2. how to retrieve data... (8 Replies)
Discussion started by: satyakiran
8 Replies
7. Shell Programming and Scripting
I need to pass a variable as a parameter from shell script into a DB2 database.
var=bhuk_1123_Q_11/22/09
select * from tbl1 where serial_id='$var';
I have tried executing it using
db2 -tvf scriptname
Somebody please help me out with this. It is throwing an error. Please tell me how... (2 Replies)
Discussion started by: ss3944
2 Replies
8. Shell Programming and Scripting
I am rather new to korn shell scripting and attempting to write a Unix script that would detach, attach a range partition table in DB2 UDB LUW database. This would be a job scheduled in control M that reads in an input file with 5 parameters passed to it from the application. I don't have much... (1 Reply)
Discussion started by: tjhanso
1 Replies
9. Shell Programming and Scripting
Hi experts.
I have different database and schema and their passwords in one file.
In Unix : I want to create the script that connect the sqlplus and execute the select query one by one schema with different database.
Ex: password File Format
databse schemaname password
DB1 name1 ... (1 Reply)
Discussion started by: abhigrkist
1 Replies
LEARN ABOUT PHP
pdo_ibm-dsn
PDO_IBM-DSN(3) 1 PDO_IBM-DSN(3)
PDO_IBM DSN - Connecting to IBM databases
The PDO_IBM Data Source Name (DSN) is based on the IBM CLI DSN. The major components of the PDO_IBM DSN are:
o DSN prefix
- The DSN prefix is ibm:.
o DSN
- The DSN can be any of the following:
o a) Data source setup using
db2cli.ini or odbc.ini
o b) Catalogued database name i.e. database alias in the DB2 client catalog
o c) Complete connection string in the following format: DRIVER={IBM DB2 ODBC DRIVER};DATABASE=
database;HOSTNAME= hostname;PORT= port;PROTOCOL=TCPIP;UID= username;PWD= password; where the parameters represent the fol-
lowing values:
o $database
- The name of the database.
o $hostname
- The hostname or IP address of the database server.
o $port
- The TCP/IP port on which the database is listening for requests.
o $username
- The username with which you are connecting to the database.
o $password
- The password with which you are connecting to the database.
Example #1
PDO_IBM DSN example using db2cli.ini
The following example shows a PDO_IBM DSN for connecting to an DB2 database cataloged as DB2_9 in db2cli.ini:
$db = new PDO("ibm:DSN=DB2_9", "", "");
[DB2_9]
Database=testdb
Protocol=tcpip
Hostname=11.22.33.444
Servicename=56789
Example #2
PDO_IBM DSN example using a connection string
The following example shows a PDO_IBM DSN for connecting to an DB2 database named testdb using the DB2 CLI connection string syn-
tax.
$db = new PDO("ibm:DRIVER={IBM DB2 ODBC DRIVER};DATABASE=testdb;" .
"HOSTNAME=11.22.33.444;PORT=56789;PROTOCOL=TCPIP;", "testuser", "tespass");
PHP Documentation Group PDO_IBM-DSN(3)