Formatting Data from Stored Procedure

[MJPPaba]

I have extracted some data using a stored procedure. the following works perfectly...

-* File mySQL.FEX
-DEFAULT &YEAR='2003';
-DEFAULT &WEEK='20';
SET SQLENGINE=SQLMSS
SQL EX [server].DBASE.DBO.SPROC &YEAR,&WEEK;
TABLE FILE SQLOUT
PRINT *
END

...However, I want to format the output from this Print * Statement. It won't work. I have tried to specify the fieldnames that I expect to get from the Print * function but it still fails.

I have also attempted to depoit to a hold file, which works, but then when I call on the hold file using the field names it say's field name not recognised.

Someone please put me out of my misery.

Cheers

Matthew

 

[MJPPaba]

I have found a way to do it.

In the script include the syntax ' ON TABLE HOLD AS MPHOLD ' after the print

-* File mySQL.FEX
-DEFAULT &YEAR='2003';
-DEFAULT &WEEK='20';
SET SQLENGINE=SQLMSS
SQL EX [server].DBASE.DBO.SPROC &YEAR,&WEEK;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS MPHOLD
END


Run this so that it creates the hold file. Then in the WF GUI environment open the application and create a report. point the report to the hold file MPHOLD.

Hey Presto , the hold file now has all the field you need to create your styled report.

Cheers

Matthew Paba