× Discuss about Archiving, Close of Business, Delivery Setup, Security Management System, Global Processing etc…

OPERATION Field in Enquiry - Get Field Value from another Table

  • McLanJohn
  • Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 8 hours ago #23566 by McLanJohn
Hello all, 

In a NOFILE enquiry I extracted the value of a field called STATUS from X local table, however I do not intend to display the STATUS as is but rather its Description as specified in Y core table. How can I use the OPERATION field in ENQUIRY to fetch this value from Y core table and display it. 

Thank you for taking time to answer.

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
More
2 years 11 months ago #23567 by VK
Hi
see field CONVERSION:

LINK XXX,YYY
Read file XXX using the current data as the key and return field name YYY as defined in the STANDARD.SELECTION record for XXX. Do not specify F. or company mnemonic in file name. Field Name YYY may be a data field or an I or J descriptor defined in the Standard Selection record of file XXX Note that if a multi or sub valued item is returned from a LINK conversion, the multi and sub values are converted to spaces, so the result cannot be displayed in separate lines.
 

Cheers
VK

Please Log in or Create an account to join the conversation.

Time to create page: 0.073 seconds