Page 1 of 1
Posted: Wed Oct 29, 2003 12:22 pm
by kcbland
This is a CHAR(252) character, which internally is a @SM or @SVM reserved character. I don't know why it's generating this message. You do have to deal with this as an issue, though.
Do you have NLS installed?
Posted: Thu Oct 30, 2003 4:42 am
by spracht
Another workaround is doing the lookup against a uv table. Nevertheless you would not be able to take the field in question as part of the key, because uv tables use the same hashing algorithm. But afterwards you can do the lookup using any columns. For performance reasons, you might consider to create a secondary index.
Posted: Thu Oct 30, 2003 6:23 am
by ray.wurlod
I think Stephan's is the wisest course. You can create a UniVerse table with an automatic key as follows (edit the DDL in the UV stage to add the DEFAULT clause on the pkey column):
Code: Select all
CREATE TABLE tablename (
pkey INTEGER NOT NULL DEFAULT NEXT AVAILABLE,
col1 VARCHAR,
col2 VARCHAR,
col3 INTEGER,
col4 VARCHAR,
col5 VARCHAR);
You can create the index with a regular CREATE INDEX statement:
Code: Select all
CREATE INDEX COL4_IDX ON tablename(col4);