Using variables in Stored Procedures

[linkan]

I work at a governmental agency that conducts a survey once per month, and the results are stored in an SQL database. I have now started to use ODBC connection to that database, but I can not pass the info from variables to the stored procedure.

Example:
call BearbetningHamtaUtskick (@sPeriod='201502', @sSektor='G')

I want to be able to set the sPeriod from user input (to get the information from the database about the current months answers).

[EViews Gareth]

Could you provide more information on what you're trying to do (and where EViews is involved)?

[linkan]

I am trying to use ODBC to get data to Eviews from an SQL database, so I can continue to work on it in Eviews. The full code is enclosed below, with uid and pwd for the ODBC source changed.

Code: Select all

Mode Quiet Close @All %per = "1502" %perSQL = "20" + @Left(%per,4) %per2 = "20" + @Left(%per,2) + "m" + @Right(%per,2) WfCreate(page=m) TestODBC m {%per2} {%per2} %dbcred = "dsn=Dbutv;uid=eviews;pwd=eviews" PageLoad(type=odbc,page=Utskick) {%dbcred} "{call BearbetningHamtaUtskick (@sPeriod='201502', @sSektor='G')}"

I would like to be able to use %perSQL instead of the hard coded 201502 within the call part of the PageLoad at the bottom.

[EViews Gareth]

Code: Select all

%date = "201502" %callcode = "{ call BearbetningHamtaUtskick (@sPeriod='"+%date+"',@sSektor='G')}" PageLoad(type=odbc,page=Utskick) {%dbcred} %callcode

[linkan]

Thank you very much.