How to make a join, using a define field (concatenation of three fields) in the Hold file(FOCUS DB) against a define file in RDBMS

Please advice....

This message has been edited. Last edited by: Kerry,

As mentioned in a previous post to you, this is not a recommended technique as it is VERY inefficient.

Table against the RDBMS including the defined field and HOLD FORMAT FOCUS INDEX def_field. Make sure that you include any appropriate WHERE clauses.

Join the HOLD file to the held FOCUS file.

If you try to do what you said you wanted to do, WebFOCUS will wind up doing the join.

You cannot join TO a defined field. You must join to a real field in the cross-reference (i.e. joined TO) file. Some DBs allow for joining to the first part of an alpha key field so you don't have to match the whole key value. Other than that, you have to do all your defining in the host file. Ginny has given you the best way to do what you seem to need.