Dynamic case creation based on output list from a command
I am attempting to create a script that would allow me to list all the instances associated with a DB2 and then prompt the user to choose which one to issue the db2profile command against. I use the db2 command db2ilist to get a list of the instances for a particular server, but the number of instances could vary from server to server and I can't figure out how use the results from the db2ilist to create a case.
The output from db2ilist looks like this for example
I created a dumbed down version where I hard coded those instances to create a pick list to demonstrate what I'd like to do.
What I want to create is one script I can run on any server so I'm attempting to do something similar using the output of db2ilist. I can build the pick list, but I'm not sure how I can use that output to dynamically create a case.
posted to wrong thread by accident. I apologize. If you feel like you can help please reply to the post in the correct thread
HI
I want to create a date folder and then a log file under it, which will hold all output of shell script. Say shell script abc.sh runs every day and I want to redirect the output of abc.sh > /opt/bea/wls81/Pkmtest/$(date +%Y%m%d)/ant.log.
Here date should always change according to system... (2 Replies)
Hi Guru's,
Eventhough I know basic shell scripting, Iam not an expert.
Can any one help me to get a logic/answer for the below requirement:
I've to create an output file "outputfile.txt" from many datafiles (ex: abc.dat, xyz.dat).
Header record layout for "outputfile.txt" should be... (7 Replies)
I'm using the korn shell and trying to create a case statement from the contents of a file that is changed regularly,
each line of the file has three fields,
eg
track1 202.111.111.111 99
room7 222.111.222.333 76
I'm using awk to select each variable. I've been unable to figure out how to... (5 Replies)
This my script
ls *.ksh
ls *.ksh > a.txt
i=1
cat "a.txt" | while read a
do
if
then
echo "abc"
echo "abc" > m.ksh
echo "m.ksh" >> a.txt
i=2
fi
echo $a
done
ls *.ksh
--------------------------
My Output is
a.ksh - > first ls *.ksh (1 Reply)
Hi people,
I am writing a korn shell script, and one of the command gives an output something like below:
release.label.2010.03.02
objects:
/project/path/to/some/file_name.ksh
/project/path/another/file_name01.dat
I have to retrieve the file paths one by one & use them as... (9 Replies)
Hello Unix Gurus :
It would be really appreciative if can find a solution for this .
I have records in a file .
I need to Capitalize the records based on condition .
For Example i tried the following Command
COMMAND -->
fgrep "2000YUYU" /export/home/oracle/TST/data.dat | tr '' ''... (12 Replies)
I am attempting to create a script that would allow me to list all the instances associated with a DB2 and then prompt the user to choose which one to issue the db2profile command against. I use the db2 command db2ilist to get a list of the instances for a particular server, but the number of... (7 Replies)
I ran the following command.
cat abc.c > abc.c
I got message the following message from command cat:
cat: abc.c : input file is same as the output file
How the command came to know of the destination file name as the command is sending output to standard file. (3 Replies)
Hi All,
<Re-posting in Correct group>
I'm trying to select all the files in a folder that starts with a particular name format and are created in a gven date range using 'ls' command...but i'm not successful....
Example : I'm trying to see all the text files in a folder who names start... (6 Replies)
I am trying to create some variables based on the input by the user, say if user entered 3 then 3 variables and if 5 then 5 variables.
I am using a for loop
for (( i=1; i <= $num; i++ ))
do
x="num"
x+=$i
done
When i am using echo $x it will show num1 but now how to create variables... (3 Replies)
Discussion started by: Raj999
3 Replies
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)