One Star

Problem Using "Propagate QUERY's recordset"

On most of the tXXXRow components there is a check box on the Advanced settings tab.
It appears to me that this will insert the result of the query into a COLUMN of the current flow.
In my case, I have a text file that has a series of SQL commands in it like this:
SELECT count(*) FROM Tablename WHERE REC_TIME BETWEEN time_a AND time_b
SELECT count(*) FROM Tablename WHERE REC_TIME BETWEEN time_c AND time_d
SELECT count(*) FROM Tablename WHERE REC_TIME BETWEEN time_e AND time_f
I want to execute the query and insert the result in a column in the data flow.
Here are some pics. I cannot seem to get this to work unless the column is defined as an object. Then, when I look at the resulting text file, the object column has data in it like this:
com.ibm.db2.jcc.b.j@bb7759
How do I make sense of this?? I want the actual count not the odd stuff that appears above.23575 vs
2 REPLIES
Employee

Re: Problem Using "Propagate QUERY's recordset"

Once you have checked the propagate RECORD SET, you can parse it using tParseRecordSet (root of the db components family)
HTH,
One Star

Re: Problem Using "Propagate QUERY's recordset"

It keeps generating errors when I try to use this component.
I cannot find any detailed information on how to do this.
Could you please post some additional screen shots telling how to use this.

If anyone has used this component and can give me some more information, I'd really appreciate it