Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Thomas
I dont know about IUS, but in ODS the substr function is simply [m,n].
For example if you wanted to substr(aString, 10, 20) you would say
aString[10,30] in your SQL.
HTH
Sujit Pal
______________________________ Reply Separator _________________________________
Subject: Im forwarding a question to the list from a coworker
Author: thomas@koz.com (Thomas Tatum) at Internet
Date: 3/4/98 9:49 AM
A co-worker of mine asks:
>I've flipped through half a dozen informix books and can't find the
>getSubStr() function anywhere. Is it an undocumented function? I
>searched the informix site and they have no documents that mention it.
>How does one find out what functions are available in spl and how they
>are used?
We are running IUS 9.12UC3
-Thanks!
--
Thomas Tatum
thomas@rtp.koz.com
919-489-5662 x2129
919-602-6521
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.