RE: Viewing packed decimal field as a string

I was hoping to do this in SQL so that I can then do a LIKE '%12345%' where 12345 is the string in the packed decimal field so I can globally find all string values across all tables that contain that packed decimal value.

I don't think that EXTJRNDTA would do that since it is on a file by file basis and would take days to go through hundreds of files on a file by file basis like that.

-----Original Message-----
From: Dan <dan27649@xxxxxxxxx>
Sent: Tuesday, September 11, 2018 11:23 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Viewing packed decimal field as a string

Carsten Flensburg has an excellent utility that handles this automatically. EXTJRNDTA substitutes the fields from the record format of the original table in place of the JOESD (entry data string).

- Dan
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD