Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
mikefromoke
Contributor

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

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

4 Replies
jerrysvensson
Valued Contributor II

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

You use it in the Select-section.

mikefromoke
Contributor

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

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
Valued Contributor II

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

Probably like this:

Table:

LOAD BuchungsText

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

mikefromoke
Contributor

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

Thanks,

it works!

thank you very much!

regards

mike

Community Browser