Text Attachments

[Noel_Harney72]

Hi
I am looking for some advice on Text Attachments.
Requirement : On a report (copy of stock status) to identify with a flag of Y/N if the item has a text attachment associated with it. Can anyone help with where text attachments are stored and how to check if any data is stored within the attachment.

Thanks

Noel

 

[Robert_Fletcher]

Noel
Your text attachment is stored in the GDTXVC field in F00165. The other
types are stored in folders specified by the Media Object Queues.
Add a text attachment and OneWorld writes a F00165 record , delete the text
attachment and record is deleted. To find the F00165 key look at the
definition of the Media Object Data Structure, the description of which is
described in the OneWorld programmers manual.
Regards
Robert Fletcher
XE, AS400 V4R4, NT, Citrix

 

[husni]

Hi Noel,
One easy way I could think of is to access the F00165 and check if an attachment exists.
The key will be GDOBNM = ‘GT4016B’ and GDTXKY = CONCAT((RPAD(IMITM,’ ‘),’|’)
Eg. GT4016B and 1| , GT4016B and 2500| …..