Kbase 20259: 9271 Message on a Bulkload:Code Page Verification Prompt
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/05/2005 |
|
Status: Verified
FACT(s) (Environment):
Progress 8.3C
SYMPTOM(s):
Bulk load process prompts for code page verification.
Warning: Unable to read the .d trailer. Do you want to use <code-page> as the code page for conversion? [y
]: (9271)
CAUSE:
This extra (9271) prompt was introduced to avoid the automatic (bulk)loading of the .d files using a default code page.
The inclusion of the (9271) message was introduced to avoid the automatic 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 to 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, a different default code page could have been used. In that case, the database could contain characters from two code page sets after the load and could be corrupted.
FIX:
A work around for the job waiting for input when the iso8859-1 code page is acceptable, is to create a response file that responds to the (9271) prompt and redirects it back into the PROUTIL command similar to the following:
$DLC/bin/proutil CUSTOMER -C bulkload CUSTOMER.fd < response_file
In the response file, y's are set up for each table in the database. The response file looks like the following:
y
y
y
y
Etc.