RE: SQL Server Stored procedures and ODI

Works like the charm I should have thought of myself.  Many thanks.

> Hi there,
>  
> Have you tried using a sql block in the 4gl code to shield the 
statement
> from the compiler?  
>  
>  
>  
> sql
>        exec spname parameters
> end sql
>  
>  
>  
> rt
>  
> 
> ________________________________
> 
> From: [email protected] on behalf of [email protected]
> Sent: Tue 2/27/2007 12:34 PM
> To: [email protected]
> Subject: [fourjs-users] SQL Server Stored procedures and ODI
> 
> 
> 
> I need to call a SQL Server (SS) stored procedure from 4GL using ODI.
> I am not returning anything, I am creating a table on the SQL server
> side so that the user can use Crystal reports to report on the data 
and
> also join with other tables on the SS side.
> 
> I run a program on the informix side using a beginning and ending date
> as parameters.  This creates a text file unload.
> The user will currently have to run the sp from inside of Crystal
> Reports (CR) using that same date range (remembering to type it in
> correctly).  I inserts the contents of the text file into a tempfile
> and then does other magic on tables in the SS DB.  In this case, it
> returns a record set to CR for analysis
> 
> I want to have the 4gl program call the sp.  I realize I can't easily
> return data to the 4gl program.  I was planning just create a table on
> the SS side that would get over written every time they push the 
button
> in Informix.
> 
> Sound grand, doesn't it?  The problem is that once I tell the ODI that
> I want to use the SS database, how do I cast the sp statement?  I 
tried
> exec spname parameter, parameter and it won't compile.
> 
> 
> 
> 
>