11-02-2012
Try connecting to DB2 outside the script, if you are still not getting any response you should contact your DBA for any assistance.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have a main program which have below lines
-
awk -f test.awk inputFileName
-
I wonder how to check status return from awk script.
content of awk script:
test.awk
---
if ( pass validation )
{
exit 1
}
else
{ (1 Reply)
Discussion started by: epall
1 Replies
2. Shell Programming and Scripting
from my main script, i am calling an expect script. there are a lot of conditions in the Expect script and it can have any exit value based on success or failure of the Expect Script. how can i check the exit status of Expect scritp in the main script. (1 Reply)
Discussion started by: iamcool
1 Replies
3. Shell Programming and Scripting
I want to write a script to check if a unix box say abc.tdc.cin.net can be connected or not on certain port say 22. right know i have to telnet them manually from DOS prompt and if it is successful then isay it is connected.
Also to check Database connectivity I am using tnsping From DOS prompt.... (3 Replies)
Discussion started by: kukretiabhi13
3 Replies
4. Shell Programming and Scripting
So, first and foremost, I'm having issues with my internet connection. Periodically, the connection drops across the network. The fix is simple enough: restart the modem. However, this gets old when the connection dies out every hour.
I can hit my surfboard on 192.168.100.1, and navigate to a... (5 Replies)
Discussion started by: kungfujoe
5 Replies
5. Shell Programming and Scripting
Hi,
Another problem, here is my code
#!/bin/sh
dir='/opt/apps/script/CSV'
datadir='/opt/apps/script/data'
while : ; do
ls -1rt $dir/*.csv > /dev/null 2>&1
if ;then
cp $datadir/weekly.txt $dir/weekly.csv
else
exit 0
fi
done (10 Replies)
Discussion started by: tententen
10 Replies
6. Shell Programming and Scripting
This past weekend I had some issues with my ISP.
So for future purpose I'm going to have some logging on my internet so I'm able to attach log files to my complaint email if this issue reoccurs.
Decided to do a simple ping script that runs every 5 or 10 min with crontab
if ping fail write date... (5 Replies)
Discussion started by: chipmunken
5 Replies
7. Solaris
Hi,
I need to check the sysbase database connectivity through the Unix Shell Script. Can you help me on the how to write the script to test the sysbase database connection.
Thanks in Advance
Nandha (0 Replies)
Discussion started by: nandha2387
0 Replies
8. Shell Programming and Scripting
Hello,
I have a requirement to check the tcp network connectivity between server it's running on and the list of host's and ports combination.
i have written the below code but it doesn't work, but when i execute the nc command outside the script it works fine.
please help me where i am... (8 Replies)
Discussion started by: sknovice
8 Replies
9. Shell Programming and Scripting
Hi everyone!
Some time ago, I had to check connectivity with a big list of hosts, using different formats (protocol://server:port/path/, server:port, ....).
I developed a script that checks the connectivity using different commands (ping, telnet, nc, curl).
It worked for me so I'm sharing it... (9 Replies)
Discussion started by: Fr3dY
9 Replies
10. Shell Programming and Scripting
Hi,
I need a script which check the FTP connections, if its working fine then no issue. Incase not working fine then Trigger the mail.
Please help on this.
Thanks (4 Replies)
Discussion started by: Keshav Kalra
4 Replies
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)