[resolved] Error Inserting rows into table by editing Query

[Anonymous]

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.

[Anonymous]

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

[vapukov · Accepted solution]

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

[Anonymous]

@vapukov Hi, got it. Thanks.