Hello.

See /opt/sdb/7500/misc/create_demo_db.sh (or wherever you've installed
MAXDB).
Basically, you need to specify two parameters
  param_put _UNICODE YES
  param_put DEFAULT_CODE UNICODE
in the dbmcli call below.

export SID=MTSCMS3
export HOME=/var/opt/sdb
export INSTROOT=/opt/sdb/7500
export DBM=dbm,********
export DBA=dba,********
dbmcli -s -R $INSTROOT db_create $SID $DBM

mkdir -p $HOME/$SID

dbmcli -s -d $SID -u $DBM <<EOF
param_rmfile
param_startsession
param_init OLTP
param_put CAT_CACHE_SUPPLY 300
param_put CACHE_SIZE 3000
param_put MAXDATAVOLUMES 5
param_put _UNICODE YES
param_put DEFAULT_CODE UNICODE
param_checkall
param_commitsession
param_addvolume 1 DATA $HOME/$SID/DISKD0001 F 2560
param_addvolume 1 LOG  $HOME/$SID/DISKL001  F 1024
quit
EOF

dbmcli -d $SID -u $DBM db_start

dbmcli -d $SID -u $DBM <<EOF
util_connect $DBM
db_activate $DBA
quit
EOF

dbmcli -d $SID -u $DBM load_systab -u $DBA -ud domain


HTH,
Matthias


> -----Original Message-----
> From: Alok Ranjan [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, April 27, 2004 8:56 AM
> To: [EMAIL PROTECTED]
> Subject: Creating unicode data base
> 
> 
> Hi,
> i am using MAXDB 7.5.0 and i wana to create an UNICODE 
> supported data base in  i apporached with two way for this 
> 
> 1.) dbmcli db_create TESTDB test,test UNICODE = YES
> its giving me :
> 
> ERR
> -24946,ERR_TOOMANYPARAM: too many parameters
> 
> 2.) sqlcli ALOKDB=> create user rocky password abc dba 
> defaultcode unicode
> 
> its giving me :
> * -3008: Invalid keyword or missing delimiter
> SQLSTATE: 42000
> 
> what wiil be the right way and syntax for creating an
> unicode database i also refered docs in the maxdb
> library
> 
> ALok Ranjan
> 
> 
>       
>               
> __________________________________
> Do you Yahoo!?
> Win a $20,000 Career Makeover at Yahoo! HotJobs  
> http://hotjobs.sweepstakes.yahoo.com/careermakeover 
> 
> -- 
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:    
> http://lists.mysql.com/maxdb?> [EMAIL PROTECTED]
> 



-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to