jdewannab
Active Member
List,
I have created a table conversion to convert a oneworld custom file to F4072 (Advance Pricing) We have well over 5 million records to process and in 1 day it has only processed 400,000 records.
Does anyone have any idea on how to speed this up? Is a fetch faster than a business function? Would it be faster in a report than table conversion?
This is what my program is doing besides straight maps.
OW Custom File F4072L
OW Table Conversion F89574072L
OW File (Straight Insert) F89574072L
I fetch to F0101 with my 2nd item to get my item shortid
Call F0002 Get Next Adjustment KeyID
Function name F0002GetNextAdjustmentKeyID
Source Module B4500070
I do not parm anything in, I just have the program pass me the mnAdjustmentKeyId
I also use FormatDateFromDMY (business FUnction)
Function Name B41B0470
Source Module B41B0470
Any help will be greatly appreciated.
XE, Enterprise AS/400, Windows NT
Thanks,
I have created a table conversion to convert a oneworld custom file to F4072 (Advance Pricing) We have well over 5 million records to process and in 1 day it has only processed 400,000 records.
Does anyone have any idea on how to speed this up? Is a fetch faster than a business function? Would it be faster in a report than table conversion?
This is what my program is doing besides straight maps.
OW Custom File F4072L
OW Table Conversion F89574072L
OW File (Straight Insert) F89574072L
I fetch to F0101 with my 2nd item to get my item shortid
Call F0002 Get Next Adjustment KeyID
Function name F0002GetNextAdjustmentKeyID
Source Module B4500070
I do not parm anything in, I just have the program pass me the mnAdjustmentKeyId
I also use FormatDateFromDMY (business FUnction)
Function Name B41B0470
Source Module B41B0470
Any help will be greatly appreciated.
XE, Enterprise AS/400, Windows NT
Thanks,