CANNOT MAKE SET ALL=PASS WORK
CANNOT MAKE SET ALL=PASS WORK
(OP)
Hi
I've reac a couple of threads about left joins, and was hoping they would help in my current situation.
I thought that -SET ALL=PASS; would work to allow me to return unmatched records on a master table while using a where statement to govern the returns on the guest table.
unfortunately it does not seem to be working as described, and is behaving as an inner join.
I tried setting 'SQL EDA OPTIMIZATION ON' With no luck.
I'm working in wf 4.3 with eda connecting to informix database...
any help gettting the SET ALL= PASS to work as a left join would be much appreciated
M
I've reac a couple of threads about left joins, and was hoping they would help in my current situation.
I thought that -SET ALL=PASS; would work to allow me to return unmatched records on a master table while using a where statement to govern the returns on the guest table.
unfortunately it does not seem to be working as described, and is behaving as an inner join.
I tried setting 'SQL EDA OPTIMIZATION ON' With no luck.
I'm working in wf 4.3 with eda connecting to informix database...
any help gettting the SET ALL= PASS to work as a left join would be much appreciated
M
RE: CANNOT MAKE SET ALL=PASS WORK
RE: CANNOT MAKE SET ALL=PASS WORK
What does the leading hyphen do for me anyway, I've noticed while the conventions here (my place of work) seem to be to use it, on the forums, few people include it in their posts
thanks much
RE: CANNOT MAKE SET ALL=PASS WORK
RE: CANNOT MAKE SET ALL=PASS WORK
RE: CANNOT MAKE SET ALL=PASS WORK
I'm looking to use the set all=pass to leverage the performance of a join. the set all=on setting works, and the problem is that I am parameterizing a field of the guest table, which is why I am going with the set all = pass
Is there an optimization setting that I can use to make this work? or do I mis understand the purpose of set all = pass
RE: CANNOT MAKE SET ALL=PASS WORK