RE: AW: 7.1 broke REMARKS column from JAVA getcolumns method

[Jim It <jim_it@xxxxxxxxxxx>]

Brigitta,
 
I'm sure that is the cause of the issue, but shouldn't according to the JAVA getColumns method, REMARKS return a string, not a graphic data?
 
Jim
 
 

> From: Hauser@xxxxxxxxxxxxxxx
> To: midrange-l@xxxxxxxxxxxx
> Subject: AW: 7.1 broke REMARKS column from JAVA getcolumns method
> Date: Mon, 1 Apr 2013 12:15:54 +0200
>
> Not sure if it has something to do with your problem ...
> But the data type of all Comment / Remarks columns within the catalog views
> are changed in Release 7.1 from the CHARACTER Data Type to the GRAPHIC data
> type with CCSID 1200.
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
>
> -----Ursprüngliche Nachricht-----
> Von: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Jim It
> Gesendet: Monday, 01.4 2013 04:05
> An: midrange-l@xxxxxxxxxxxx
> Betreff: 7.1 broke REMARKS column from JAVA getcolumns method
>
>
> I've noticed that since we have been upgrading our partitions that the
> column label text returned for any files from JAVA is now returning only
> null values. According to
> http://docs.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#getC
> olumns(java.lang.String, java.lang.String, java.lang.String,
> java.lang.String) GetColumns - Retrieves a description of table columns
> available in the specified catalog and REMARKS returns a string containing
> comment describing column. (may be null)
>
> I've tested this using the following code. Luckily, we still have an old
> partition on 6.1, so I could verify. I guess, I'll enter a PMR tomorrow.
>
> import java.sql.*;
> public class ListColumns {
> public static void main(String args[]) { Connection con; Statement stmt;
> String system = "XXXXXXXX"; String collectionName = "LIBRARY"; String
> tableName = "FILENAME"; try { DriverManager.registerDriver(new
> com.ibm.as400.access.AS400JDBCDriver());
> con = DriverManager.getConnection ("jdbc:as400://" + system);
> DatabaseMetaData dmd = con.getMetaData (); ResultSet res =
> dmd.getColumns(null, collectionName, tableName, null);
> System.out.println("List of columns: "); while (res.next()) {
> System.out.println( " "+res.getString("TABLE_SCHEM")
> + ", "+res.getString("TABLE_NAME")
> + ", "+res.getString("COLUMN_NAME")
> + ", "+res.getString("REMARKS")
> + ", "+res.getString("TYPE_NAME")
> + ", "+res.getInt("COLUMN_SIZE")
> + ", "+res.getString("NULLABLE")
> );
> }
> res.close();
> con.close();
> } catch(SQLException ex) {
> System.err.println("SQLException: " + ex.getMessage()); } System.exit (0); }
> }
>
> Jim 
> --
> 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.