# 1 mainframe fields spans into 2 other fields

**URL:** <https://techcommunity.softwareag.com/t/1-mainframe-fields-spans-into-2-other-fields/78489>\
**Category:** Forum\
**Tags:** Mainframe-Integration, ApplinX\
**Created:** [July 7, 2008, 7:04am UTC](https://techcommunity.softwareag.com/t/1-mainframe-fields-spans-into-2-other-fields/78489 "2008-07-07T07:04:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Victor\_Law](https://avatars.discourse-cdn.com/v4/letter/v/54ee81/32.png) [@Victor\_Law](https://techcommunity.softwareag.com/u/Victor_Law)\
**Post date:** [July 7, 2008, 7:04am UTC](https://techcommunity.softwareag.com/t/1-mainframe-fields-spans-into-2-other-fields/78489/1 "2008-07-07T07:04:13Z")

</div>

Prospect want to combine mainframe screen with information from Unix DB2 database (e.g Chinese name and the staff photo based on the English name field from mainframe).  
For a mainframe 's secreen return the employee’s English name returned, prospect want to add an extra field ‘Chinese name’ and a photo where ApplinX will examine the English name and then do a SQL query SELECT on this Unique identify to the Unix DB2 database with the unique identify English name.

I check the manual but cannot find any relevant info. Please kindly advise.

---

<div class="post-metadata">

**Author:** ![Douglas\_Kelly](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/douglas_kelly/32/102_2.png) [@Douglas\_Kelly](https://techcommunity.softwareag.com/u/Douglas_Kelly)\
**Post date:** [July 7, 2008, 11:05am UTC](https://techcommunity.softwareag.com/t/1-mainframe-fields-spans-into-2-other-fields/78489/2 "2008-07-07T11:05:51Z")

</div>

I think you would be able to satisfy the requirement by adding the database query call in an appropriate user exit - which exit exactly depends on what platform you are using (.Net or Java) and whether you have a table of employees per page/screen or just one to display.

That is, from the ApplinX point of view you are just looking for where to modify the data being displayed on the web page. I don’t think this would be achieved through a transform, but through a generated code-behind.

---

<div class="post-metadata">

**Author:** ![Victor\_Law](https://avatars.discourse-cdn.com/v4/letter/v/54ee81/32.png) [@Victor\_Law](https://techcommunity.softwareag.com/u/Victor_Law)\
**Post date:** [July 9, 2008, 7:21pm UTC](https://techcommunity.softwareag.com/t/1-mainframe-fields-spans-into-2-other-fields/78489/3 "2008-07-09T19:21:49Z")

</div>

Thanks for reply.  
It is Java and 1 employee / screen.  
Could you point me to ApplinX how to use UExit to acheive this.  
I just wonder if customer would accept we need to modify generated code such as JSP.  
They are using OPAL which SAG suggest to replace due to no support.

---

<div class="post-metadata">

**Author:** ![Douglas\_Kelly](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/douglas_kelly/32/102_2.png) [@Douglas\_Kelly](https://techcommunity.softwareag.com/u/Douglas_Kelly)\
**Post date:** [July 10, 2008, 12:09pm UTC](https://techcommunity.softwareag.com/t/1-mainframe-fields-spans-into-2-other-fields/78489/4 "2008-07-10T12:09:11Z")

</div>

I’d probably generate the screen (JSP and Java code-behind) and use the gx\_postFillForm user exit in the code-behind.

Something has to be update in the JSP: you need to indicate where the photo and Chinese name are going to appear on the web page since neither of these elements exist on the host screen.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 2:50pm UTC](https://techcommunity.softwareag.com/t/1-mainframe-fields-spans-into-2-other-fields/78489/5 "2021-04-02T14:50:36Z")

</div>


