• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Copying "E" type records

WWells

Active Member
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
 

smwarwick

Active Member
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
 
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-------------------------
 

Zoltan_Gyimesi

Legendary Poster
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)
 

WWells

Active Member
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
 

Zoltan_Gyimesi

Legendary Poster
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)
 
Top