Universe Stage and substrings

[trokosz]

In the Universe Stage I know I can write some SQL type code. I'm doing something silly when trying to execute a substring function as follows:

SUBSTR(FULL.TEXT,1,254).....I even tried @SUBSTR(FULL.TEXT,1,254) but still no go....

The error I get is "call to SQLFetach failed.....row length exceeds buffer size".... Any idea what is wrong?


Thanks

[kduke]

You need to create a dictionary item or use EVAL.

SELECT EVAL "FULL.TEXT[1,20]" FROM RT_LOG123;

EVAL has several options to it where you can format it or name the column. Do a search. Ray has lots of posts using EVAL.

[ray.wurlod]

UniVerse SQL uses SUBSTRING as defined in ANSI SQL and in ODBC 2.0

Code: Select all

SELECT SUBSTRING(FULL.TEXT FROM 1 FOR 254) FROM ...

[trokosz]

Thanks a bunch