RE: Weird request
Mike Magie (IDS 10.00.UC8 on Solaris 2.8) wanted to generate a file listing database|table|column|datatype across a large number of databases, and was struggling mainly with decoding syscolumns.coltype, which is stored as a smallint that must be mapped (including the not-null bit) to a readable data type name. Clifton Bean offered a script to rework into a stored procedure, but it was sent as an attachment/directly by email rather than posted, so no actual code or SQL appears in the thread; the rest is off-topic banter. No usable resolution is recorded here.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
You can probably rework the attached into a stored procedure and use it to supply that last column. If you do rework it, please send me a copy. :) Take care. Clifton M. Bean Informix DBA / AIX System Admin Currency Technics & Metrics Main (972) 812-1411 x244 -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MIKE MAGIE Sent: Thursday, July 10, 2008 1:35 PM To: ids@iiug.org Subject: Weird request [12637] Pertinents: Informix 10.00.UC8 on Solaris 2.8 Mission: Create a file that contains the following - database_name|table_name|column_name|column_data_type For like a bajillion databases with gobs of tables and oodles of columns. I have already began playing with awk and sed - and looking at sysmaster queries and stuff. Coltype is the main issue - as many of you probably know the coltype is stored as a smallint, in decimal, that when converted to hex can be mapped to the actual data type, i.e if you had a coltype value of 257 you'd convert it to hex, get 101, map it to the coltype values and figure that you had a not null integer column. But that is like hard and stuff. I am sure I am trying to reinvent the wheel here and would love to see what some of you ladies and gents might come up with. MM ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.
Clifton Bean wrote: > You can probably rework the attached into a stored procedure and use it > to supply that last column. If you do rework it, please send me a copy. > :) > > The attached, huh? :o) > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > MIKE MAGIE > Sent: Thursday, July 10, 2008 1:35 PM > To: ids@iiug.org > Subject: Weird request [12637] > > Pertinents: > > Informix 10.00.UC8 on Solaris 2.8 > > Mission: > > Create a file that contains the following - > > database_name|table_name|column_name|column_data_type > > For like a bajillion databases with gobs of tables and oodles of > columns. > > I have already began playing with awk and sed - and looking at sysmaster > > queries and stuff. Coltype is the main issue - as many of you probably > know > the coltype is stored as a smallint, in decimal, that when converted to > hex > can be mapped to the actual data type, i.e if you had a coltype value of > 257 > you'd convert it to hex, get 101, map it to the coltype values and > figure that > you had a not null integer column. But that is like hard and stuff. I am > sure > I am trying to reinvent the wheel here and would love to see what some > of you > ladies and gents might come up with. > >
In Obnoxio-speak: He <expletive deleted> emailed me the <expletive deleted> script <expletive deleted> directly <expletive deleted>. <expletive deleted> M <expletive deleted> M
Not enough expletives for OTC -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MIKE MAGIE Sent: Thursday, July 10, 2008 2:48 PM To: ids@iiug.org Subject: Re: Weird request [12645] In Obnoxio-speak: He <expletive deleted> emailed me the <expletive deleted> script <expletive deleted> directly <expletive deleted>. <expletive deleted> M <expletive deleted> M **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.
MIKE MAGIE wrote: > In Obnoxio-speak: > > He <expletive deleted> emailed me the <expletive deleted> script <expletive > deleted> directly <expletive deleted>. > > <expletive deleted> M <expletive deleted> M > Thanks for that! See you next Tuesday! :o)
OTC is vastly smarter than he appears. Sufficient expletives throw-off Government message indexing/sniffers. Sort of Google-proofing postings. *pink-pink* my two pence Jonathan Smaby > From: Paul Watson <paul@oninit.com> > Reply-To: <ids@iiug.org> > Date: Thu, 10 Jul 2008 15:50:28 -0400 (EDT) > To: <ids@iiug.org> > Subject: RE: Weird request [12647] > > Not enough expletives for OTC > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MIKE > MAGIE > Sent: Thursday, July 10, 2008 2:48 PM > To: ids@iiug.org > Subject: Re: Weird request [12645] > > In Obnoxio-speak: > > He <expletive deleted> emailed me the <expletive deleted> script <expletive > deleted> directly <expletive deleted>. > > <expletive deleted> M <expletive deleted> M > > **************************************************************************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ****************************************************************************** > * > Forum Note: Use "Reply" to post a response in the discussion forum. > ------------------------------------------------------------- This message has been scanned by Postini anti-virus software.
Jonathan Smaby said: > OTC is vastly smarter than he appears. You say that like it's an achievement. -- Bye now, Obnoxio http://obotheclown.blogspot.com/
>OTC is vastly smarter than he appears. He could be any dumber than he looks :-) Cheers paul Sufficient expletives throw-off Government message indexing/sniffers. Sort of Google-proofing postings. *pink-pink* my two pence Jonathan Smaby > From: Paul Watson <paul@oninit.com> > Reply-To: <ids@iiug.org> > Date: Thu, 10 Jul 2008 15:50:28 -0400 (EDT) > To: <ids@iiug.org> > Subject: RE: Weird request [12647] > > Not enough expletives for OTC > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MIKE > MAGIE > Sent: Thursday, July 10, 2008 2:48 PM > To: ids@iiug.org > Subject: Re: Weird request [12645] > > In Obnoxio-speak: > > He <expletive deleted> emailed me the <expletive deleted> script <expletive > deleted> directly <expletive deleted>. > > <expletive deleted> M <expletive deleted> M > > **************************************************************************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > **************************************************************************** ** > * > Forum Note: Use "Reply" to post a response in the discussion forum. > ------------------------------------------------------------- This message has been scanned by Postini anti-virus software. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.
I said enough yesterday. I know I have two feet, but I only have one mouth :-( Jonathan Smaby > From: Paul Watson <paul@oninit.com> > Reply-To: <ids@iiug.org> > Date: Thu, 10 Jul 2008 16:02:45 -0400 (EDT) > To: <ids@iiug.org> > Subject: RE: Weird request [12651] > >> OTC is vastly smarter than he appears. > > He could be any dumber than he looks :-) > > Cheers > paul > ------------------------------------------------------------- This message has been scanned by Postini anti-virus software.