×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
midrange.com
