RE: ODBC Fields Order

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

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
+---