6.4 버전에서 받은 (unloaddb -cs -so ) 파일을 다른 서버에서 로드 하는 중에 발생하는 에러 메시지 입니다.
SRC( Solaris 5.9 Unisql 6.4 ) ==> DEST ( Solaris 5.8 Unisq 6.6 , 7.1)
line 1: syntax error at "call" missing EOF
....
....
invalid token near line 1014 (text was ';')
invalid token near line 1022 (text was ';')
invalid token near line 1024 (text was ';')
invalid token near line 1040 (text was ';')
invalid token near line 1042 (text was ';')
invalid token near line 1070 (text was ';')
invalid token near line 1072 (text was ';')
줄바꿈 문자때문에 발생하는 것으로 생각되서 변환하고 해봐도 마찬가지네요.
create serial pusr_seq
start with 626798
increment by 1
minvalue 1
maxvalue 99999999
cycle;
update db_serial set owner = :auser, started=1 where name= 'pusr_seq';
call find_user('XXXX') on class db_user to auser;
create serial seq_num
start with 5113
increment by 1
minvalue 1
maxvalue 99999
cycle;
update db_serial set owner = :auser, started=1 where name= 'seq_num';
CREATE CLASS user_tab_comments;
call change_owner('user_tab_comments', 'XXXX') on class db_root;
CREATE CLASS otmp_eng_addr;
call change_owner('otmp_eng_addr', 'XXXX') on class db_root;
CREATE CLASS otmc_counter;
call change_owner('otmc_counter', 'XXXX) on class db_root;
CREATE CLASS otmp_prov_dtl;
call change_owner('otmp_prov_dtl', 'XXXX') on class db_root;