I am creating a process that gets data from a database and writes it to another database table.
In my map step I have a SQLLookup where I am writing a select query like so
SELECT a.NNO, A.ID, CONCATINATE(a.FIRSTNAME,a.MIDDLENAME,a.LASTNAME), a.RNO from jjobs a
where a.RNO = RNOID
The RNOID you see above is the input variable to SQLConnection and for output variables I gave same names you see in the query.
When I run the query I get this error
Embedded message: [Function: Sql Lookup]: DB access error!; Caused by: Parameter index out of range (1 > number of parameters, which is 0).