Home Forums Tech Database SQL – convert HEX messages from F00165.GDTXFT to string (JDE )

This topic contains 0 replies, has 1 voice, and was last updated by  Udar Gromov 1 year ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #5662

    Udar Gromov
    Keymaster

    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

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.