FEX failed

[rummage]

Hi,

I am running the following FEX procedure.




-* File WF042102.FEX
-* CALL THE SQL PROCEDURE TO TRUNCATE THE TABLES

-SET &TODAY=&YMD;
-SET &AJB = GETUSER(A8);
-TYPE USER &AJB
-TYPE &DATE

-SET &SESSIONID = &AJB || &TODAY || 'AAAAAAAAAAAAAAAAAAAAAAA';

SQL SQLMSS

EX GOA01_SQL.dbo.spgoa_dropusertables '&SESSIONID';

END


The purpose of this procedure is to drop the temporary table data in the SQL
Server database. When I run the SQL Server stored procedure in Query Analyser
the table data is dropped. It does not work in the Webfocus code. Please help me
resolve this.

Thanks
Thambaiya

 

[Siddhamalli]

if its mre environment
you have to say
-MRNOEDIT BEGIN
SQL SQLMSS SET SERVER extndev1 (provide which server is it )

if its normal environment , i dont see much diff in code , evrything is right , may try a

table sqlout and do a print * and see whats the output.