RE: ODBC Fields Order

["Shaw, David" <dshaw@xxxxxxxxxxx>]

In case anyone is curious about this, I ultimately found an information APAR,
II11189, which describes my problem and then goes on to say, in effect, "screw
you, it's a feature".  And the people here at Spartan who have the problem with
it in effect "program described" the record layouts that they're using for their
ODBC uploads to the /400, so it's a dangerous feature for us here.  OY!

Dave Shaw
Spartan International, Inc.
Spartanburg, SC

> -----Original Message-----
> From: Shaw, David 
> 
> Thanks, Jim, that does show the two different orders of the 
> fields.  I see the
> physical it's built over, QSYS/QADBIFLD, is set to re-use 
> deleted records, and
> this SYSCOLUMNS view has no index so there's no guarantee 
> about what order the
> records will be in.  Swell.  I guess IBM doesn't think that 
> it's supposed to
> matter.  Hum, I guess I've got to go back to the folks here 
> that don't like it
> and find out whether it's a show-stopper or just a nuisance.
> 
> Thanks again!
> 
> Dave Shaw
> Spartan International, Inc.
> Spartanburg, SC
> 
> > -----Original Message-----
> > From: Nelson, Jim (RCIS) [mailto:Jim.Nelson@RCIS-NET.COM]
> > 
> > You may want to try 
> > 
> > SELECT * FROM QSYS2/SYSCOLUMNS WHERE TABLE_NAME = 'tablename' 
> > 
> > for each table and compare the results.  May show you something.
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---