IBM Mainframe Forum

Hello All,

In PGM1, I'm doing a Left Outer Join between two tables and the result set returns one of the field which is PIC X(10) as X'60606060606060606060' (Got this using HEX ON command in SPUFI for unmatched rows) which is a NOT NULL field as it is a part of Key field....

The requirement is to write them as is to a flat file in PGM1, which is used as i/p by another program, PGM2

Now in PGM2, i need to check that alphanumeric field for NULL or X'60606060606060606060' to do further processing...

Please advice...

Thanks!
Ramanan R

Please don't ask the question in multiple fora/ums. It will only get you a roasting and a loss of interest in your question.