In Query 400 i am trying to append File B to File A. (5=Add to member).

Each time i run the 2nd query for File B it gives me "Query output definition does not match file <FILENAME> in <LIBRARYNAME>". I notice that file A is of Type CHAR and file B is of Type ZONED. Would this prevent an append from taking place?

I have given the File field descriptions below and also the Define Result fields for File B.

Can you tell me what criteria in the define result fields display may work to allow an append. Regards, John.

File A

(Field Description) Field   Type     Length Length Position    Usage   Heading ESTRF CHAR    8                8         24    Both     Transaction

File B

(Field Description) Field Type    Length Length Position Usage Heading XVAL ZONED 8 2              8 24         Both   Trans Value

Define Result Fields

(For File B) Field Expression        Column Heading Len Dec XVAL VALUE(centvl,8) Trans Value           8    2



Software/Hardware used:
iSeries400, OS400 V5R4M5 L00