Sponsored Content
Top Forums UNIX for Advanced & Expert Users Connecting to DB2 database on Mainframe and Querying DB Post 302192021 by frank_rizzo on Monday 5th of May 2008 11:01:36 PM
Old 05-06-2008
Connecting from Unix to z/OS is not free. You need a license for this.

You need to install and configure DB2 client to do that. Once you have DB2 installed on your UNIX box you will need to catalog the z/OS system and database if you run DB2 Connect locally. If you don't run DB2 Connect locally then you will need to catalog the node to point to the DB2 Connect server.

The script does not point to the server directly

here is a simple example

#!/bin/ksh

db2 connect to yourdb
db2 "select * from your blah.table"
db2 terminate
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to connect to database db2 through Unix Shell Script

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

2. Shell Programming and Scripting

Connecting and Querying DB2 database from Unix Script?

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

3. Shell Programming and Scripting

Querying database from unix

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

4. UNIX and Linux Applications

How to install IBM db2 database server in cygwin ??

Hi folks, I am looking for a clue to install db2 in cygwin.....kindly help.;) (0 Replies)
Discussion started by: frozensmilz
0 Replies

5. Shell Programming and Scripting

Connecting to Database

Hi, I want to write a shell script which connects to a Database, executes a set of SQLs and displays a message for every SQL that was run whether any records have been returned or not? Can anyone help me in this regard? Appreciate your help and concern. Thanks, Dave (1 Reply)
Discussion started by: yoursdavinder
1 Replies

6. Shell Programming and Scripting

Help with loading data from DB2 database to CSV file

Hi everyone!! I need help regarding this. How can we load data from DB2 Database tables into a Comma Separated File? I also have another Question? Using Shell scripting, Is it easy to read Data from a table or from a text file? It is very urgent for me. Please help me out guys. ... (1 Reply)
Discussion started by: ss3944
1 Replies

7. Shell Programming and Scripting

How to pass a variable as a parameter to DB2 database from shell script

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

Connecting database

Hi all, In my concern they gave a task to me do cran job like To write a shell script for To connect a database it should execute a query it should save the output of the query after getting the output it should send a mail to you inbox for every one hour I can able to... (8 Replies)
Discussion started by: thelakbe
8 Replies
FBSQL_DATABASE_PASSWORD(3)						 1						FBSQL_DATABASE_PASSWORD(3)

fbsql_database_password - Sets or retrieves the password for a FrontBase database

SYNOPSIS
string fbsql_database_password (resource $link_identifier, [string $database_password]) DESCRIPTION
Sets and retrieves the database password used by the connection. If a database is protected by a database password, the user must call this function before calling fbsql_select_db(3). If no link is open, the function will try to establish a link as if fbsql_connect(3) was called, and use it. This function does not change the database password in the database nor can it be used to retrieve the database password for a database. PARAMETERS
o $ link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if fbsql_connect(3) was called with no arguments. o $database_password - The database password, as a string. If given, the function sets the database password for the specified link identifier. RETURN VALUES
Returns the database password associated with the link identifier. EXAMPLES
Example #1 fbsql_create_clob(3) example <?php $link = fbsql_pconnect("localhost", "_SYSTEM", "secret") or die("Could not connect"); fbsql_database_password($link, "secret db password"); fbsql_select_db($database, $link); ?> SEE ALSO
fbsql_connect(3), fbsql_pconnect(3), fbsql_select_db(3). PHP Documentation Group FBSQL_DATABASE_PASSWORD(3)
All times are GMT -4. The time now is 04:18 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy