×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
You may have to look up the short name (SYSTEM_COLUMN_NAME) in SYSCOLUMNS.
Something like
select SYSTEM_COLUMN_NAME from QSYS2.SYSCOLUMNS where TABLE_SCHEMA='LibNameFromMeta' and TABLE_NAME='TableNamefromMeta' and COLUMN_NAME='ColumnNameFromMeta'
Max length of the varchar for COLUMN_NAME in SYSCOLUMNS is 128 in the V4R4 doc I'm looking at.
-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of James H. H. Lampert
Sent: Tuesday, March 19, 2013 6:05 PM
To: Java Programming on and around the IBM i
Subject: Another JDBC question: what about "short" field names?
Given an SQL table with longer-than-10-character field names:
If I open the file in QuestView (which uses QUSLFLD, QDBRTVFD, and so forth, to retrieve the meta-data on the file), it gives me "shortened"
field names, e.g., "STANDARDCHARGE" becomes "STAND00001"
How would I obtain the "shortened" field names via JDBC, and in particular, through an extension to Scott Klement's JDBCR4?
Incidentally, is there a maximum length for SQL column names?
--
JHHL
--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/java400-l.
midrange.com
