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.
Christoph Liebig — — source: Informix-list mailing list archive (1991-1998)
Hi !
How do I specify (syntax) a list literal for the following collection type
LIST ( NVARCHAR(73) NOT NULL )
The motivation behind my question is that I want to call a SPL procedure
Flush( LIST ( NVARCHAR(73) NOT NULL ) )
I might add that there is also a Flsuh() defined without any paramters.
When I call the procedure like
EXECUTE PROCEDURE Flush( "LIST{ 'some string'::NVARCHAR(73) }" )the execution fails because of IUS is not able to "resolve Flush".
I tried various syntactic alternatives for above literal but neither would do.
However, if I define another stored procedure like
CREATE PROCEDURE FlushWrapper()
DEFINE theList LIST ( NVARCHAR(73) NOT NULL );
LET theList = "LIST{ 'some string'::NVARCHAR(73) }";
EXECUTE PROCEDURE Flush(theList);END PROCEDURE;
everything works fine.
Any ideas ?
TIA,
Chris
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.