SQL User Defined Function in a QVD Load

MalcolmCICWF — Wed, 04 Dec 2013 18:22:56 GMT

I have a user that added some SQL code to a qvd load that caused the below error.

He ran the code on SQL server fine, but apparently Qlikview does not like the same code when trying to load a Qvd. The code is running as below, is tehre a specific change that Qlikview needs to recognize these defined functions?

SQL SELECT

SEQUENCE_NUM,

DEBT_INFO_1,

DEBT_INFO_2,

DIRECT_MAIL_SCORE,

TSYS_RATE,

DBO.UDF_SCORE_RANK(SEQUENCE_NUM) AS SCORE_RANK,

DBO.UDF_GROSS_RESPRATE(SEQUENCE_NUM) AS GROSS_RESPRATE,

DBO.UDF_NET_RESPRATE(SEQUENCE_NUM) AS NET_RESPRATE,

DBO.UDF_QUALIFY_RATE(SEQUENCE_NUM) AS QUALIFY_RATE

FROM BTOffer.dbo.VW_SOURCE_RECORD_ALL

Re: SQL User Defined Function in a QVD Load

Wed, 04 Dec 2013 18:35:45 GMT

Please check the QV user account access to user defined function in the schema ?

topic Re: SQL User Defined Function in a QVD Load in QlikView

SQL User Defined Function in a QVD Load

Re: SQL User Defined Function in a QVD Load