Hi Stephen,
User DBA connected to database MYDB1 on local host.
DBEXTRACT CATALOG OUTSTREAM FILE 'extract-catalog'
DATA OUTSTREAM FILE 'extract-data' RECORDS UCS2
you have to specify the encoding UCS2 if you want extract a unicode database.
Hans-Georg Bumes
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Montag, 16. Februar 2004 23:49
To: [EMAIL PROTECTED]
Subject: urgent! MaxDB 7.5.0.8 loadercli - Intel to Sparc with unicode
Importance: High
I can not get the Solaris Sparc system to import the data created with loadercli
DBEXTRACT PAGES. This is with the same version of MaxDB
(7.5.0.8) on both Windows XP and Solaris 8. I have tried it remote (using Windows XP
loadercli with node parameter) and local (using scp to
copy file to solaris then using ssh session to try native Solaris loadercli). It
fails to insert any of the records, showing a page of raw binary
data as being in error.
I did find in the mysql.con online documentation that there are parameters other than
"PAGES". However, when I try them with loadercli all of
them say unsupported except "RECORDS". And when I do "RECORDS", it fails too. Here
is what I get when I try to extract on my Windows
XP host using RECORDS...
User DBA connected to database MYDB1 on local host.
DBEXTRACT CATALOG OUTSTREAM FILE 'extract-catalog'
DATA OUTSTREAM FILE 'extract-data' RECORDS
Error during execution
-->-25350
Conversion from UNICODE data to ASCII data is not supported; this conversion may
lose information
Ok... I need help :) Format "PAGES" fails the Big-Endian switch and format "RECORDS'
won't work wtih Unicode?
Stephen Gutknecht
On Mon, 16 Feb 2004 18:04:33 , [EMAIL PROTECTED] sent:
>
>
>Hello,
>
>Using these commands:
>
>DBEXTRACT CATALOG OUTSTREAM FILE 'extract-catalog'
> DATA OUTSTREAM FILE 'extract-data' PAGES
>
>I am creating an extract from Windows 2000 / Windows XP. Intention is to import into
>a Solaris 64-bit system. What concerns me is the use
>of the "PAGES" parameter on the data file. Are these raw pages, meaning they will
>faill on the Solaris FASTLOAD / DBLOAD ?
>
>Recently it was discussed on this mailing list how DBEXTRACT syntax was broken in
>MaxDB 7.5 where it used to work in SAPDB 7.4. Is there
>an alternate format than "PAGES"?
>
>The current online MaxDB documentation doesn't seem to even cover this "PAGES"
>parameter (or did I overlook it?).
>
>Thank you.
>
> Stephen Gutknecht
>
>
>
>
>--
>MaxDB Discussion Mailing List
>For list archives: http://lists.mysql.com/maxdb
>To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
