RE: LEi Conditional Clause SQL statement Daniel W Heichel 23.Mar.13 02:13 AM a Web browser LEI LEI - 8.0Windows
Is this a Conditional Clause for Source, or Target?
Can you confirm that this always works without the Conditional Clause applied?
Are you reducing the number of fields on one side to be fewer than what you have on the other? Do both sides only have the two fields, or does this conditional clause create a mismatch?
Finally, it appears that the Conditional Clause is on the Oracle side, and we can see that it's failing on Select with Missing Expression. Normally we would expect a "WHERE" clause here, giving it actual criteria by which to reduce the number of results. Instead, this statement simply asks for two fields with no further criteria. I believe this is why we're seeing "missing expression". To reduce the number of records being returned, you should be issuing a WHERE <criteria> statement to actually narrow the list, instead of simply selecting fields.
Return to top
. . RE: LEi Conditional Clause SQL stat... (Daniel W Heiche... 23.Mar.13)
Print this page
