Re: Format of output file using select statements

2003-01-08 Thread Andy Carlson
nt: Tuesday, January 07, 2003 10:36 AM > To: [EMAIL PROTECTED] > Subject: Re: Format of output file using select statements > > > Is there an ODBC driver for Unix and Mysql? > > > Andy Carlson|\ _,,,---,,_ > Se

Re: Format of output file using select statements

2003-01-07 Thread Anthonijsz, Marcel M SITI-ITDSES31
If using perl, please consider using the TSM for PERL module from Jörg Nouvertné at: http://home.wtal.de/the_swordsman/ It returns your data in hashes, i.e. my $arrayref = $tsm->select("* from volumes"); foreach my $element (@$arrayref) { print "$element->{VOLUME_NAME}:\t $element->

Re: Format of output file using select statements

2003-01-07 Thread Bill Boyer
bject: Re: Format of output file using select statements Is there an ODBC driver for Unix and Mysql? Andy Carlson|\ _,,,---,,_ Senior Technical Specialist ZZZzz /,`.-'`'-. ;-;;,_ BJC Health Care

Re: Format of output file using select statements

2003-01-07 Thread Andrew Raibeck
anager" To: [EMAIL PROTECTED] cc: Subject:Re: Format of output file using select statements Is there an ODBC driver for Unix and Mysql? Andy Carlson|\ _,,,---,,_ Senior Technical Specialist

Re: Format of output file using select statements

2003-01-07 Thread Andrew Raibeck
ce. Matt Simpson <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 01/07/2003 06:27 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:Re: Format of output file using select stateme

Re: Format of output file using select statements

2003-01-07 Thread shekhar Dhotre
up status\" $people \< /tmp/file2 .out" ); unlink $filename; unlink $tmpfilename; Matt Simpson <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 01/07/2003 08:27 AM Please respond to "ADSM: Dist Stor Manager" To: [

Re: Format of output file using select statements

2003-01-07 Thread Andy Carlson
Is there an ODBC driver for Unix and Mysql? Andy Carlson|\ _,,,---,,_ Senior Technical Specialist ZZZzz /,`.-'`'-. ;-;;,_ BJC Health Care|,4- ) )-,_. ,\ ( `'-' St. Louis, Missouri

Re: Format of output file using select statements

2003-01-07 Thread Peter Bjoern
>People here have suggested various ingenious combinations of >tail/awk/grep to strip out the garbage, and they work fairly well. >But that seems a little Rube Goldbergish, and I'm a little worried >that it might break if something in the output changes. I think I >already know the answer (No), bu

Re: Format of output file using select statements

2003-01-07 Thread Matt Simpson
At 23:33 -0600 1/6/03, Roger Deschner wrote: Neither of these formats, which were designed to be human-readable, are particularly easy for re-digestion by a computer program of any kind - especially when a field is split across lines. One of the challenges to machine-readable output from dsmadmc

Re: Format of output file using select statements

2003-01-07 Thread Richard Sims
>When I run this on a terminal, it returns a format like: > > DATE_TIME: 2003-01-01 16:30:00.00 > MSGNO: 402 > SEVERITY: I Select *wants* to produce the results in columnar format, and will be able to if the number of columns and their combined width fits into the window width. You can u

Re: Format of output file using select statements

2003-01-06 Thread Roger Deschner
he command line is your friend. >"Good enough" is the enemy of excellence. > > > > >Andy Carlson <[EMAIL PROTECTED]> >Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> >01/02/2003 15:21 >Please respond to "ADSM: Dist Stor Mana

Re: Format of output file using select statements

2003-01-06 Thread Andrew Raibeck
enemy of excellence. Andy Carlson <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 01/02/2003 15:21 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: Format of output file using

Format of output file using select statements

2003-01-02 Thread Andy Carlson
I figure this has something to do with running in a terminal or not. I run the following command: /usr/local/bin/tsmua -outfile=xx run qact.rep When I run this on a terminal, it returns a format like: DATE_TIME: 2003-01-01 16:30:00.00 MSGNO: 402 SEVERITY: I MESSAGE: ANR0402I Sess