Connect to Remote DB2 ,using URL ,username,Password

10 More Discussions You Might Find Interesting

1. HP-UX

Connect to remote server using sftp with password define within command/script

I am trying to connect to remote server in hp-ux, using sftp command (using sftp username@ip and password ) able to connect to remote server but, in this case sftp prompt for password and user need to manually enter it. I want sftp can read a password define in script or from file, so it can...

2. UNIX for Dummies Questions & Answers

How to connect to DB2 using UNIX

I am new to Putty, Unix and DB2 and this is what I am working on right now. I installed Putty I got access to username / pwd I got Unix usrname/Pwd.also got the home directory once I login into putty I get the screen and it shows $ sign From here how do I connect to DB2 database? I have...

3. UNIX for Dummies Questions & Answers

Launch a URL,validate username and password using wget or curl

Hi All, I want to launch "ex: http://gmail.com" from the cmd window and validate the credentials with username and password, is it possible? I have found something like this "wget --http-user=USER' --http-password=PASSWORD http://gmail.com" am new to this and unable to find a solution, i...

4. AIX

AIX Remote Connect Fail With �No more multiple IP addresses to connect� Error

We have a production server at a client site running AIX. And recently when users are trying to connect to it via telnet, it prompts "No more multiple IP addresses to connect". Can I know what does this error mean? and how to rectify this? Thanks.

5. Shell Programming and Scripting

DB2 Connect issue

Hi i m trying to connect DB2 via unix. it is successfully connect. but the connect is getting disconnect . below is the query , countvalue=$(db2 "connect to <Database> user <username> using <Password>" | db2 -x 'select count(*) from <tablename>' ); echo $countvalue while...

6. Shell Programming and Scripting

DB2 Connect Encrypt Password

Hi All, If someone can help me with password encryption. We have shell scripts that connect to a database using db2 connect and we have the password hardcoded in the script. Can someone let me know if there's a way to encrypt this password? I've seen alot of users suggest we create an...

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

8. Shell Programming and Scripting

[SSH] Need to connect to remote server as different user and without password

I have a task requiring that USER_A run a script, which connects to HOST_B as USER_B and does not ask for a password. If I am logged in on HOST_A as USER_B, I can connect to HOST_B without a password, no problem. However, if I try running ssh with the command line "ssh USER_B@HOST_B" while...

9. Shell Programming and Scripting

connect to remote server by applying password

Hi , I am new to shell script. I have to write a shell script which will login to remote server then check for the space there. There 50 remote ervers all are having different password. Could you please suggest me some way. I am working on solaris box. Thanks in advance

10. UNIX for Dummies Questions & Answers

Remote Copy without entering Username and Password

I tried the following script to copy one file automatically: #!/bin/csh -f su - root -c "rcp 150.10.128.1:/export/home/sn408Xl/sn408Sol/$fn $fn This works fine but is there a better way to copy remotely without entering the username and password? Moreover, after the file is copied a...

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