Re: DSPFFD *OUTFILE Curiosity

["Joe Lee" <LeeJD@xxxxxx>]

You could also look at the various QADB* files in QSYS, specifically
QADBIFLD. I have found it much faster than using DSPFFD, and I would
assume that the same would be true of using either QSYS2/SYSCOLUMNS or
SYSIBM/SYSCOLUMNS, I believe that they are the same thing, but SYSIBM is
where JDBC drivers look.

Joe Lee

>>> rob@xxxxxxxxx 10/26/2004 12:31:30 >>>
Did you also try querying QSYS2/SYSCOLUMNS for the file?

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com 





Glenn Thompson <gthompson@xxxxxxxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx 
10/26/2004 03:20 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Fax to

Subject
Re: DSPFFD *OUTFILE Curiosity






OK, there is a sheepish and shameful grin on my face as I type.  The 
DSPFFD worked as it should.  I was using the DSPF to look at and was 
expecting something more human readable.  When I ran my query on the 
file anyway it worked.  I should know better.

Thanks guys and sorry for the wild goose chase.

Dan Bale wrote:

>Glenn, you might find the following useful.  It is the screen shot of
my
>DSPFFD utility, showing the layout for the DSPFFD outfile record
format
>QWHDRFFD.  I've chopped part of the Field Description to avoid as
much
>wrapping in the list email as possible, but you get the idea.  If
there 
were
>keys on this file, you'd see those as well.
>
>
> 
>

-- 
Glenn Thompson
Senior Analyst
American Trouser, Inc.
gthompson@xxxxxxxxxxxxxxxxxxxx 


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
or email: MIDRANGE-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
or email: MIDRANGE-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.