Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Executing DB2 command without using the DBI module

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Executing DB2 command without using the DBI module
# 1  
Old 05-28-2010
Executing DB2 command without using the DBI module
Hi Guys,

I wonder if possible to execute a Db2 commands within a perl scripts without installing or invoking the DBI modules. I have a script that is written in kron shell and it looks like :


DB=`db2 list db directory | egrep "Database alias|Directory entry type"|awk '{printf $0 ; getline; print $0}'| grep "Indirect" | awk '{print $4 }'`
for DATABASE in $DB ;
do
db2 connect to $DATABASE
export CONN=$?
db2 "select count(*) from sysibm.sysdummy1"
export SEL=$?
db2 terminate
export TER=$?
if [[ $CONN -ne 0 || $SEL -ne 0 || $TER -ne 0 ]]; then
print " Error has occured connecting to $DATABASE on hostname : `hostname`"
print " Error has occured connecting to $DATABASE on hostname : `hostname`"
fi
done


and I would like to rewrite it in perl if I don't have to install the DBI modules. Has anyone done it before or it is possible. thanks.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Issue on executing db2 queries through shell script

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

2. UNIX for Dummies Questions & Answers

Db2 command issues with cron

Hi, I have a very simple script that queries from a DB2 table. The script has 3 parts - (i) Sets the db2profile (ii) connects to db2 using credentials (iii) executes the query.This script works fine if i run it manually from the command prompt. However when scheduled in crontab, it proceeds... (2 Replies)
Discussion started by: VeePee
2 Replies

3. Shell Programming and Scripting

DB2: load command in unix

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

4. Shell Programming and Scripting

Help in executing the following db2 sql querry in unix

Hi All, Please help me out in executing the following db2 querry in unix db2 "select AP_RQ_ACQ_INST_ID || ',' || txn_classifier || ',' || AP_RS_RESP_CD || ',' || (count(*) AS COUNT1) || ',' || (SUM(AP_RQ_TXN_AMT) AS TOTAL_AMT) from TXN_RECORD where CREATE_TS > '2010-11-22 11:00:00.008645' ... (1 Reply)
Discussion started by: dudd9
1 Replies

5. UNIX for Advanced & Expert Users

Perl's DBI Module on OS X - uninstallable?

i've been struggling with installing the Perl DBI & DBD modules all weekend, and I'm getting close, but no cigar as of yet. When I run the perl script db.pl I get the following mismatch error: Mon Apr 19 09:43:29 EDT 2010 /Library/Perl/DBD-mysql-4.011 -> peterv@MBP17.local<515>$: db.pl | tee... (0 Replies)
Discussion started by: peterv6
0 Replies

6. AIX

db2 command on the AIX mechine

Hello, can any one help me to debug the following command. db2 -stec +pc ; Regards, SM (2 Replies)
Discussion started by: smolgara
2 Replies

7. Programming

perl dbi to oracle getting disconnect_all for oracle dbi help

hi i am trying to connect to an oracle database using dbi and i get this :: Driver has not implemented the disconnect_all method. at /opt/perl/lib/site_perl/5.8.0/sun4-solaris/DBI.pm line 575 END failed--call queue aborted. for all i know, the script was working earlier, but has... (1 Reply)
Discussion started by: poggendroff
1 Replies

8. Shell Programming and Scripting

perl DBI/DBD Module -in cygwin

Hi all, I am trying to install the DBI module in perl using perl -MCPAN -e shell install 'DBI' --It is installing into the nuild directory properly but when it try to make it is saying NOT OK -I tried to copy the module manually to the /lib/perl5/vendor_perl ... (3 Replies)
Discussion started by: jambesh
3 Replies

9. Shell Programming and Scripting

for loop with db2 command

Having some trouble with usage of for loop and displaying words. Basically I had 3 words( some times more ) in the variable. I want to get one at a time to process. I am new to unix scripting so please bear with my question and appreciate your reply. I think this can also me done my awk... (1 Reply)
Discussion started by: Vaddadi
1 Replies

10. Shell Programming and Scripting

PERL DBI module install

We ran into an issue trying to install DBI and DB2 modules for perl for AIX from the link http://www-306.ibm.com/software/data/db2/perl/ We tried to install the DBI module using bash# perl -MCPAN -e 'install DBI' command. However we ended up with the following error. Stop. ... (3 Replies)
Discussion started by: jerardfjay
3 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

sql::reservedwords::db2

SQL::ReservedWords::DB2(3pm)				User Contributed Perl Documentation			      SQL::ReservedWords::DB2(3pm)

NAME

       SQL::ReservedWords::DB2 - Reserved SQL words by DB2

SYNOPSIS

	  if ( SQL::ReservedWords::DB2->is_reserved( $word ) ) {
	      print "$word is a reserved DB2 word!";
	  }

DESCRIPTION

       Determine if words are reserved by DB2.

METHODS

       is_reserved( $word )
	   Returns a boolean indicating if $word is reserved by either DB2 5, 6, 7 or 8.

       is_reserved_by_db2v5( $word )
	   Returns a boolean indicating if $word is reserved by DB2 5.

       is_reserved_by_db2v6( $word )
	   Returns a boolean indicating if $word is reserved by DB2 6.

       is_reserved_by_db2v7( $word )
	   Returns a boolean indicating if $word is reserved by DB2 7.

       is_reserved_by_db2v8( $word )
	   Returns a boolean indicating if $word is reserved by DB2 8.

       reserved_by( $word )
	   Returns a list with DB2 versions that reserves $word.

       words
	   Returns a list with all reserved words.

EXPORTS

       Nothing by default. Following subroutines can be exported:

       is_reserved
       is_reserved_by_db2v5
       is_reserved_by_db2v6
       is_reserved_by_db2v7
       is_reserved_by_db2v8
       reserved_by
       words

SEE ALSO

       SQL::ReservedWords

       <http://www-306.ibm.com/software/data/db2/udb/>

AUTHOR

       Christian Hansen "chansen@cpan.org"

COPYRIGHT

       This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.8.8							    2008-03-28					      SQL::ReservedWords::DB2(3pm)