Kbase P93655: How do the y/n work when a 9271 is recieved during a Proutil Bulkload.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/11/2004 |
|
Status: Unverified
GOAL:
What happens when the y or n is selected answering the 9271 verification question for a Bulkload?
FACT(s) (Environment):
Progress 9.1D
FIX:
The (9271) prompt was introduced to avoid the automatic (bulk)loading of the .d files using a default code page when the file does not contain the code page descriptor.
The inclusion of the (9271) message was introduced to avoid a potentially dangerous Version 8.3A bug (19981130-007) regarding the proutil bulkload and trailer information. If Progress could not read trailer information from .d file (codepage, date and number format), a warning message was issued ("defaults are used") and Progress started the load.
This behavior was quite dangerous because no chance was given to specify the desired parameters and / or stop the process. When the database was created, if a different default code page was used from when the information was dumped the database could contain characters from two code page sets after the load and could be corrupted.
When the warning below is received:
Warning: Unable to read the .d trailer. Do you want to use <current-code-page-is-given-here> as the code page for conversion? [y
]: (9271)
the answer to the "y" response is, the load will continue with the code page given in the message. However, if the response is "n" then the current .d file will not be read in, but the load process will proceed to the next .d file listed in the .fd file. The verification question will be asked again on this file is the codepage information is in doubt. This process is continued until all the files listed in the fd file have been processed.
If it is desirable to stop the process so corrections may be made to resolve this issue, the process may be kill while this message is being displayed. Once the corrections have been made the load may be started back up as long as the fd file is recreated so the tables which have been loaded are not selected or the .d files which have been loaded are removed so duplicate records are not created.