SQL – convert HEX messages from F00165.GDTXFT to string (JDE )

[Udar Gromov]

This is how you convert HEX text stored in BLOB feild F00165.GDTXFT into normal text.

–2019-05-15 TU F00165
–MS SQL – read/convert HEX F00165.GDTXFT in into text

SELECT GDTXFT, CAST ( CAST ( GDTXFT AS VARBINARY(MAX)) AS NVARCHAR(MAX)) [TEXT] 
FROM F01131, F00165 
WHERE GDOBNM = 'GT01131' AND GDTXKY = ZZSERK

We are converting BLOB into VARBINARY and then VARBINARY into NVARCHAR.
This statement was tested on MS SQL Server 2012.

Result: if double conversion from HEX to text is good, you should see is totally useless messages that batch job has completed successfully.

This is an example of converted text value stored in F00165.GDTXFT:

To: 99900001@EnterpriseOneInternalMailbox, CC: The following OneWorld job has completed successfully. Report: R57030051 Version: V200V022 Host: OCHPXA1Q Originator: OCHPXA1Q Submit Date: 5/13/2019 Page Count: 661

RE:
JD Edwards EnterpriseOne Work Center

[Author]

Posts