DRS View Data Problem

mikegohl · Post by **mikegohl** » Fri Dec 09, 2005 4:47 pm

I select the Generated SQL Query. When I choose view data, I get a message about some fields and tables not in my job. I paste the query into Oracle and it runs fine. I switch to User Defined and the view data works fine. Has anyone else had this experience?

chucksmith · Post by **chucksmith** » Fri Dec 09, 2005 5:33 pm

Your query is based upon the derivations on the column tab of the drs stage. I have seen this happen when the column name on the tab does not exist in one of the tables, regardless of the derivation. I know this "feature" has been fixed at 7.5.1A.