MVSFORUMS.com

[psmadhusudhan]

Hi

I have two tables
NUDM6.TDMZTPC
NUDM6.TDMZTPL

These two tables contain following columns
NUDM6.TDMZTPC: ZTP_BUS_TRAN_IDFR(CHAR(50)), ZTP_MIA_KEYDECIMAL(15,0).
NUDM6.TDMZTPL: ZTP_BUS_TRAN_IDFR(CHAR(50)), ZTP_MIA_KEYDECIMAL(15,0)

Now treat the combination of ZTP_BUS_TRAN_IDFR, ZTP_MIA_KEY columns in table TDMZTPC as COMB1 and table TDMZTPL as COMB2. Means combination of these columns should be treated as single value.

Now I need the fetch the rows from NUDM6.TDMZTPL TABLE where COMB2 is not in COMB1.

Following are the Input tables and Result table

[s_shivaraj]

Madhu,
When you concatenate the timestamp with some other field you need to convert the Timestamp as String , i suppose you are missing that. That is the reason for -171.

Just put

[psmadhusudhan]

Hi shivaraj

I think you didnt see the data types of the columns. It is not timestamp, it is character char(50). Could you try again and let me no.
_________________
Thanks
Madhu Sudhan

[CICS Guy]

Why not play with Sivaraj's idea and try to char the second field - that is where the error is pointing...

[kolusu]

psmadhusudhan,

You do NOT have to concatenate the char and decimal column to compare the values. Just use both columns in the where clause and you will get the desired results

try this

[s_shivaraj]

psmadhusudhan,
Sorry i didnt see the field description. Yes you have to change the other field ZTP_MIA_KEYDECIMAL as CICS Guy pointed.

But Kolusu idea looks pretty easy.
_________________
Cheers
Sivaraj S

'Technical Skill is the Master of complexity, while Creativity is the Master of Simplicity'

[psmadhusudhan]

Kolusu

Thank u very much. The problem is solved.
_________________
Thanks
Madhu Sudhan