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

can a UNION ALL type construct be built into a Logical File?
How?
LVL 5
volkingAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
tliottaConnect With a Mentor Commented:
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.