JDBCInput SQL issue

Highlighted
Eight Stars

JDBCInput SQL issue

I am trying to run this in the talend JDBCInput  , its throwing error

"
Select    replace(replace(replace(replace(AName,'\"',''''),char(10),''),char(13),''),',',';')   as AName
from Table ;
"

 


Accepted Solutions
Eight Stars

Re: JDBCInput SQL issue

Resolved using tMap


All Replies
Eight Stars

Re: JDBCInput SQL issue

Resolved using tMap

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch