I need to run a MSSQL stored procedure to update the view I report against.

I do not need to pass any params, or get any data from the table with this stored procedure. I just need it to run.

I tried this:

 
ENGINE SQLMSS SET DataAdapterName;
SQL SQLMSS
EX StoredProcedureName;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS SQLOUT
END 

But I am getting an error when I try to run:

Error parsing report request

>ENGINE<
ENGINE SQLMSS SET DataAdapterName  

This message has been edited. Last edited by: Greg,

quote:

;

Definately not needed on the engine command

Still get the same error after removing the ;

This works for us:

 
-SET &CONNECTION = IF &SERVER_NAME EQ '11.0.1.111' OR 'qa_env' THEN  'XXXPROD1' ELSE 'XXXPROD2'; 
SQL SQLMSS SET SERVER &CONNECTION
SQL SQLMSS EX DATABASE_NAME.DBO.PROD_WF_StoredProcedure;
-RUN
TABLE FILE SQLOUT
SUM  
    COLUMN_NAMES ...
WHERE   ...;
ON TABLE HOLD AS WHATEVER FORMAT ALPHA
END
-RUN

hth

Tom

Still getting parsing error on the first line. No matter what I put on the first line I am getting parsing error.

Can I paste the SQL code from the stored procedure
in to a SQL report and not use the stored procedure on the SQL server at all?

inline SQL procedure:

  
-* File Variance_Load.fex
ENGINE SQLMSS SET DEFAULT_CONNECTION CLE1DV005
SQL SQLMSS PREPARE SQLOUT FOR
SELECT
     a.name   AS 'TABLE_NAME'
    ,b.name   AS 'Column_Name'
    ,b.length AS 'Length'
    ,c.name   AS 'Format'
FROM
  DW_ProjAcct.dbo.sysobjects a
 ,DW_ProjAcct.dbo.syscolumns b
 ,DW_ProjAcct.dbo.systypes   c
WHERE a.id = b.id
AND   b.xtype = c.xtype
AND  (a.xtype IN ('u','v'))
;
END
SET ASNAMES = ON
DEFINE FILE SQLOUT
   MEASURES/A128 = IF Format     IN ('int','decimal','float') THEN Column_Name ELSE ' ';
   SORT01/A128   = IF NOT Format IN ('int','decimal','float') THEN Column_Name ELSE ' ';
   DRILL01/A128  = IF SORT01 EQ ' ' THEN '- - - None - - -' ELSE SORT01;
   DRILL02/A128  = IF SORT01 EQ ' ' THEN '- - - None - - -' ELSE SORT01;
END
TABLE FILE SQLOUT
SUM
 MEASURES
  BY TABLE_NAME
  BY MEASURES NOPRINT
WHERE MEASURES NE ' ';
 ON TABLE HOLD AS HOLD1
END
-RUN

hth, going golfing...

Tom

Although you are only trying to execute the sotred procedure, webfocus wants the user account to have write permissions also.