Re: 10 Char object names was...

[rob@xxxxxxxxx]

I don't think people are accepting of the Alias concept.  I think they 
want all or nothing.  i5/os currently supports alias on column names, 
table names, view names, and the like - you know, the stuff that the 
"user" sees.  Ok, so it doesn't support it on program names.  Other than 
Steve, who's that going to upset?

If you look at the common interface, used by both i5/os and SQL Server, 
you'll see the longer names.  For example, if I use 
STRSQL

CREATE TABLE ROB.INNAGODDADAVIDA (
 IRONBUTTERFLYROCKS CHAR(25), 
 HOWMUCHDOTHEYROCK  BIGINT) 

SELECT SUBSTR(TABLE_NAME,1,25) AS FILE, 
       SUBSTR(TABLE_SCHEMA,1,3) AS LIBRARY
FROM QSYS2.SYSTABLES WHERE 
TABLE_NAME LIKE('INNA%') 

....+....1....+....2....+....3....
FILE                       LIBRARY
INNAGODDADAVIDA              ROB 
********  End of data  ******** 

SELECT substr(TABLE_NAME,1,25) as file, 
       substr(COLUMN_NAME,1,25) as field
FROM QSYS2.SYScolumns 
WHERE TABLE_NAME = 'INNAGODDADAVIDA' 

....+....1....+....2....+....3....+....4....+
FILE                       FIELD 
INNAGODDADAVIDA            IRONBUTTERFLYROCKS 
INNAGODDADAVIDA            HOWMUCHDOTHEYROCK 
********  End of data  ******** 

The people who claim that big objects are not currently supported will not 
be happy until IBM has to change QUSLOBJ, DSPOBJD and every other 
interface and/or API.

Rob Berendt