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