One of my users is getting these errors:

(FOC1400) SQLCODE IS 156 (HEX: 0000009C) XOPEN: S0001
: (156) [S0001] Incorrect syntax near the keyword 'TABLE'.
(FOC1414) EXECUTE IMMEDIATE ERROR.


Here is the code that is executing:

SQL SQLMSS SET SERVER FLORA3
END
SQL SQLMSS
-*
-IF &LAUNCH_RPT NE 'BR1' THEN GOTO BR2START;
-*EX e_CTR_PlatformReport1_legacy 20000042, 010113, 021413;
EX e_CTR_PlatformReport1_legacy &&G_ORGID, &DT_FROM, &DT_TO;
-GOTO COUNTERDONE;
-BR2START;
-IF &LAUNCH_RPT NE 'BR2' THEN GOTO BR3START;
EX e_CTR_Counter2_legacy &&G_ORGID, &DT_FROM, &DT_TO;
-GOTO COUNTERDONE;
-BR3START;
-IF &LAUNCH_RPT NE 'BR3' THEN GOTO BR5START;
EX e_CTR_Counter3_legacy &&G_ORGID, &DT_FROM, &DT_TO;
-GOTO COUNTERDONE;
-BR5START;
-IF &LAUNCH_RPT NE 'BR5' THEN GOTO COUNTERDONE;
-*EX e_CTR_Counter5_legacy 20000042, 010113, 021413;
EX e_CTR_Counter5_legacy &&G_ORGID, &DT_FROM, &DT_TO;
-COUNTERDONE;

TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS NEWONE FORMAT FOCUS
END
-RUN

I do not get the errors, I get the a report. Is is possible that the errors are related to timing, that maybe I have a faster intenet connection than the user?

Is WF trying to process the TABLE command faster than the stored procedure can return the dataset?

This message has been edited. Last edited by: <Kathryn Henning>,

Hi DebbieD,

Your user could be using a different profile or a different version of the SQL Server native client. It looks like it's going to involve some debugging, so I would like to suggest opening a case on InfoResponse Online.

Thanks and regards,

Kathryn