Travis
Change the LET statement in your stored procedure to:
LET string = "This" || " string";
to concatenate the two strings.
HTH
Sujit Pal
----------
From: Travis Rayhons[SMTP:trayhons@dordt.edu]
Sent: Tuesday, August 12, 1997 2:29 PM
To: informix-list@rmy.emory.edu
Subject: SPL string concatination
I am running Informix-Online Dynamic Server, Version 7.2, and having
difficulty doing string concatination in stored procedures. My first
attempt was to use the same syntax as 4GL (the comma), but then learned
by reading the manuals that I was trying to assign to multiple variables.
I am trying to do something similar to below:
DEFINE string CHAR(40);
LET string = "This", " string."
Does anyone have any idea on how to do this in SPL?
I do have a solution to send the important information to a 4GL program,
but I hate to slow down the stored procedure any more by calling other
programs.
---
Travis Rayhons trayhons@dordt.edu
Dordt College Computer Services (712) 722-6299 (w)
Programmer/Systems Administrator