Re: 10 Char object names was...

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