Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[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
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

4 Replies
Anonymous
Not applicable
Author

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

shong
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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
_AnonymousUser
Specialist III
Specialist III

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