Timing Data Conversions

Wayne_Ivory

Member
We are developing Data Conversion UBE's in preparation for moving from our
Legacy system to OneWorld. I'd like to write a couple of Business Functions
to stick in the Process Begin and Process End events that would show how
many records were inserted and how long it took. We will be doing a
complete test run in a couple of weeks and this will guide us for when we go
live.

I see there is a Business Function "Get Current UTC Time" and a System
Literal ReportName which should be helpful. I have a few questions though.

1. Is there somewhere that all the System Literals and System Variables are
documented so I can see if anything else would be useful? (Like
LastTableAccessed or something).
2. I believe it is possible to write Business Functions in NER. Will I be
able to set a variable (say StartTime) in the Begin function that would be
visible to the End function when it gets there or would I have to setup
variables in each UBE to pass back and forth?
3. How can I get the number of records in a table? Is there some way I can
do a "select count(*)"? I know I could increment a variable for each record
inserted but I'm trying to avoid changing the UBE's themselves as much as
possible.
4. Is there anything other than the M&DDebug function that I can use to pop
up a simple message box upon completion.

TIA

Wayne Ivory
Information Services
Iluka Resources Limited

-------------------------------------------------------------------------
 
Wayne,

You may want to take alook at the Table Conversion UBE's logging options. Also if you use a function like GetAuditInfo this will return the current time, date, Workstation, and userid (also you can put a Program ID in the Table) you can insert those into the audit fields on the table you are loading. Then you can query the table or use the logging options on the table conversion.

Good Luck,
Tull Patulak
---------- Original Message ----------------------------------
From: Wayne Ivory <[email protected]>
Reply-To: [email protected]
Date: Thu, 2 Nov 2000 20:49:07 -0800 (PST)

>We are developing Data Conversion UBE's in preparation for moving from our
>Legacy system to OneWorld. I'd like to write a couple of Business Functions
>to stick in the Process Begin and Process End events that would show how
>many records were inserted and how long it took. We will be doing a
>complete test run in a couple of weeks and this will guide us for when we go
>live.
>
>I see there is a Business Function "Get Current UTC Time" and a System
>Literal ReportName which should be helpful. I have a few questions though.
>
>1. Is there somewhere that all the System Literals and System Variables are
>documented so I can see if anything else would be useful? (Like
>LastTableAccessed or something).
>2. I believe it is possible to write Business Functions in NER. Will I be
>able to set a variable (say StartTime) in the Begin function that would be
>visible to the End function when it gets there or would I have to setup
>variables in each UBE to pass back and forth?
>3. How can I get the number of records in a table? Is there some way I can
>do a "select count(*)"? I know I could increment a variable for each record
>inserted but I'm trying to avoid changing the UBE's themselves as much as
>possible.
>4. Is there anything other than the M&DDebug function that I can use to pop
>up a simple message box upon completion.
>
>TIA
>
>Wayne Ivory
>Information Services
>Iluka Resources Limited
>
>-------------------------------------------------------------------------
>
>
>
>
>--------------------------
>To view this thread, visit the JDEList forum at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=391
>*************************************************************
>This is the JDEList One World Developers Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>
>
 
Wayne,
1.) What is your opinion about to run your Data Conversion UBEs from a shell UBE?
Some advantage of this solution:
* You can determine easily (and the same way) the start and stop time.
* You can create an independent and free style printout (report) with all the information that you need (record count?) from this shell UBE without changing Data Conversion UBE.
* You can run more Data Conversion UBE after each other.
* etc.

2.) Tull has written you about GetAuditInformation. Yes, OW use this BSFN to retrieve audit information and store them in the audit fields of the tables. Here is some additional information from me:

The BSFN returns the WorkstationID in a Data Item based on JOBN. JOBN is 10 char length Data Item but your real WorkstationID could be longer. In this case the string will be truncated and maybe ambiguous.
There is an other BSFN "Get Local Compurter ID" (B9800181) which returns the ID in a MKEY based Data Item. MKEY is 15 char length.

Hope, could help.
Zoltán
 
Back
Top