topic Re: Using the substr function to solve ODBC-Error with Progress-DB in QlikView

Using the substr function to solve ODBC-Error with Progress-DB

mikefromoke — Mon, 01 Feb 2016 13:33:26 GMT

Hi,

in the QV-Community i searched for a suggestion to solve the error with ODBC and Progress-DB "has value exceeding its max length or precision".

I found this discussion https://community.qlik.com/message/624320#624320, and the suggestion (last post) to use substr()-function.

Can someone please give an example, where and how i have to use it in the load- and select-sections?

i can't find the substr()-function in qlikview, and getting an error while using it.

the field is a "posting text" (length 150).

thanks for any help.

regards

mike

jerrysvensson — Mon, 01 Feb 2016 14:58:13 GMT

You use it in the Select-section.

mikefromoke — Mon, 01 Feb 2016 15:40:10 GMT

thanks for your answer.

so the syntax is only "substr(BuchungsText,1,150) " ?

do i have to add any " as tempBuchungsText" ?

If i do as you discribed, what will i have to do in the load-statement to get this field?

regards

mike

jerrysvensson — Tue, 02 Feb 2016 09:19:12 GMT

Probably like this:

Table:

LOAD BuchungsText

SQL SELECT substr(BuchungsText,1,150) as BuchungsText FROM database;

mikefromoke — Wed, 10 Feb 2016 14:34:52 GMT

Thanks,

it works!

thank you very much!

regards

mike