DW Select Field = Field?

[tpayne]

I need to select records on a DW version where the value of one field is equal to another. Since DW encompasses much of the OPNQRYF functionality I would hope that you could do this, but I can't figure out a way to do it.
In this case I want to only select records from the address book where the Main Address (ABAN8) is equal to the Factor Address (ABAN85). If I just try to put the ABAN85 field name in the selection area anywhere it gets prefixed by '00' (00ABAN85) which does not work.
Any ideas?


Tony Payne - Senior Systems Analyst
Selmer-UMI
Elkhart, Indiana 46516

 

[Jim_rubino]

Have you tried this (see attached screen shot) in your data
selection?

=09
Jim

 

[bouncer]

You should be able to do aban8 = &abab85. I have seen some DWV with these selections. I hope this helps.

regards
Bala

 

[tpayne]

Thanks Bala and others who responded to this cry for help.
This is the correct solution - I'm sure I have seen it before but as usual
it's hard to find. Now have the program working.
Tony

PS: Jim - thanks for your reply - your screen shot attachment did not come
through - JDELIST drops attachments before sending out as they could contain
virus's.



Tony Payne - Senior Systems Analyst
Selmer-UMI
Elkhart, Indiana 46516

 

[tpayne]

Raising this topic again, in DW you can select records where the values of 2 fields are different in the data selection by prefixing the 2nd field by '&'.

Eg: Address Number *EQ &ABAN85

HOWEVER!

DW does not accept this for date fields - I can't find a way to get past the "invalid date" error message.

If you do know of a way to code this I would be pleased to know.



Tony Payne - Senior Systems Analyst
Selmer-UMI
Elkhart, Indiana 46516

 

[tpayne]

I have some feedback from JDE today regarding this issue.
Apparently comparing 2 date fields on data selection in a DW does not work,
and there is nothing about this in KG. I am going to try and get a SR
raised.
A SR exists for WW (1606637) regarding the same issue, but this has a status
"Returned not planned". You might want to add your name to the list if this
is of interest...



Tony Payne - Senior Systems Analyst
Selmer-UMI
Elkhart, Indiana 46516