[resolved] tDB2Input Invalid escape sequence When Clicking Guess Schema

[Croix]

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

[vapukov]

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 

[Croix · Accepted solution]

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