What is the format for the SELECT option? I cannot get this to work, it has to be empty. I expected it to be something like: column1, column2
but that gives an error
Solved
Example SQLITE reader with SQL Parameters
+10- Contributor
Best answer by takashi
Hi @kimo, you can set a SQL SELECT statement to the SELECT Statement parameter to perform query on the database. The reader feature type outputs the query result, regardless of the schema configuration displayed on Workbench Canvas.
For example, if you set this SELECT statement to the parameter, the reader feature type reads features having column1 and column2 from "my_table" table.
select column1, column2 from my_tableThe SQLCreator/SQLExecutor can be used to execute any SQL statements more conveniently, so I don't know the SELECT Statement parameter in a database reader feature type should be used in what kind of situation.
- Best Answer
Hi @kimo, you can set a SQL SELECT statement to the SELECT Statement parameter to perform query on the database. The reader feature type outputs the query result, regardless of the schema configuration displayed on Workbench Canvas.
For example, if you set this SELECT statement to the parameter, the reader feature type reads features having column1 and column2 from "my_table" table.
select column1, column2 from my_tableThe SQLCreator/SQLExecutor can be used to execute any SQL statements more conveniently, so I don't know the SELECT Statement parameter in a database reader feature type should be used in what kind of situation.
+10- Contributor
Thank you for the example, sadly missing in the help. I was only putting in column1,column2. I did not have to enter where in the where clause.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.