In one of the DB2Input components, the SELECT statement uses a pseudo columns called ‘UNIQUE’
FROM "+context.BDU_DB2_Schema_BDU+".WATCHFOLDER WF
INNER JOIN "+context.BDU_DB2_Schema_BDU+".WATCHPATTERN P ON WF.ID = P.WATCHFOLDER_ID
WHERE P.ID = "+context.patternID
I am trying to find out what this is and so far online search is not yielding anything useful.
I am guessing that the ‘unique’ pseudo column retrieves the number of unique rows based on a number of non-unique columns that taken together may constitute a unique value (i.e. composite key), but clearly the above SQL does not suggest that.
When I attempt to execute the above SQL using SquirreL connected to DB2 DB, I get 5 rows of zeros.
Does anyone know what does this UNIQUE column supposed to do ?
Appreciate your help
Solved! Go to Solution.
Thanks. You were absolutely right. I have been a bozo. 'UNIQUE' is actually a column in the table rather then a pseudo column.
I have been staring at this SQL way to long to notice, the explanation is much simpler.
Thanks very much.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema