SQL Reference input

devanars · Post by **devanars** » Wed Apr 01, 2009 8:34 am

Hi Guys

I have noticed sql input reference in odbc stage.May i know what is the difference between user defined sql and sql reference input. i have noticed both of them in odbc stage. can anybody help me to know the difference. i am not able to find in documentation much.Thanks

ray.wurlod · Post by **ray.wurlod** » Wed Apr 01, 2009 3:32 pm

There are two kinds of input link, stream (get next row) and reference (get row by key). One SQL statement relates to the former, the other to the latter and contains a WHERE clause that refers to the key column(s).