• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 354
  • Last Modified:

can UNION ALL type construct be built into a Logical File?

can a UNION ALL type construct be built into a Logical File?
How?
0
volking
Asked:
volking
1 Solution
 
Kent OlsenData Warehouse Architect / DBACommented:
Hi Fred,

That should be part of the CREATE VIEW declaration

CREATE VIEW myview
AS
SELECT * FROM sometableorview1 WHERE condition1
UNION ALL
SELECT * FROM sometableorview2 WHERE condition2;


Kent
0
 
tliottaCommented:
volking:

Your questions that are specific to LFs (rather than SQL VIEWs) would be better asked in one of the AS/400 forums.

If I understand your question, what you're looking for would be called a multiple format logical. You would list the logical definitions of the various Physical Files one after the other, rather than describing only one.

There are details, of course, but that's the basics.

Tom
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now