Reference a flat file in a DB2 Query



IBM's flagship relational database management system

Reference a flat file in a DB2 Query

Postby DonkeyKong » Fri Feb 03, 2017 9:18 pm

Right now I'm just messing around in SPUFI. Eventually I am going to either execute this from a job or from a COBOL program.

I'm dealing with a very complex query that is touching on multiple tables and the same table in multiple ways to get the data that I want.

So I have, say 6 SELECT statements. I would like to split these up so that I can reference them in the outer most SELECT as Flat files. Can I do that?

SELECT *
FROM (INCLUDE??) Flat.File.A
LEFT JOIN (INCLUDE??) Flat.File.B
WHERE.....

Thanks in advance for any help!

DK
DonkeyKong
 
Posts: 34
Joined: Thu Oct 02, 2014 7:51 pm
Has thanked: 3 times
Been thanked: 0 time

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post