Embedded Function Call in SQL Throws an Error

Reported for version 9


Attempting to run query: Select functionName() from Table returns the following error:

Runtime error in JDBC reader: Invalid sql column in the result: functionName()[STEP Jdbc Reader Jdbc Reader]] 
Java.lang.IleagalStateException: Invalid sql column in the result: functionName()


The JDBC Reader step expects a column name after the function. It will place the result of the query in this column. You need to create a column in the JDBC Reader step and specify Type for the newly created column.

In Query string of the JDBC Reader step input string in the following format: 

select functionName as Column from Table

In the example, functionName represents the function and Column - the column where the result of the query will be placed.