topic Re: [resolved] tDB2Input Invalid escape sequence When Clicking Guess Schema in Talend Studio

[resolved] tDB2Input Invalid escape sequence When Clicking Guess Schema

Croix — Tue, 07 Mar 2017 17:57:36 GMT

Hi,
I'm using the tDB2Input component to pull data from a DB2 database.
I'd like to use the Guess schema button under query type, however, it keeps saying "Invalid Escape Sequence (valid ones are \b \t \n \f \r \" \' \\)"

My query is "SELECT MXXXXX FROM TGxXXX.TXXXX_INST"
Any hints about why I might get the "invalid escape sequence" error?
This is what I'm trying to do:

Thanks!
Croix

Re: [resolved] tDB2Input Invalid escape sequence When Clicking Guess Schema

vapukov — Tue, 07 Mar 2017 20:35:51 GMT

are You select only 1(single) column? just create schema manually in this case

if it principle question, need to check:
- is this query run from Talend SQL window?
- what type of column?
- what DB2 and drivers?
Last also important because - very hard to repeat on different versions

Re: [resolved] tDB2Input Invalid escape sequence When Clicking Guess Schema

Croix — Fri, 17 Mar 2017 23:29:42 GMT

I found out from Talend Support that there is a patch for this issue. The patch name is Patch_20161124_TPS-1685_v2-6.2.1.
Once I installed the patch this issue was fixed.
Thanks!
Croix