-
1. Re: Teiid does not recognize "CONVERT"
What happens is that I have a varchar field: '00040' and another '40' and I need to match
-
2. Re: Teiid does not recognize "CONVERT"
The convert function in Teiid is similar to a cast. The form is CONVERT(val, type), for example CONVERT('1', integer)
Which database's CONVERT function are you expecting?
-
3. Re: Teiid does not recognize "CONVERT"
I have already tried using the CONVERT function, even the way you have explained me; What happens is that it does not recognize CONVERT as a function, I would like to know if it is necessary to import a library or something to the teiid so that it can recognize it.
-
4. Re: Teiid does not recognize "CONVERT"
The designer has an indicator when it recognizes a function and is that the command is placed in blue color, in this case CONVERT remains standard, but INT if it recognizes it as such.
-
5. Re: Teiid does not recognize "CONVERT"
The runtime recognizes the usage of CONVERT(val, type) - there is no additional library or settings needed.
If you are having an issue in Designer, it may help to have a screen cap of the problem.
-
6. Re: Teiid does not recognize "CONVERT"
Sorry, you were right I was using INT instead of INTEGER. But also, I have a problem with the OUTER function, how would the syntax in teiid?
-
7. Re: Teiid does not recognize "CONVERT"
Teiid does not have a built-in OUTER function. Which database's OUTER function are you wanting support for?