[resolved] execute a query

One Star

[resolved] execute a query

Hi,
I would like to know which component I need to use to execute a SQL query independantly of other component? Because, at the beginning of my job, I need to execute a query to insert one line in a database.
Caro

Accepted Solutions
Community Manager

Re: [resolved] execute a query

Hello
But I just need a component for inserting one line in a database at the beginning of my job and I don't have any input for the component !

If you just wanna execute a insert statement, the txxxRow component can fit your need.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

Re: [resolved] execute a query

Hello
Using the txxxInput components for executing a query and the txxxOutput components for inserting data into database.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] execute a query

Hi,
A txxxOutput component needs an input link. But I just need a component for inserting one line in a database at the beginning of my job and I don't have any input for the component !
Caro
Community Manager

Re: [resolved] execute a query

Hello
But I just need a component for inserting one line in a database at the beginning of my job and I don't have any input for the component !

If you just wanna execute a insert statement, the txxxRow component can fit your need.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] execute a query

Exactly the answer I was looking for, thank you! Smiley Happy