Input port in JDBCRun operator should be optional

[natashadsilva]

Sometimes you want to use the operator to simply run a statement, such as create statement where there are no parameters. However, the input port is required, so it means you have to create a Beacon to send in dummy data just to run the operator, just like in this example: https://github.com/IBMStreams/streamsx.jdbc/blob/develop/samples/JDBCSample/com.ibm.streamsx.jdbc.sample.jdbcrun/JDBCRunSample.spl#L63

Could we change the operator model so that the input ports are all optional? This would make the operator can be more user friendly.

[markheger]

Not possible to change the operator model to have two optional input ports. JDBCRun has one mandatory and one control port (optional).

Alternative solution: Create a new operator JDBCRunSingleStatement or JDBCSource without any input port, works like source operator.