Page 3 of 3 FirstFirst 1 2 3
Results 21 to 26 of 26

Thread: E1 9.2.3 with 64-bit for client and server

  1. #21
    Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    959
    Hi John,

    I'm referring to using a table handle DD item (like HF4101) in an NER. The generated C stores the table handle in an ID.

    Code:
    *****************************************************************
    *  Variable declarations
    *****************************************************************/
    ID idRtnVal = ER_SUCCESS;
    ID evt_HandleF4101 = 0;
    JDEDB_RESULT iRtnJDB = JDEDB_ERROR;
    
    …
    
    
     /* VA evt_HandleF4101 = F4101.Open Handle */
     pAppVars->iTableRetCode = RTK_CER_FIOOpenHandle( hEnv, hUser ,
          _J("F4101") , pszDataSrc , 1 ,  0 , &evt_HandleF4101 );
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace and NERDup Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  2. #22
    Senior Member
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas
    Posts
    1,517
    Maybe I didn't do it right or misunderstood. I did use a DD item for the table I/O or at least I attempted to - see screen shot.
    Attached Images Attached Images
    Brian Oster
    Application Development Manager
    E1: 9.0 (TR9.1.5.1) / 9.2 (TR9.2.2.2)
    JAS/BSSV: Weblogic 12.1.2 / Weblogic 12.2
    ES: Win2008 / Win2016
    DB: MSSQL 2014 / 2016
    WebDev Client: Win7Pro / Win10Pro

  3. #23
    Senior Member
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas
    Posts
    1,517
    If you look through the rest of the generated code it uses evt_HandleF4101 to get table info in zHndlInfo

    Code:
    if ( RTK_CER_FIOGetHandleInfo( evt_HandleF0101 , &zHndlInfo ) )
    but all table I/O operations appear to happen using zHndlInfo.
    Code:
    JDB_FetchKeyed( zHndlInfo.hReqest
    The only other time evt_HandleF0101 is used is to close the evt_HandleF0101 handle...

    Code:
    pAppVars->iTableRetCode = RTK_CER_FIOCloseHandle( evt_HandleF0101 );
    pAppVars->iTableRetCode = RTK_CER_FIOCloseHandle( evt_HandleF0101 );
    ...why it calls it twice is a seperate mystery...
    Brian Oster
    Application Development Manager
    E1: 9.0 (TR9.1.5.1) / 9.2 (TR9.2.2.2)
    JAS/BSSV: Weblogic 12.1.2 / Weblogic 12.2
    ES: Win2008 / Win2016
    DB: MSSQL 2014 / 2016
    WebDev Client: Win7Pro / Win10Pro

  4. #24
    Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    959
    So the 32bit table IO handle is actually an abstraction from the request handle. This allows BSFNS to pass the handle around as an ID which will work in 32 and 64. RTK_CER_FIOGetHandleInfo will expose the true request handle to pass to the JDB APIs and will be the arch VOID* size. Pretty well thought out.

    The question remains about the cursor handle. Hopefully, I'll get some time to test that out.

    Craig
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace and NERDup Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  5. #25
    Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    959
    Looks like the cursor handle is a 64bit pointer, not truncated to 32bit. See the values below straight from the debug log.

    Code:
    Open Cursor Success - hCursor:[0000014A3FBB4290] hCache:[0000014A3F430EA0]
    So any code storing the cursor in an ID(32bit) will truncate and fail. We will have to use jdeStoreDataPtr to work with the 64bit address.
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace and NERDup Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  6. #26
    Senior Member
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas
    Posts
    1,517
    Good to know. Thanks for taking the time to confirm.
    Brian Oster
    Application Development Manager
    E1: 9.0 (TR9.1.5.1) / 9.2 (TR9.2.2.2)
    JAS/BSSV: Weblogic 12.1.2 / Weblogic 12.2
    ES: Win2008 / Win2016
    DB: MSSQL 2014 / 2016
    WebDev Client: Win7Pro / Win10Pro

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.