10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Guys,
My Motive is, There are some View names in the file with the format of SCHEMA.VIEWNAMe,
I want to read the data from file and parse it to SCHEMA and VIEWNAME and execute DB2 command to get the base Table name.
I can parse easily through AWK but i could not execute db2 commands in... (1 Reply)
Discussion started by: Nandy
1 Replies
2. Shell Programming and Scripting
hi
i am trying to execute db2 queries through shell script. it's working fine but for few queries is not working ( those queries are taking time so the script is not waiting to get the complete the execution of that query )
could you please any one help me on this
is there any wait... (1 Reply)
Discussion started by: bhaskar v
1 Replies
3. Shell Programming and Scripting
Hi,
Im new to DB2.
I need to connect to DB2 from shell script and return the query output back to shell script variable.
this is my code
#!/bin/ksh
db_name=db
db_user=usr
db_pwd=pwd
db2 <<EOSQL
connect to $db_name user $db_user using "$db_pwd"
select count(1) from table
quit
EOSQL ... (3 Replies)
Discussion started by: sup
3 Replies
4. Homework & Coursework Questions
Hi,
I'm new to Linux. I'm working on a database, and need to load data in a database table (which I already created) using shell script.
The table has two columns - Acct_number (not nullable) and date (timestamp).
I'm not able to write a shell script for that. Can any one help me?
... (3 Replies)
Discussion started by: saisudeep
3 Replies
5. Shell Programming and Scripting
I am currently trying to load data from e.txt into tablea. I am getting error.
db2 connect to qw01p user wcs using abc
db2 "LOAD CLIENT FROM /dswork/ECONT/output/interface/e.txt OF DEL MODIFIED BY coldel| SAVECOUNT 0 ROWCOUNT 0 WARNINGCOUNT 0 MESSAGES XTMPRTI1.txt
REPLACE into WCSADM.TABLEA... (1 Reply)
Discussion started by: skatpally
1 Replies
6. Shell Programming and Scripting
Guys,
I am trying to write a shell script that connect to wcsprod database and read the query
#!/bin/ksh
sqlplus -s < connect to wcsprod user wcsadm using pwd >
select * from catentry fetch first 1 row only with ur;
databse: wcsprod
user: wcsadm
pwd: pwd
thanks (1 Reply)
Discussion started by: skatpally
1 Replies
7. Shell Programming and Scripting
How to connect to db2 through shell script using cygwin? (0 Replies)
Discussion started by: supriyat
0 Replies
8. Shell Programming and Scripting
Is there a way to call a shell script via db2 trigger?
I want to wake up a shell script to perform some action if there is a insert action on a db2 table. (1 Reply)
Discussion started by: prasperl
1 Replies
9. Shell Programming and Scripting
Hi All,
I want to connect two tables in DB2 using shell script and then compare the contents of two tables field by field. Could any one please help me in connecting database tables using Unix and retriving data from the same.
Thanks,
Durwas (0 Replies)
Discussion started by: dtidke
0 Replies
10. Shell Programming and Scripting
hi all
need your help.
I am wrting a script that will load data into the table.
then on another load will append the data into the existing table.
Regards
Ankit (1 Reply)
Discussion started by: ankitgupta
1 Replies
DB2_CLOSE(3) 1 DB2_CLOSE(3)
db2_close - Closes a database connection
SYNOPSIS
bool db2_close (resource $connection)
DESCRIPTION
This function closes a DB2 client connection created with db2_connect(3) and returns the corresponding resources to the database server.
If you attempt to close a persistent DB2 client connection created with db2_pconnect(3), the close request is ignored and the persistent
DB2 client connection remains available for the next caller.
PARAMETERS
o $connection
- Specifies an active DB2 client connection.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Closing a connection
The following example demonstrates a successful attempt to close a connection to an IBM DB2, Cloudscape, or Apache Derby database.
<?php
$conn = db2_connect('SAMPLE', 'db2inst1', 'ibmdb2');
$rc = db2_close($conn);
if ($rc) {
echo "Connection was successfully closed.";
}
?>
The above example will output:
Connection was successfully closed.
SEE ALSO
db2_connect(3), db2_pclose(3), db2_pconnect(3).
PHP Documentation Group DB2_CLOSE(3)