Welcome Guest Login SignUp

Home

Technical

Functional

CNC

AS400

DB2

    Citrix

JDE News

Live Radio

Feedback

JDE Forum Comments/Reviews/Queries
3015 day(s) ago   #48
Name: TechZone
Category: Technical
Location: India
Date: 2012-02-27 18:44:32
Replies(2)

Status:
  #48

Using Table Handle in Oracle JDE EnterpriseOne

1). Create a table handle definition in the Data Dictionary if one does not already exist for your table (see F41021Handle for an example).
2). Create a Form or Report Level ER Variable based on the Data Dictionary handle entry.
3). If an application, use the "Table Open" and " statement in the Dialog Initialized event. Use the Close statement in the End Dialog event.
4). All I-O statements (Fetch, Select, etc) against that particularly table should use the same table handle variable.
One of the example of using table handle is to access multiple environments(data sources).
2068 day(s) ago   #160
Name: juli
Category: Technical
Location:
Date: 2014-10-01 05:29:35
Replies(2)

Status:
  #160

Using Table Handle in Oracle JDE EnterpriseOne

I am using existing handle and I have opened handle in Initialize section and closed the handle in End Section. I am trying to perform all the table I/O operations in Do Section. But when I am performing any table I/O operation, it is showing as "JUNK" on the left hand side of the "Mapping" Screen. Due to this all the I/O operations are failing. I am in 9.1 now. Please let me know if you have any suggetsions.
2068 day(s) ago   #161
Name: Teo
Category: Technical
Location: Singapore
Date: 2014-10-01 22:25:01
Replies(2)

Status:
  #161

Using Table Handle in Oracle JDE EnterpriseOne

Hi Juli

Make sure you are passing the correct environment name.
You can also refer to the Oracle support Doc ID 639024.1 which gives more detailed steps about Table Handles

Cheers!
Post Comments/Queries
Email:*
Name:*
Details:*
 
   
* Required Entry Field(s).  * Your comments may subject to varification.  * Your email ID will not appear in the forum.
 
Disclaimer: Most of the posts in this blog cater solutions/suggestions/workaround to issues for specific tools release or JDE E1 version and are just information only. Please be carefule while applying it in your environment. JDEthread will not be responsible for any data loss or spec corruption (if any).
Copyright © 2010 - 2020 JDEthread.in