Results 1 to 6 of 6

Thread: Copying "E" type records

  1. #1

    Copying \"E\" type records

    Hello List,

    Is there a way in JDE OW to copy only "E" records of the F0101
    from one data source to another? We've looked at the R98403 and played
    with the data selection, but can't find the right combination.

    Or are we going to have to result to SQL to get the records over?

    Thanks,
    Wade Wells
    XE, XU1, SP15, Win2K, SQL2K Live on GL/AP
    Getting ready to pull in HR/Payroll






  2. #2
    Member
    Join Date
    May 2001
    Location
    Minnesota
    Posts
    44

    Re: Copying \"E\" type records

    Why would you want to do this? The reason being is that when you create your employee master records, that is when the address book for employees are created. Am I missing something?

    Scott

    Scott Warwick
    Anderson Warwick Consulting Services, Inc.
    www.JDETips.com

  3. #3

    RE: Copying \"E\" type records

    Hi Wade

    We (apps consultants) use MS Access to "play" with our data and writing
    an Access query to copy these records would take under a minute to
    write. Being a non-technical person I find this much easier than using
    SQL.

    Kind Regards
    Bernadette

    XE, Update 1, SP15, Oracle, HP

    =2D----Original Message-----
    From: WWells@futurenext.com [mailto:WWells@futurenext.com]
    Sent: 24 May 2001 12:52
    To: jdelistml@jdelist.com
    Cc: WWells@futurenext.com
    Subject: Copying "E" type records


    Hello List,

    Is there a way in JDE OW to copy only "E" records of the F0101
    from one data source to another=3F We've looked at the R98403 and playe=
    d
    with the data selection, but can't find the right combination.

    Or are we going to have to result to SQL to get the records over=3F

    Thanks,
    Wade Wells
    XE, XU1, SP15, Win2K, SQL2K Live on GL/AP
    Getting ready to pull in HR/Payroll




    =2D-------------------------



  4. #4
    Senior Member Zoltan_Gyimesi's Avatar
    Join Date
    Oct 2000
    Location
    Budapest, Hungary
    Posts
    4,167

    Re: Copying \"E\" type records

    Hi Wade,
    My answer is a general response to how to copy records between environments with native OneWorld tools. Let's see.

    Method 1.:
    ==========
    Create Table Conversion UBE where you can select (and override at runtime) the Input and Output environment. It is really very simple and fast to create it for only one table. You can map the Output fields with a single click on the "Map the same" button. You can apply more sophisticated logic too. You can also override the selection at runtime if you will.

    Method 2.:
    ==========
    Create your logic as ER and use Table I/O statemenets to accomplish it. Use the HANDLE method where you can determine the environment for the subsequent Table I/O operations in the OpenHandle statement and can use different handles for Input and Output. You can apply more sophisticated logic too. You can place your logic into a BSFN as well into an APPL or UBE.

    Could it be some of help for you?

    Zoltán

    B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
    (working with B7321, B7331, XE too)
    - XE UPDATE 2 SP22, Intel NT4, SQL 2000
    - B9 (8.93B1)
    - was/is working with B7321, B7331, B7332 too

  5. #5

    RE: Copying \"E\" type records

    Zoltan,

    I had thought of using your Method 1, (after submitting the question).
    However, not being extremely familiar with writing UBEs, will pass this
    info to some of the report writers at the account.

    Thanks,
    Wade




  6. #6
    Senior Member Zoltan_Gyimesi's Avatar
    Join Date
    Oct 2000
    Location
    Budapest, Hungary
    Posts
    4,167

    Re: RE: Copying \"E\" type records

    Hi Bill,
    Believe me that creating such type of a simple TC UBE isn't a complicated task.
    Let's just try it and let to lead you by the Table Conversion Wizzard.
    Zoltán

    B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
    (working with B7321, B7331, XE too)
    - XE UPDATE 2 SP22, Intel NT4, SQL 2000
    - B9 (8.93B1)
    - was/is working with B7321, B7331, B7332 too

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.