Hi Folks, I am trying to call a

[rummage]

Hi Folks,

I am trying to call a SQL stored procedure from WebFocus using two parameters. The parameters are '40709297-9D5F-4D26-BF76-9159F0D664D9','0'

It is giving me two errors.
First when I save this, it says
'One of the line is longer than 80 char. Do you want to save?'
After I save and run, I get the SQL code error 170. Incorrect syntax.

The complete code is the following. Please help me fix it.

SQL SQLMSS
EX GOA01_SQL.dbo.spgoa_GetSummaryDataA '40709297-9D5F-4D26-BF76-9159F0D664D9','0';
TABLE FILE SQLOUT
PRINT *
END

 

[zushi]

LET
NO=40709297-9D5F-4D26-BF76-9159F0D664D9;
END
SQL SQLMSS
EX GOA01_SQL.dbo.spgoa_GetSummaryDataA 'NO','0';
TABLE FILE SQLOUT
PRINT *
END

 

[Siddhamalli]

Hi first of all the length of the the line is greater than 80 characters either do it the way Zushi as given solution or try to break that 81 charater line so that you dont exceed 80 charaters.