topic Re: [resolved] Error Inserting rows into table by editing Query in Talend Studio

[resolved] Error Inserting rows into table by editing Query

Anonymous — Fri, 31 Mar 2017 02:11:58 GMT

I am using tPostgresqlInput and have connected it this way :
tPostgresqlInput --> tPostgresqlOutput

I would like to insert a row where there is 111 as an integer, context.temp, context.startDate and the current date into the table.

I edited the query in tPostgresqlInput :
"INSERT INTO table1 (ID, num, startDate, endDate) VALUES (111, context.temp, context.startDate, TalendDate.parseDate("dd/MM/yyyy",TalendDate.getDate("dd/MM/yyyy")) "

However, I receive an error:

Detail Message: Syntax error on token "")) "", ) expected

Please help.

Re: [resolved] Error Inserting rows into table by editing Query

Anonymous — Fri, 31 Mar 2017 03:08:48 GMT

I can solve it by using tMap but I would like to know how it can be done using sql query.

Re: [resolved] Error Inserting rows into table by editing Query

vapukov — Fri, 31 Mar 2017 04:56:00 GMT

First of all - tPostgreSQLInput - DO NOT MEAN Insert operations
it is work for tPostgreSQLOutput

Read -> transform -> Write result

Than You have error in SQL, and Talend tell You about this - missed close )

If You want do all manually - use tPostgeSQLRow

Re: [resolved] Error Inserting rows into table by editing Query

Anonymous — Fri, 31 Mar 2017 05:15:00 GMT

@vapukov Hi, got it. Thanks.