RE: SQL join 2 files

["Jeff Crosby" <jlcrosby@xxxxxxxxxxxxxxxx>]

It's not a multiformat logical, is it?

What do you want to know from DMITMMST?  Note that's one of the physical
files, not the resultant view. (Jeez, I just called it a physical file
instead of a table.  Does that tell you I don't think in SQL.  Yet.)

Here's the initial error from the joblog:

MCH5601    Escape                  40   06/20/07  08:59:52.472080
DbDsCursor               005FA0   QDBGETSQ    QSYS        084D 

Message . . . . :   Template value not valid for instruction.

Cause . . . . . :   The location of the value is template  with an offset to

field in bytes X'0004', an offset in field in bits X'0000', a length of

field of 1, and an instruction operand number of 2.  The reason code is

X'0063'. If the reason code is X'0000', a reason code may not be available.