return DB2 SQLCODE

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Return: can only `return' from a function or sourced script

Not sure where the problem is. I can run the script without any issue using the following command. . /opt/app/scripts/cdc_migration.sh But it fails with the below error when I try it this way /opt/app/scripts/cdc_migration.sh /opt/app/scripts/cdc_migration.sh: line 65: return: can only...

2. Shell Programming and Scripting

DB2 in awk

Hi, I want to retrieve the base table name for a table and replace the table with the view name in the file. I was trying to retrieve the base with the below db2 command but i am getting "1" as return value. Could you anyone please assist ? Table_name=system("db2 -x...

3. Shell Programming and Scripting

Return db2 query value to shell script

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 ...

4. Shell Programming and Scripting

Connect db2 using db2 connect

I want to connect to DB2 database which is mainframes using a unix script and run query and get the result set into the unix box. Is this acheivable using db2 connect? pls help me with a sample script which can perform the same.

5. AIX

DB2 basics

Dear friends I am going to study DB2 and i dont have any experience with any DB's.. Please provide me with some links or pdf's for DB2 starters. any advice will be very usefull

6. Shell Programming and Scripting

db2

i want to run a db2 query though shell script but i want my where condition element to chnage everytime like class_nm='abc' next time class_nm='def' next time i want it to do by passing parameters to unix script can someone give example how can i do it

7. UNIX for Advanced & Expert Users

how to get SQLCODE ?

Suppose I am executing a sql query thru shell script. DB : IBM DB2 If none of the rows are fetched, I will be getting the sql code as 100 If rows > 0 are fetched, I will be getting the sqlcode as 0 Can any one help me how to get this SQL code in unix shell script (in KSH) ...

8. UNIX for Dummies Questions & Answers

Exception while loading DB2 driver Class.forName("com.ibm.db2.jcc.DB2Driver")

Hi... I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'...

9. UNIX for Dummies Questions & Answers

to pick up the Return Code ( RC) from the mailx command and return it to SAS uisng 's

Hi All, Can anyone please let me know the syntax / how to pick up the Return Code ( RC) from the mailx command and return it to SAS uisng 'system()' function and '${?}'. I am in a process to send the mail automatically with an attachment to bulk users. I have used 'Mailx' and 'Unencode'...

10. AIX

DB2 Monitoring

Hi everyone. I am currently looking for a monitor to monitor my DB2 UDB database, which runs on AIX 5.3. Does anyone here use any good ones or has anyone heard of any good ones? I especially need to monitor which applications run at any given time, so that I am able to ballance the workload...

LEARN ABOUT DEBIAN

datetime::format::db2

DateTime::Format::DB2(3pm)				User Contributed Perl Documentation				DateTime::Format::DB2(3pm)

NAME

       DateTime::Format::DB2 - Parse and format DB2 dates and times

SYNOPSIS

	 use DateTime::Format::DB2;

	 my $dt = DateTime::Format::DB2->parse_timestamp( '2003-01-16-23.12.01.300000' );

	 # 2003-01-16-23.12.01.300000
	 DateTime::Format::DB2->format_timestamp($dt);

DESCRIPTION

       This module understands the formats used by DB2 for its DATE, TIME, and TIMESTAMP data types.  It can be used to parse these formats in
       order to create DateTime objects, and it can take a DateTime object and produce a string representing it in the DB2 format.

METHODS

       This class offers the following methods.  All of the parsing methods set the returned DateTime object's time zone to the floating time
       zone, because DB2 does not provide time zone information.

       * parse_time($string)
       * parse_date($string)
       * parse_timestamp($string)
	   Given a value of the appropriate type, this method will return a new "DateTime" object.  The time zone for this object will always be
	   the floating time zone, because by DB2 stores the local datetime, not UTC.

	   If given an improperly formatted string, this method may die.

       * format_date($datetime)
       * format_time($datetime)
       * format_timestamp($datetime)
	   Given a "DateTime" object, this methods returns an appropriately formatted string.

SUPPORT

       Support for this module is provided via the datetime@perl.org email list.  See http://lists.perl.org/ for more details.

AUTHOR

       Jess Robinson <castaway@desert-island.demon.co.uk>

       This module was shamelessly cloned from Dave Rolsky's DateTime::Format::MySQL module.

COPYRIGHT

       Copyright (c) 2005 Jess Robinson.  All rights reserved.	This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

SEE ALSO

       datetime@perl.org mailing list

       http://datetime.perl.org/

perl v5.8.8							    2007-01-20						DateTime::Format::DB2(3pm)

Shell Programming and Scripting