Re: Run SQL Scripts: Converting hex data into human readable

On 27-Apr-2017 08:01 -0600, Rob Berendt wrote:

When I run this query in Run SQL Scripts I am seeing hex data for
entry_data. How do I see that in character?

SELECT journal_code, journal_entry_type
, job_name, Job_user, job_number
, Remote_port, Remote_address, system_name
, Entry_Timestamp, Receiver_name
, Program_name, Program_library
, OBJECT, object_type
, CHAR(ENTRY_DATA, 256)
, x.*
FROM TABLE
( QSYS2.Display_Journal
( 'QSYS', 'QAUDJRN' /* Journal library and name */
, STARTING_TIMESTAMP => CURRENT TIMESTAMP - 24 HOURS
/* Time period */
)
) AS x
WHERE Job_user in('TOM', 'DICK', 'HARRY')
;

Consider: Issue a "CREATE FUNCTION show_AudJrn_Entry_Data_as_VarChar" that will invoke code to perform the necessary work to satisfy the requirement [of mapping the unstructured binary data into formatted character strings]; i.e. according to the following, as a suggested revision to the above SELECT invocation, wherein that UDF would appear in place of the CHAR() scalar:

SELECT …
, show_AudJrn_Entry_Data_as_VarChar
( journal_entry_type, Entry_Data )
…