Hi Herman-Josef,
Hermann-Josef Krings [mailto:[EMAIL PROTECTED] wrote:
>
> I try to give loadercli a command file which has been
> extracted from the DB table triggers in UTF-8 format.
> On Linux:
> file TRIGGER.001
> TRIGGER.001: UTF-8 Unicode text
>
> Since the file has 3 Bytes in front (ef bb bf) which indicate
> it is an UTF-8 File,
> loadercli -u $ADMU,$ADMPW -d $DB -b $TRIGGER returns with:
> Error during execution
> -->-25010
> SQL error -3005 = Invalid SQL statement (error position: 1)
>
> If I remove the 3 leading bytes, the command-file is
> processed without problems.
>
> Is there a way to let loadercli know that the command file is
> of type UTF-8 ?
>
Not yet. With one of the next versions (>= 7.5.00.23) the Loader
will detect it automatically. We're currently working on this.
> Is there a way to get DATAEXTRACT TRIGGERNAME,DEFINITION from
> TRIGGERS to ASCII format?
>
Well, it depends on how you got the definitions. I'm pretty sure
you used a command like this:
DATAEXTRACT TRIGGERNAME,DEFINITION from TRIGGERS
OUTFILE 'some_name'
LONGFILE DEFINITION 'TRIGGER.001'
(at least on my system the DEFINITION column is of type LONG).
If you did not let me know the command you used.
If yes you could add the keyword ASCII to the LONGFILE def as here:
LONGFILE DEFINITION 'TRIGGER.001' ASCII
If you unfortunately have an UNICODE DB there is no chance to get the
definition in ASCII. The Loader would always stop with an error message
'Errors checking compatibility of external and db data types. ...'
It forbids at the moment to convert data from UCS2 to ASCII because of
the possible loss of data.
So in case of UNICODE DB the only chance to get it loaded is
to remove the marker :-(
BTW: How did you get the definition UTF8? You must have specified this
in
the command or have used a CATALOGEXTRACT command. Only for the
latter
the default codetype is set to UTF8.
Sorry for any inconvenience.
Regards,
Steffen
--
Steffen Schildberg
MaxDB Team
SAP Labs Berlin
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
