Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

What is dynamic join?

Can you please explain what a dynamic join is? Dynamic selection is only possible in OPENQRYF and embedded SQL. When we use the logical files, use the selection, and omit the keyword to select and omit a record, is this not a dynamic selection? If not, why?
Dynamic means that the join criteria is not applied until the query is actually run.

A keyed logical file with Select/Omit is not a dynamic selection because the selection (& omission) of records is done at the time that the logical file is created. The keyed select/omit logical file only contains entries for those rows meeting the select/omit criteria, so no additional selection is applied during the execution of the query or the open of the LF operation.


Check out this Search400.com Featured Topic: Database issues resolved

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: Tips, tutorials and more.

Dig Deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.