Kbase 22069: Case Sensitivity -- Dump File Names May Overwrite Each Other
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/5/2002 |
|
SUMMARY:
Case Sensitivity for the Progress Data Dictionary when dumping tables is adhered to on a platform specific basis.
If you are considering having multiple tables with similar dump names (same name except for the case being used), then you want to ensure that your Operating System is also case sensitive. If it is not, when you go to dump the files, they will overwrite each other.
UNIX is case sensitive. Window platforms are not case sensitive.
EXPLANATION:
The Data Dictionary will not allow you to have multiple tables in your database that have the same Dump File name. You will receive a error message:
That dump name is not unique within this database.
This is because the Data Dictionary is case sensitive. The Data Dictionary will accept file names with different character cases: lowercase, uppercase. Because it is case sensitive, you could have two or more tables with an identical Dump File name, with the only difference being the case of letters used within the name. Example: Cc1 and cc1.
SOLUTION:
If you are on a platform which is not case sensitive, you will need to change your Dump File name prior to dumping multiple tables which have similar Dump File names. Failure to do so will result in Dump Files being overwritten. If you are dumping the files individually, and you are on an Operating System which is not case sensitive, you will receive a warning that the file already exists and will be prompted to determine if the file should be overwritten.