You need to change your lineend to what the system you are exporting to
thinks it is. Open your new app, get the lineend character, open the old
app and set the lineend character to the one you just grabbed.
Albert
On 23/02/2012 11:16 AM, Coxen, Dayle wrote:
I am in the process of converting a large application from 6.5++ to 9.1.
As part of the upgrade process I have been unloading tables from a 6.5++
database and loading them into a 9.1 database.
I use the following to unload a table.
OUTPUT c:\mms65dat\activity.dat
UNLOAD DATA FROM activity
OUTPUT SCREEN
Below are just the first 8 SET statements of many generated:
SET QUOTES=NULL
SET QUOTES="
SET DELIMIT=NULL
SET DELIMIT=","
SET LINEEND=NULL
SET LINEEND="""
SET SEMI=NULL
SET SEMI=";"
(2 SET LINEEND statements are generated.)
The problem I just noticed today is - when I run the activity.dat file to load
the table, it throws an error on the second SET LINEEND statement.
-ERROR- Unrecognized SET keyword (205)
I do not recall getting this error before. It has been a while since I have
tried it.
If I comment out the second SET statement it works fine.
Anyone encountered this before? Suggestions?
I intend to convert the application from double to single quotes after I get it
up to 9.1.
I am running Build 9.1.5.20214.
Thank you and best regards,
Dayle Coxen
(850) 410-5635
Florida Department of Transportation
