How to specify a hexa decimal key in Joinkeys?

to_sreeni · New User Joined: 08 Jul 2009 Posts: 17 Location: bangalore

Hi, we have two VB files (496 length including RDW). Now i have to segregate the input file based on a key. If this key is present in second file i have to write that record to MATCH file (Out file1). If not then i have to write file1 records to UNMATCH file (Out file2). Here the key is in hexa decimal format.

Thanks,
Sreenivas

Arun Raj · Posted: Fri Jul 10, 2009 6:28 pm

Sreenivas,

Welcome to the forums.

It does not matter in which format your key is, you just need to mention the starting position and length of the key-field in both the files in the JOINKEYS statement provided key-fields in both the files have the same format and length.

to_sreeni · New User Joined: 08 Jul 2009 Posts: 17 Location: bangalore

Hi,

Thanks for the quick response. Please find the below code which i am using. The hexa decimal number is at 9-11 position. If i exclude the hexa part in the key, it was giving the correct result. Otherwise , it is giving incorrect result. Please help.

Arun Raj · Posted: Fri Jul 10, 2009 7:53 pm

dick scherrer · Posted: Sat Jul 11, 2009 12:03 am

Hello,

Just a guess, but there may be numerically equal values with different signs. . .

As Arun requests,

to_sreeni · New User Joined: 08 Jul 2009 Posts: 17 Location: bangalore

Hi,

Input records in file1 are

dick scherrer · Posted: Mon Jul 13, 2009 8:10 pm

Hello,

You need to re-post your data using "HEX ON" and use the "Code" tag (which will preserve alignment).

When we can better see your data, we wioll be able to offer better suggestions.

dick scherrer · Posted: Mon Jul 13, 2009 8:13 pm

Hello,

I've "Code"ed your data, but we still need the HEX ON display. . .

to_sreeni · New User Joined: 08 Jul 2009 Posts: 17 Location: bangalore

Hi,
Input records in file1 are

dick scherrer · Posted: Tue Jul 14, 2009 7:39 pm

Hello,

The values in the 5-byte field do not match. . .

Suggest you check the processes that create these files and determine whether the first 2 bytes of this field should be x'40' or x'00'.

Alissa Margulies · Posted: Wed Jul 15, 2009 12:31 am

Dick,

I think you forgot to take into account the 4-byte RDW. The first byte of sample data shown is really position 5. Therefore, (20,5) is C1A35 in the first record.

Sreenivas,

dick scherrer · Posted: Wed Jul 15, 2009 1:03 am

Hi Alissa,

to_sreeni · New User Joined: 08 Jul 2009 Posts: 17 Location: bangalore

Hi Alissa,

I want the matching records of file 1 should be written to Match file.
This logic is working when i specify the single key (20,5,A);
Also, when i specify two keys (8,1,A) and (20,5,A)

But it is giving the empty MATCH file when i specify three keys (8,1,A), (9,3,A) and (20,5,A).

The reason for this is , the key (9,3,A) - the format here is hexadecimal value (It is not Packed decimal where the sign is speified in the last nibble).

PS: 9,3 gives the number (which is in hexa format in the record). It will never have a nagative value.

Please help me.

Thanks,
Sreenivas

to_sreeni · New User Joined: 08 Jul 2009 Posts: 17 Location: bangalore

Hi Alissa

Can you please help me?

Your help is very much appreciated.

Thanks,
Sreenivas

Alissa Margulies · Posted: Wed Jul 15, 2009 7:55 pm

All JOINKEYS fields are treated as binary format for purposes of comparison during the match processing.

With the sample data you provided, (9,3) does not match, so I would not expect there to be any matched records in the output. In File 1, the value is X'06DD26' whereas the value in File 2 is X'06DD27' . They simply don't match. If this is not the data you expected in the key field, then I would recommend that you verify your offsets.

to_sreeni · New User Joined: 08 Jul 2009 Posts: 17 Location: bangalore

HI Alissa,

It is working now. thanks a lot for your help.

Your help is very much appreciated.

Thanks,
Sreenivas