|
Thanks ROB. My conversion documents did not have any explanation of 01/01/2001, but I saw the updated OGS posting dated 1/11/2000 which would have been late last night my time. Thanks a lot for the prompt reply. Regards, AP -----Original Message----- From: rbarker@ssa.com.au [mailto:rbarker@ssa.com.au] Sent: Thursday, November 02, 2000 4:39 PM To: BPCS-L@midrange.com Subject: Re: Data Conversion Anthony, The conversion instructions advise you to change the CONVERT command Begin Date parameter to 20010101. Rob Barker Anthony Perera <Anthony_Perera@csl.com.au> on 02/11/2000 01:08:45 PM Please respond to BPCS-L@midrange.com To: "'BPCS-L@midrange.com'" <BPCS-L@midrange.com> cc: (bcc: Rob Barker/SSA/AU) Subject: Data Conversion Hi, We are currently running BPCS 405CD and implementing 6.1.1. I have been running data conversions and looking at discrepancies. Our current KMR,KFP files have due dates of 2001/01/01 and these dates are getting converted as 1901/01/01. We are doing a multistep conversion and tracked down the problem to when the database is converted from 5.2.2 to 6.0.0. I had a look at the conversion programs for this step and found that the 6 digit date 10101 is hard coded in all the programs and if any file date fields hit this then the date is updated with 1901/01/01 which is the default century begin date in the convert command. If I change this to 2001/01/01 it will fix the problem but I'm not sure whether it will have any other repercussions since I cannot find any logical reason for this begin date to be used in the first place. any ideas? please help. Convert BPCS Databases (CONVERT) Type choices, press Enter. From (OLD) Files Library . . . . FRMBPCSF Name From (OLD) Version . . . . . . . 4.0 2.0, 2.1, 3.0, 3.1, 4.0 From (OLD) Release . . . . . . . 00 00-99 TO Files Library to create . . . XXXBPCSF Name To (New) Version . . . . . . . . 6.1 2.1, 3.0, 3.1, 4.0, 5.0 To (New) Release . . . . . . . . GA 00-99, GA Final BPCS Files Library . . . . NEWBPCSF Name Purged Prime Data Library . . . PRGPRMLIB Name Century Date Break . . . . . . . 40 Year Begin Date . . . . . . . . . . . 19010101 YYYYMMDD Date JOBQ for batch processing . . . QBATCH Name Library . . . . . . . . . . . QGPL Name Thanks, AP **************************************************************************** ************************************ This email and any attached files are intended solely for the named addressee, are confidential and may contain legally privileged information. The copying or distribution of them or any information they contain, by anyone other than the addressee, is prohibited. If you have received this email in error, please let us know by telephone or return the email to the sender and destroy all copies. Thank you. CSL Limited A.C.N. 051 588 348 45 Poplar Road Parkville Victoria 3052 Australia Phone: +61 3 9389 1911 Fax: +61 3 9389 1434 **************************************************************************** ************************************ +--- | This is the BPCS Users Mailing List! | To submit a new message, send your mail to BPCS-L@midrange.com. | To subscribe to this list send email to BPCS-L-SUB@midrange.com. | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com. | Questions should be directed to the list owner: dasmussen@aol.com +--- +--- | This is the BPCS Users Mailing List! | To submit a new message, send your mail to BPCS-L@midrange.com. | To subscribe to this list send email to BPCS-L-SUB@midrange.com. | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com. | Questions should be directed to the list owner: dasmussen@aol.com +--- **************************************************************************************************************** This email and any attached files are intended solely for the named addressee, are confidential and may contain legally privileged information. The copying or distribution of them or any information they contain, by anyone other than the addressee, is prohibited. If you have received this email in error, please let us know by telephone or return the email to the sender and destroy all copies. Thank you. CSL Limited A.C.N. 051 588 348 45 Poplar Road Parkville Victoria 3052 Australia Phone: +61 3 9389 1911 Fax: +61 3 9389 1434 **************************************************************************************************************** +--- | This is the BPCS Users Mailing List! | To submit a new message, send your mail to BPCS-L@midrange.com. | To subscribe to this list send email to BPCS-L-SUB@midrange.com. | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com. | Questions should be directed to the list owner: dasmussen@aol.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.