When I use the AS400JDBCDatabaseMetadata.getColumns(), the columns arrive in alphabetical order not in physical order. Is there a way other than SELECT * FROM... to get the physical order ?
Joe Sam Shirah Unfortunately, if you look at the Toolbox documentation for AS400JDBCDatabaseMetaData.getColumns(), you'll see this statement:I'm not aware of an alternative at this time. Obviously it is critical to read the driver documentation for (un)supported features.
"The following column in the description is not currently supported: