1 Reply Latest reply: Apr 30, 2012 7:07 PM by Steve Dark RSS

    Can we call storedprocedure field into the QlikView?

    Shubham Kumar

      Hi All,

      
      Can we call the SQL storedprocedure field in QlikView directly?
      

       

      Best Regards,

      Shubham

        • Can we call storedprocedure field into the QlikView?
          Steve Dark

          Hi there,

           

          It is not generally considered best practice to connect to a Stored Procedure.  Is there a particular reason it has to be a procedure call and not a SELECT from a view?

           

          To use a stored procedure you need to add the text (mode is write) after your connection string, eg:

           

          CONNECT TO [Provider=SQLOLEDB..[...]..when possible=False](mode is write);

           

          You will get warnings each time you open the document after doing this.

           

          The procedure call itself is then done like this:

           

           

          TableName:

          SQL EXEC dbo.prc_ProcedureName;

           

          Hope that helps,

          Steve

           

          http://www.quickintelligence.co.uk/