by We have Universe 9.6.B on AIX 4.3.
When I try to use SUBSTRING in ODBC-client, I get error.
For example:
1. when I try SELECT SUBSTRING(SINT,1,2) FROM ...
the error is:
uniVerse code: 950088; Msg: [Informix][SQL
Client][UNIVERSE]UniVerse/SQL: syntax error. Unexpected symbol.
Token was ",".
2. When i use try SELECT SUBSTRING(SINT FROM 1 FOR 3) FROM ...
the error is:
[Ardent][UVODBC][1401030]Error ID: 29 Severity: ERROR Facility:
FPSRVERR - Line 1, column 23 (around "FROM"): Syntax error.
So, it seems, that it knows about SUBSTRING, but the format is
different.
Is it possible to use SUBSTRING in UV ODBC-clients ?
(in command promt mode the second variant works).
Alex.