есть скрипт под линукс (Suse 10.1)


#!/bin/sh

source /opt/sybase/SYBSsa9/bin32/asa_config.sh

# накатить инкрементный лог на базу
dbisql -c "dbn=DB_NAME;uid=USER;pwd=USER" -host A.B.C.D -nogui -onerror continue -port 2638 /backup/inc_log.sql
if [ $? != 0 ]; then
echo Failed to rolling incremental log on
exit
fi

этот скрипт нормально выполняется, но мне нужно чтобы DBISQL читал файл в кирилице виндовс,
добавляю параметр -codepage 1251 :

#!/bin/sh

source /opt/sybase/SYBSsa9/bin32/asa_config.sh

# translate the last incremental log into sql script
dbisql -c "dbn=DB_NAME;uid=USER;pwd=USER" -codepage 1251 -host A.B.C.D -nogui -onerror continue -port 2638 /backup/inc_log.sql
if [ $? != 0 ]; then
echo Failed to rolling last incremental log on
exit
fi

скрипт перестает выполнятся , а DBISQL выдает HELP строку как пользоваться:

iAnywhere Solutions, Inc. One Sybase Drive, Dublin, CA 94568, USA
Copyright 1988-2003 Sybase Inc. Portions Copyrighted 2003, iAnywhere Solutions,
Inc. All rights preserved. All unpublished rights reserved.


Usage: DBISQL [options] [sqlCommand|commandFileName]

Options:
-c "keyword=value;..." database connection parameters
-codepage <codepage> use this codepage when reading/writing files
-d "delimiter" use the given string as the command delimiter
-d1 print statements as they are executed
(command-line mode only)
-dataSource <DSN> ODBC data source name
-f <fileName> open the given file for editing
-host <address> network address of the database server
-jConnect connect using jConnect
-nogui run in command-line mode
-ODBC connect using ODBC (default)
-onerror {continue|exit} override ON_ERROR option for all users
-port <portNumber> TCP/IP port number of the database server
-q suppress non-critical messages
-x check SQL syntax but do not execute

НЕ МОГУ ПОНЯТЬ ЧТО Я ПИШУ НЕ ТАК?

Dmitry..не знаю как в АСА, но например в джаве такой кодовой страницы, 1251, нет.
зато есть windows-1251 (a.k.a. cp1251)

если писать -codepage cp1251 таже самая ругань , как будто он эту опцию не понимает, потому что без нее то работает, а в HELP выдает что есть такая опция, бред какойто...

komrad,



Code page and character set reference

Supported code pages

--------------------------------------------------------------------------------

The following table lists code pages supported in Interactive SQL.

For more information, see Opening Interactive SQL using the dbisql command-line utility or Interactive SQL utility options.

Code Page Description
1252 Windows Latin-1
037 USA, Canada (Bilingual, French), Netherlands, Portugal, Brazil, Australia
273 IBM Austria, Germany
277 IBM Denmark, Norway
278 IBM Finland, Sweden
280 IBM Italy
284 IBM Catalan/Spain, Spanish Latin America
285 IBM United Kingdom, Ireland
297 IBM France
420 IBM Arabic
424 IBM Hebrew
437 MS-DOS United States, Australia, New Zealand, South Africa
500 EBCDIC 500V1
737 PC Greek
775 PC Baltic
838 IBM Thailand extended SBCS
850 MS-DOS Latin-1
852 MS-DOS Latin-2
855 IBM Cyrillic
856 IBM Hebrew
857 IBM Turkish
858 Variant of Cp850 with Euro character
860 MS-DOS Portuguese
861 MS-DOS Icelandic
862 PC Hebrew
863 MS-DOS Canadian French
864 PC Arabic
865 MS-DOS Nordic
866 MS-DOS Russian
868 MS-DOS Pakistan
869 IBM Modern Greek
870 IBM Multilingual Latin-2
871 IBM Iceland
874 IBM Thai
875 IBM Greek
918 IBM Pakistan (Urdu)
921 IBM Latvia, Lithuania (AIX, DOS)
922 IBM Estonia (AIX, DOS)
930 Japanese Katakana-Kanji mixed with 4370 UDC, superset of 5026
933 Korean Mixed with 1880 UDC, superset of 5029
935 Simplified Chinese Host mixed with 1880 UDC, superset of 5031
937 Traditional Chinese Host mixed with 6204 UDC, superset of 5033
939 Japanese Latin Kanji mixed with 4370 UDC, superset of 5035
942 IBM OS/2 Japanese, superset of Cp932
942 C Variant of Cp942
943 IBM OS/2 Japanese, superset of Cp932 and Shift-JIS
943 C Variant of Cp943
948 OS/2 Chinese (Taiwan) superset of 938
949 PC Korean
949 C Variant of Cp949
950 PC Chinese (Hong Kong, Taiwan)
964 AIX Chinese (Taiwan)
970 AIX Korean
1006 IBM AIX Pakistan (Urdu)
1025 IBM Multilingual Cyrillic: Bulgaria, Bosnia, Herzegovinia, Macedonia (FYR)
1026 IBM Latin-5, Turkey
1046 IBM Arabic - Windows
1097 IBM Iran (Farsi)/Persian
1098 IBM Iran (Farsi)/Persian (PC)
1112 IBM Latvia, Lithuania
1122 IBM Estonia
1123 IBM Ukraine
1124 IBM AIX Ukraine
1140 Variant of Cp037 with Euro character
1141 Variant of Cp273 with Euro character
1142 Variant of Cp277 with Euro character
1143 Variant of Cp278 with Euro character
1144 Variant of Cp280 with Euro character
1145 Variant of Cp284 with Euro character
1146 Variant of Cp285 with Euro character
1147 Variant of Cp297 with Euro character
1148 Variant of Cp500 with Euro character
1149 Variant of Cp871 with Euro character
1250 Windows Eastern European
1251 Windows Cyrillic
1253 Windows Greek
1254 Windows Turkish
1255 Windows Hebrew