topic Re: call a SQL Function in QlikView

call a SQL Function

Anonymous — Mon, 02 Feb 2015 14:10:29 GMT

Hi!

I have to call a SQL Function from SQL Server, with a string field as parameter. This function returns a string. Can I call a SQL Function in the Load Script? How?

Thanks!

__________________________

Hola,

Tengo que llamar a una función de SQL Server, pasandole por parametro un campo string y que me devuelva ese mismo campo depurado. ¿Se puede llamar a una función en el Load Script? ¿Como?

Gracias!

Re: call a SQL Function

agomes1971 — Mon, 02 Feb 2015 14:12:43 GMT

Hi,

call a store procedure...

Regards

André Gomes

Re: call a SQL Function

Anonymous — Mon, 02 Feb 2015 14:16:47 GMT

I have to call a function, this function deletes html labels and returns the string.

Re: call a SQL Function

agomes1971 — Mon, 02 Feb 2015 15:15:51 GMT

Hi,

see this thread

Call a function in SQL LOAD

HTH

André Gomes

Re: call a SQL Function

Anonymous — Fri, 27 Feb 2015 06:39:53 GMT

Hi,
1. If that function is simple then Call the function as normal sql statement from Qlik View as below.
QVtable:
Load *;
select * from [DB]..StringToList('1:2',':');
2. Else Use stored procedure to call the function and execute the procedure in Qlik View