× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: Data Conversion
  • From: rbarker@xxxxxxxxxx
  • Date: Thu, 2 Nov 2000 15:38:49 +1000



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.