Hello,
Following ESQL does not give the desired output:
DECLARE sqlStmt CHARACTER;
SET sqlStmt = 'UPDATE Database.TEST SET (FIELDONE, FIELDTWO, FIELDTHREE) = (';
SET sqlStmt = sqlStmt || Environment.Variables.VAR1 || ' ,' ;
SET sqlStmt = sqlStmt || CAST(Environment.Variables.VAR2 AS CHAR) || ',' ;
SET sqlStmt = sqlStmt || CAST(Environment.Variables.VAR3 AS CHAR);
SET sqlStmt = sqlStmt || ') WHERE FIELD4 = 1111;';
EVAL(sqlStmt);
Following is the error message in the Log:
BROKERTEST.Default ) (1, 28) : Syntax error : '('.
The token caused a syntax error.
Correct the syntax of your _expression_ and redeploy the message flow.
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs