home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 18 REXX
/
18-REXX.zip
/
IMPEXP.ZIP
/
CHGCPAGE.DOC
next >
Wrap
Text File
|
1991-09-11
|
3KB
|
84 lines
THE 4 REXX UTILITIES "QMEXPO.CMD", "QMIMPO.CMD","TBLIMPO.CMD" AND "TBLEXPO.CMD"
WILL ASSIST YOU IN CONVERTING YOUR DATABASE FROM ONE CODE PAGE TO ANOTHER.
IF YOU HAVE TRIED TO IMPORT A TABLE THAT WAS BUILT WITH A CODEPAGE OTHER
THAN THE ONE YOU HAVE INSTALLED YOUR HAVE PROBABLY SEEN THE FOLLOWING MESSAGE :
"SQL3063U THE SBCP VALUE 00XXX IN THE H RECORD IS NOT COMPATIBLE
WITH THE SBCP VALUE 00XXX FOR THE DATABASE. THE FORCEIN OPTION
WAS NOT SPECIFIED."
THE "FORCEIN" OPTION ON IMPORT WILL CAUSE CODEPAGE CONFLICTS TO BE IGNORED.
YOU CAN SET THE FORCEIN OPTION IN QUERYMGR BY BUILDING A PROFILE FOR YOUR
DATABASE AND DESELECTING THE "COMPARE CODEPAGE" OPTION. YOU COULD THEN
USE QUERYMGR TO IMPORT EACH OBJECT ONE AT A TIME. A MUCH SIMPLIER METHOD
IS TO USE THE PROCEDURE OUTLINED BELOW.
THE STEPS TO CONVERT YOUR DATABASE ARE OUTLINED BELOW :
*** BEFORE YOU TRY THIS MAKE SURE YOU HAVE A GOOD BACKUP OF YOUR
DATABASE.
1. YOU MUST START UP WITH THE SYSTEM CONFIGURED WITH THE CODEPAGE
THE DATABASE WAS CREATED UNDER.
CHECK YOUR CONFIG.SYS TO MAKE SURE THE CODEPAGE AND COUNTRY CODE
ARE CORRECT. IF THEY ARE DIFFERENT FROM THE ORIGINAL CODEPAGE
MODIFIY YOUR CONFIG.SYS AND REBOOT THE MACHINE.
2. YOU MUST HAVE A "GOOD" COPY OF THE DATABASE LOADED. IF YOU ARE
UNSURE OF THE CONDITION OF THE DATABASE RESTORE IT FROM A BACKUP
TAKEN WHEN THE ORIGINAL CODEPAGE WAS INSTALLED.
3. START QUERYMGR AND OPEN THE DATABASE
4. EXPORT EACH TABLE TO AN "IXF" FILE USING TBLEXPO.CMD.
5. EXIT QUERYMGR
6. RUN "QMEXPO.CMD". THIS UTILITY WILL EXPORT ALL OF YOUR QUERYMGR
OBJECTS (QUERIES, FORMS..ETC) TO AN "IXF" FILE. YOU WILL BE
PROMPTED TO ENTER THE DATABASE NAME AND THE NAME OF THE "IXF" FILE
THAT YOU WANT TO STORE THE OBJECTS IN. YOU MUST INCLUDE THE
EXTENSION "IXF" WITH THE FILENAME. (EX. OBJECTS.IXF).
7. VIEW THE LOG FILE CREATED TO MAKE SURE THE EXPORT RAN CORRECTLY
BEFORE GOING ANY FURTHER.
8. START QUERYMGR AND ERASE THE DATABASE
9. EXIT QUERYMGR
10. EDIT YOUR CONFIG.SYS FILE AND CHANGE THE CODEPAGE TO THE CODEPAGE
YOU WISH TO CONVERT THE DATABASE TO.
11. REBOOT YOUR MACHINE.
12. START QUERYMGR AND OPEN A NEW DATABASE
13. EXIT QUERYMGR
14. RUN THE UTILITY "TBLIMPO.CMD". THIS UTILITY WILL RESTORE EACH OF
YOUR TABLES ONE AT A TIME. YOU WILL BE ASKED TO SUPPLY THE NAME
OF THE DATABASE AND THE NAMES OF EACH "IXF" FILE AND TABLE.
YOU MUST INCLUDE THE EXTENSION "IXF" ON THE FILENAME.
VIEW THE LOG AFTER EACH IMPORT TO MAKE SURE THAT ALL ROWS WERE
ACCEPTED.
15. RUN THE UTILITY "QMIMPO.CMD". THIS UTILITY WILL RESTORE ALL OF
YOUR QUERYMGR OBJECTS (QUERIES, FORMS..ETC). YOU WILL BE ASKED
TO SUPPLY THE DATABASE NAME AND THE NAME OF THE "IXF" FILE THAT
"QMEXPO.CMD" STORED THE OBJECTS IN. YOU MUST INCLUDE THE THE
EXTENSION "IXF" WHEN ENTERING THE FILE NAME.
VIEW THE LOG AFTER THE IMPORT TO MAKE SURE ALL ROWS WERE ACCEPTED.
16. ** TASK COMPLETE **