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)
Popular Posts
- as400 iSeries NetServer Disabled user profiles
- Create a Custom Live Linux CD - Leveraging BusyBox and OpenSSH
- Super $500 Myth Project
- Library list for Web server
- Encode HTML Entities - Showing code in blogs
- Search for text in vi or vim
- IBM eServer iSeries - iSeries NetServer: Command Line Setup
- Thomas Dudziak's Weblog
- HOW TO make a Powerbook in to a Wi-Fi access point!
- Reno County is preparing to move from an AS400 computer system to a personal-computer-based system
No comments:
Post a Comment