In the past I've used embedded SQL in an SQLRPGLE program and on the FETCH INTO statement I specify an externally defined data structure with the definition of the file I am SQLing thus allowing me to read in the entire record's fields mapped correctly in one FETCH INTO statement...
This works great when you're SQLing one file...
I'm currently joining 5 files together and I would like to capture the content of all 5 record's fields mapped correctly using one FETCH INTO statement...?
Can I use this same trick when joining two or more files...?
Can this be done or am I barking up the wrong tree...?
August 21, 2006 2:32 PM
May 28, 2008 8:26 PM