Use the SQL Rename command to make everyone happy: "The following SQL code makes everybody happy because it defines a 'static' short 10-character name for the tables (and record-format and member and columns), AND it allows the Java programmers to have their descriptive long name.
CREATE TABLE LongName (
LongFieldName1 FOR COLUMN LFN1 INTEGER NOT NULL,
LongFieldName2 FOR COLUMN LFN2 CHAR(3) NOT NULL,
CONSTRAINT LongFileName0
PRIMARY KEY (LongFieldName1)
);
RENAME TABLE LongName TO LongTableName FOR SYSTEM NAME LongName; "
Monday, January 31, 2005
Subscribe to:
Post Comments (Atom)
Subscribe To as400 blog
Posts
Comments
Popular Posts
- Journaling for Performance
- AS400 PRTF - Report Layout Utility
- RIAA sues the dead | The Register
- AS400 / ISeries Freeware / Shareware
- ibm as400 manuals v5r4
- Javalobby - Java J2EE Programming Forums - Coldtags suite 2.1: 210+ custom JSP tags
- Creating an as400 Query
- as400 Iseries Tips
- AS400 APIs
- AS400 API - QCMDEXC - Execute Command
No comments:
Post a Comment