I verified my proc using sqlstudio and executed the following 2 queries:
call data_uj( '0410', 1, 1, '1' )
select * from data0410
The data0410 exists, I created it before. The attached trace was made
when I executed this two queries.
Thanks,
Norbert
"Anhaus, Thomas" <[EMAIL PROTECTED]> írta:
> Norbert Felde wrote :
>
> >Hello,
> >
> >I wrote the dbproc as follows. I can create it and call it without any
> >error message, but it dous not insert any data into the table.
> >Could you
> >tell me what is wrong in the proc.
> >
> >thank you advance,
> >Norbert
> >
> >the proc:
> >
> >CREATE DBPROC DATA_UJ (
> > IN TABLEIDX varchar(4),
> > IN HEADERID integer,
> > IN PARAMID integer,
> > IN ERTEK varchar(100)
> > )
> > RETURNS CURSOR AS
> > VAR DID integer; IQ varchar(500);
> > $CURSOR = 'DATA_CUR';
> > TRY
> > SELECT SEQ_DATAID.NEXTVAL FROM DBA.DUAL;
> > FETCH INTO :DID;
> > SET IQ = 'INSERT INTO DNUSER.DATA' || TABLEIDX ||
> > '( DATAID, HEADERID, PARAMID, ERTEK )' ||
> > 'VALUES( ' || DID || ', ' || HEADERID ||', '|| PARAMID
> >||', '''|| ERTEK || ''')';
> > EXECUTE IQ;
> > DECLARE :$CURSOR CURSOR FOR
> > SELECT :DID AS RES FROM DBA.DUAL;
> > CATCH
> > IF( $RC <> 0 )
> > THEN STOP ( $RC, $ERRMSG );
> >
> >
> >
> >--
> >MaxDB Discussion Mailing List
> >For list archives: http://lists.mysql.com/maxdb
> >To unsubscribe:
> >http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
>
> I tried to reproduce the problem, unfortunately without success. After
a call of the procedure a row is
> inserted into the table DATAXXX.
> How did you verify that no insert has been executed ? Is it possible
that you didn't commit the
> transaction containing the dbproc call ?
> If you are sure that a row must have been inserted but is not
present in the table please
> send me a vtrace of the dbproc call. For vtrace please see
http://sapdb.2scale.net/moin.cgi/VTrace
>
> Best Regards,
> Thomas
>
>
************************************************************************
*** KERNPROT 7.5.0 2004-10-13 11:56:37 ***
************************************************************************
Input File: g:\maxdb\data\wrk\DANONE\knltrace.dat
---------- from entry 1.6 to 6.8197 (from page 1 to 6) -----------------
===== T4 ===== id6973 ======================================1.6 page 1
RECEIVE: ascii, full_swap, 70500-DBM (1 segment, len: 40)
(1.6 page 1)
ok / RETURN SEGMENT 1 (0 parts, len: 40)
diagnose_fc, sqlstate: '00000'
REQUEST: ascii, full_swap, 70500-DBM (1 segment, len: 80)
(1.102 page 1)
dbs SEGMENT 1 (1 part, len: 80)
session_sqlmode, user_cmd
command PART (1 argument, size: 36328)
buf(19): 'COMMIT WORK RELEASE'
>KB05 id6973 commit destroy_temp
>b01p_destroy tfnTemp; fileTfnNo = 0; ttfnPars
session: nil; fid = 0
fn: 1A00 0000FFFFFFFF0600 000000000000
b01p_destroy root 74545; e_ok
>b01p_destroy tfnTemp; fileTfnNo = 0; ttfnInto
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0800 000001000000
b01p_destroy root 89433; e_ok
[T4 ===== id6974 new TransNo] 1.442 page 1
KB05 id6974 e_ok
>KB05 id6974 release
KB05 id6974 e_ok
RECEIVE: ascii, full_swap, 70500-DBM (1 segment, len: 40)
(1.530 page 1)
ok / RETURN SEGMENT 1 (0 parts, len: 40)
commit_release, sqlstate: '00000'
===== timeout.id0 ========================================1.626 page 1
>KB51 inspect locklist
KB51 inspect locklist e_ok
===== T18 ===== id6971 ===================================1.682 page 1
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 96)
(1.682 page 1)
parse SEGMENT 1 (1 part, len: 96)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 36328)
buf(35):
63616C6C 20646174 615F756A 28202730 34313027 2C20312C 20312C20
27312720 290D0D 'call data_uj( '0410', 1, 1, '1' )..'
>KB05 id6971 commit
[T18 ===== id6975 new TransNo] 1.890 page 1
KB05 id6975 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 88)
(1.918 page 1)
ok / RETURN SEGMENT 1 (2 parts, len: 88)
cursor_pl_sql, sqlstate: '00000'
shortinfo PART (0 arguments, len: 0, size: 36328)
parsid PART (1 argument, size: 36312)
dialog_call, mess_type: delete
buf(12):
000009DC 00001002 12003C00
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 128)
(1.1110 page 1)
execute SEGMENT 1 (3 parts, len: 128)
internal, user_cmd
commit_immediately
parsid PART (1 argument, size: 36328)
dialog_call, mess_type: delete
buf(12):
000009DC 00001002 12003C00
resulttablename PART (1 argument, size: 36296)
buf(15): 'SQL_CURSOR_0020'
resultcount PART (1 argument, size: 36264)
result_count: UNDEF
RECEIVE: ascii, full_swap, 70500-XCI (1 segment, len: 0)
(1.1366 page 1)
parse SEGMENT 1 (1 part, len: 96)
internal, user_cmd
command PART (1 argument, size: 16296)
buf(39): 'SELECT SEQ_DATAID.NEXTVAL FROM DBA.DUAL'
REQUEST: ascii, full_swap, 70500-XCI (1 segment, len: 0)
(1.1542 page 1)
parse SEGMENT 1 (1 part, len: 96)
internal, user_cmd
command PART (1 argument, size: 16296)
buf(39): 'SELECT SEQ_DATAID.NEXTVAL FROM DBA.DUAL'
>b07cget key(12): FF000016 003C0020 00850000
b07cget root 104319; *** key_not_found ***
>b03eval zeroStartKey
Stop Key(1023):
FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF
FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF
FFFFFFFF
b03eval root 89332; e_ok
PageCnt 1; AllPageCnt 1
>b07cdel key(12): 2B000000 20202020 00B10001
b07cdel root 104319; *** key_not_found ***
RECEIVE: ascii, full_swap, 70500-XCI (1 segment, len: 104)
(1.2152 page 1)
ok / RETURN SEGMENT 1 (3 parts, len: 104)
select_fc, sqlstate: '00000'
shortinfo PART (0 arguments, len: 0, size: 16296)
parsid PART (1 argument, size: 16280)
mass_select_found, mess_type: select
buf(12):
000009DC 00001601 3C002C00
resulttablename PART (1 argument, len: 0, size: 16248)
REQUEST: ascii, full_swap, 70500-XCI (1 segment, len: 0)
(1.2384 page 1)
execute SEGMENT 1 (2 parts, len: 88)
session_sqlmode, user_cmd
parsid PART (1 argument, size: 16296)
mass_select_found, mess_type: select
buf(12):
000009DC 00001601 3C002C00
data PART (1 argument, len: 0, size: 16264)
>KB05 id6975/-28416 select TABID 0-86 zerokey
>b02first_ql zerokey
b02first_ql root 89332; e_ok
KB05 id6975/-28416 return_result
RECEIVE: ascii, full_swap, 70500-XCI (1 segment, len: 80)
(1.2768 page 1)
ok / RETURN SEGMENT 1 (2 parts, len: 80)
select_fc, sqlstate: '00000'
external WARNING 0: warning_exists
external WARNING 8: table_scan
resultcount PART (1 argument, size: 16296)
result_count: -1
resulttablename PART (1 argument, len: 0, size: 16272)
RECEIVE: ascii, full_swap, 70500-XCI (1 segment, len: 0)
(1.2952 page 1)
parse SEGMENT 1 (2 parts, len: 96)
internal, user_cmd
command PART (1 argument, size: 16296)
buf(12): 'FETCH INTO ?'
appl_param_desc PART (1 argument, size: 16264)
1. fixed(10)
REQUEST: ascii, full_swap, 70500-XCI (1 segment, len: 0)
(1.3152 page 1)
parse SEGMENT 1 (2 parts, len: 96)
internal, user_cmd
command PART (1 argument, size: 16296)
buf(12): 'FETCH INTO ?'
appl_param_desc PART (1 argument, size: 16264)
1. fixed(10)
RECEIVE: ascii, full_swap, 70500-XCI (1 segment, len: 136)
(1.3352 page 1)
ok / RETURN SEGMENT 1 (3 parts, len: 136)
fetch_next_fc, sqlstate: '00000'
shortinfo PART (1 argument, size: 16296)
1. pos: 1 io_len: 21 output fixed(38) mandatory
parsid PART (1 argument, size: 16264)
fetch_found, mess_type: fetch
buf(12):
000009DC 00001801 1C002A00
parsid_of_select PART (1 argument, size: 16232)
mass_select_found, mess_type: select
buf(12):
000009DC 00001601 3C002C00
REQUEST: ascii, full_swap, 70500-XCI (1 segment, len: 0)
(1.3616 page 1)
execute SEGMENT 1 (2 parts, len: 88)
session_sqlmode, user_cmd
parsid PART (1 argument, size: 16296)
fetch_found, mess_type: fetch
buf(12):
000009DC 00001801 1C002A00
data PART (1 argument, len: 0, size: 16264)
>KB05 id6975 fetch first TABID 0-86 zerokey
>b02first_ql key(9): 00FFFE00 00000000 00
b02first_ql root 89332; e_ok
KB05 id6975 return_result
RECEIVE: ascii, full_swap, 70500-XCI (1 segment, len: 136)
(1.4000 page 1)
ok / RETURN SEGMENT 1 (3 parts, len: 136)
fetch_next_fc, sqlstate: '00000'
resultcount PART (1 argument, size: 16296)
result_count: 1
data PART (1 argument, size: 16272)
buf(21):
00C61555 03000000 00000000 00000000 00000000 00
parsid_of_select PART (1 argument, size: 16232)
mass_select_found, mess_type: select
buf(12):
000009DC 00001601 3C002C00
REQUEST: ascii, full_swap, 70500-XCI (1 segment, len: 0)
(1.4264 page 1)
dbs SEGMENT 1 (1 part, len: 560)
internal, user_cmd
command PART (1 argument, size: 16296)
buf(501):
' INSERT INTO DNUSER.DATA0410( DATAID, HEADERID, PARAMID, ERTE'
'K )VALUES( 155503, 1, 1, '1') '
>KB05 id6975/-28160 get direct SYS2CAT key(12):
444E5553 45522020 004D0001 'DNUSER .M..'
>b02get key(12): 444E5553 45522020 004D0001 'DNUSER .M..'
b02get root 59552; *** key_not_found ***
KB05 id6975/-28160 *** key_not_found ***
>KB05 id6975 select_row direct TABID 0-7F key(9): 003C5996 0020454E 47
'.<Y.. ENG'
>b02direct_ql key(9): 003C5996 0020454E 47 '.<Y.. ENG'
b02direct_ql root 14892; e_ok
KB05 id6975 return_result
RECEIVE: ascii, full_swap, 70500-XCI (1 segment, len: 88)
(1.4921 page 1)
*** -4004 / RETURN SEGMENT 1 (1 part, len: 88)
insert_fc, errpos: 14, sqlstate: '42000'
errortext PART (1 argument, size: 16296)
buf(27): 'Unknown table name:DATA0410'
RECEIVE: ascii, full_swap, 70500-XCI (1 segment, len: 0)
(1.5089 page 1)
parse SEGMENT 1 (2 parts, len: 136)
internal, user_cmd
command PART (1 argument, size: 16296)
buf(53):
4445434C 41524520 3F204355 52534F52 20464F52 0D090909 53454C45
4354203F 20415320 52455320 46524F4D 20444241 2E445541 4C
'DECLARE ? CURSOR FOR....SELECT ? AS RES FROM DBA.DUAL'
appl_param_desc PART (2 arguments, size: 16224)
1. char_asc(64)
2. fixed(10)
REQUEST: ascii, full_swap, 70500-XCI (1 segment, len: 0)
(1.5329 page 1)
parse SEGMENT 1 (2 parts, len: 136)
internal, user_cmd
command PART (1 argument, size: 16296)
buf(53):
4445434C 41524520 3F204355 52534F52 20464F52 0D090909 53454C45
4354203F 20415320 52455320 46524F4D 20444241 2E445541 4C
'DECLARE ? CURSOR FOR....SELECT ? AS RES FROM DBA.DUAL'
appl_param_desc PART (2 arguments, size: 16224)
1. char_asc(64)
2. fixed(10)
>b07cget key(12): FF00001A 003C0020 00850000
b07cget root 104319; *** key_not_found ***
>b03eval zeroStartKey
Stop Key(1023):
FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF
FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF
FFFFFFFF
b03eval root 89332; e_ok
PageCnt 1; AllPageCnt 1
>b07cdel key(12): 2D000000 20202020 00B10001
b07cdel root 104319; *** key_not_found ***
RECEIVE: ascii, full_swap, 70500-XCI (1 segment, len: 128)
(1.6003 page 1)
ok / RETURN SEGMENT 1 (3 parts, len: 128)
select_fc, sqlstate: '00000'
shortinfo PART (2 arguments, size: 16296)
1. pos: 1 io_len: 65 input char_asc(64) mandatory
2. pos: 66 io_len: 7 input fixed(10) optional
parsid PART (1 argument, size: 16256)
mass_select_found, mess_type: select
buf(12):
000009DC 00001A01 3C002C00
resulttablename PART (1 argument, len: 0, size: 16224)
REQUEST: ascii, full_swap, 70500-XCI (1 segment, len: 0)
(1.6259 page 1)
execute SEGMENT 1 (2 parts, len: 160)
session_sqlmode, user_cmd
parsid PART (1 argument, size: 16296)
mass_select_found, mess_type: select
buf(12):
000009DC 00001A01 3C002C00
data PART (1 argument, size: 16264)
buf(72):
20444154 415F4355 52202020 20202020 20202020 20202020 20202020
20202020 20202020 20202020 20202020 20202020 20202020 20202020
20202020 20202020 2000C615 55030000
' DATA_CUR '
' ...U...'
>KB05 id6975/-27648 select TABID 0-86 zerokey
>b02first_ql zerokey
b02first_ql root 89332; e_ok
KB05 id6975/-27648 return_result
>b07cget key(138):
00000000 00000000 00B54441 54415F43 55522020 20202020 20202020
20202020 20202020 20202020 20202020 20202020 20202020 20202020
20202020
'..........DATA_CUR '
b07cget root 104319; *** key_not_found ***
RECEIVE: ascii, full_swap, 70500-XCI (1 segment, len: 88)
(1.6835 page 1)
ok / RETURN SEGMENT 1 (2 parts, len: 88)
select_fc, sqlstate: '00000'
external WARNING 0: warning_exists
external WARNING 8: table_scan
resultcount PART (1 argument, size: 16296)
result_count: -1
resulttablename PART (1 argument, size: 16272)
buf(8): 'DATA_CUR'
>KB05 id6975 commit
[T18 ===== id6976 new TransNo] 1.7059 page 1
KB05 id6976 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 88)
(1.7087 page 1)
ok / RETURN SEGMENT 1 (2 parts, len: 88)
cursor_pl_sql, sqlstate: '00000'
resultcount PART (1 argument, size: 36328)
result_count: -1
resulttablename PART (1 argument, size: 36304)
buf(8): 'DATA_CUR'
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 136)
(1.7279 page 1)
dbs SEGMENT 1 (1 part, len: 136)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 36328)
buf(75):
'DESCRIBE "DATA_CUR '
' "'
>KB05 id6976 commit
[T18 ===== id6977 new TransNo] 1.7527 page 1
KB05 id6977 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 96)
(1.7555 page 1)
ok / RETURN SEGMENT 1 (2 parts, len: 96)
describe_fc, sqlstate: '00000'
columnnames PART (1 argument, size: 36328)
buf(4):
03524553 '.RES'
shortinfo PART (1 argument, size: 36304)
1. pos: 1 io_len: 7 output fixed(10) optional
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 136)
(1.7755 page 1)
parse SEGMENT 1 (1 part, len: 136)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 36328)
buf(80):
' FETCH POS(?) "DATA_CUR '
' "'
>KB05 id6977 commit
[T18 ===== id6978 new TransNo] 1.8003 page 1
KB05 id6978 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 144)
(1.8031 page 1)
ok / RETURN SEGMENT 1 (3 parts, len: 144)
fetch_pos_fc, sqlstate: '00000'
external WARNING 0: warning_exists
external WARNING 3: count_param_outcol
shortinfo PART (2 arguments, size: 36328)
1. pos: 1 io_len: 7 input fixed(10) mandatory
2. pos: 1 io_len: 7 output fixed(10) optional
parsid PART (1 argument, size: 36288)
fetch_found, mess_type: fetch
buf(12):
000009DC 00001B01 1C002A00
parsid_of_select PART (1 argument, size: 36256)
mass_select_found, mess_type: select
buf(12):
000009DC 00001A01 3C002C00
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 120)
(2.118 page 2)
execute SEGMENT 1 (3 parts, len: 120)
internal, user_cmd
commit_immediately
parsid PART (1 argument, size: 36328)
fetch_found, mess_type: fetch
buf(12):
000009DC 00001B01 1C002A00
resultcount PART (1 argument, size: 36296)
result_count: UNDEF
data PART (1 argument, size: 36272)
buf(7):
00C11000 000000
>KB05 id6978 fetch next TABID 0-86 zerokey
>b02next_qual key(9): 00FFFE00 00000000 00
b02next_qual root 89332; e_ok
KB05 id6978 return_result
>KB05 id6978 commit
[T18 ===== id6979 new TransNo] 2.590 page 2
KB05 id6979 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 120)
(2.618 page 2)
ok / RETURN SEGMENT 1 (3 parts, len: 120)
fetch_pos_fc, sqlstate: '00000'
resultcount PART (1 argument, size: 36328)
result_count: 1
data PART (1 argument, size: 36304)
buf(7):
00C61555 030000
parsid_of_select PART (1 argument, size: 36280)
mass_select_found, mess_type: select
buf(12):
000009DC 00001A01 3C002C00
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 136)
(2.866 page 2)
parse SEGMENT 1 (1 part, len: 136)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 36328)
buf(73):
' FETCH "DATA_CUR '
' "'
>KB05 id6979 commit
[T18 ===== id6980 new TransNo] 2.1114 page 2
KB05 id6980 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 136)
(2.1142 page 2)
ok / RETURN SEGMENT 1 (3 parts, len: 136)
fetch_next_fc, sqlstate: '00000'
external WARNING 0: warning_exists
external WARNING 3: count_param_outcol
shortinfo PART (1 argument, size: 36328)
1. pos: 1 io_len: 7 output fixed(10) optional
parsid PART (1 argument, size: 36296)
fetch_found, mess_type: fetch
buf(12):
000009DC 00001D01 1C002A00
parsid_of_select PART (1 argument, size: 36264)
mass_select_found, mess_type: select
buf(12):
000009DC 00001A01 3C002C00
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 96)
(2.1406 page 2)
execute SEGMENT 1 (2 parts, len: 96)
internal, user_cmd
commit_immediately
parsid PART (1 argument, size: 36328)
fetch_found, mess_type: fetch
buf(12):
000009DC 00001D01 1C002A00
resultcount PART (1 argument, size: 36296)
result_count: UNDEF
>KB05 id6980 fetch next TABID 0-86 zerokey
>b02next_qual key(9): 00FFFE00 00000000 01
b02next_qual root 89332; *** no_next_record ***
KB05 id6980 *** no_next_record ***
>KB05 id6980 commit
[T18 ===== id6981 new TransNo] 2.1830 page 2
KB05 id6981 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 72)
(2.1858 page 2)
*** 100 / RETURN SEGMENT 1 (1 part, len: 72)
fetch_next_fc, errpos: 1, sqlstate: '02000'
errortext PART (1 argument, size: 36328)
buf(13): 'Row not found'
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 128)
(2.2010 page 2)
parse SEGMENT 1 (1 part, len: 128)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 36328)
buf(72):
'CLOSE "DATA_CUR '
' "'
>KB05 id6981 commit
[T18 ===== id6982 new TransNo] 2.2250 page 2
KB05 id6982 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 88)
(2.2278 page 2)
ok / RETURN SEGMENT 1 (2 parts, len: 88)
close_fc, sqlstate: '00000'
parsid PART (1 argument, size: 36328)
close_found, mess_type: close
buf(12):
000009DC 00001E01 06002800
shortinfo PART (0 arguments, len: 0, size: 36296)
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 96)
(2.2470 page 2)
execute SEGMENT 1 (2 parts, len: 96)
internal, user_cmd
commit_immediately
parsid PART (1 argument, size: 36328)
close_found, mess_type: close
buf(12):
000009DC 00001E01 06002800
resultcount PART (1 argument, size: 36296)
result_count: UNDEF
>KB05 id6982 commit
[T18 ===== id6983 new TransNo] 2.2702 page 2
KB05 id6983 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 72)
(2.2730 page 2)
ok / RETURN SEGMENT 1 (1 part, len: 72)
close_fc, sqlstate: '00000'
parsid_of_select PART (1 argument, size: 36328)
mass_select_found, mess_type: select
buf(12):
000009DC 00001A01 3C002C00
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 104)
(2.2882 page 2)
dbs SEGMENT 1 (2 parts, len: 104)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 36328)
buf(12): 'DROP PARSEID'
parsid PART (1 argument, size: 36296)
fetch_found, mess_type: fetch
buf(12):
000009DC 00001B01 1C002A00
>b07cnext key(4): FF00001B
b07cnext root 104319; *** no_next_record ***
>KB05 id6983 commit
[T18 ===== id6984 new TransNo] 2.3242 page 2
KB05 id6984 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 40)
(2.3270 page 2)
ok / RETURN SEGMENT 1 (0 parts, len: 40)
drop_parseid_fc, sqlstate: '00000'
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 104)
(2.3366 page 2)
dbs SEGMENT 1 (2 parts, len: 104)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 36328)
buf(12): 'DROP PARSEID'
parsid PART (1 argument, size: 36296)
fetch_found, mess_type: fetch
buf(12):
000009DC 00001D01 1C002A00
>b07cnext key(4): FF00001D
b07cnext root 104319; *** no_next_record ***
>KB05 id6984 commit
[T18 ===== id6985 new TransNo] 2.3726 page 2
KB05 id6985 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 40)
(2.3754 page 2)
ok / RETURN SEGMENT 1 (0 parts, len: 40)
drop_parseid_fc, sqlstate: '00000'
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 104)
(2.3850 page 2)
dbs SEGMENT 1 (2 parts, len: 104)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 36328)
buf(12): 'DROP PARSEID'
parsid PART (1 argument, size: 36296)
close_found, mess_type: close
buf(12):
000009DC 00001E01 06002800
>b07cnext key(4): FF00001E
b07cnext root 104319; *** no_next_record ***
>KB05 id6985 commit
[T18 ===== id6986 new TransNo] 2.4210 page 2
KB05 id6986 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 40)
(2.4238 page 2)
ok / RETURN SEGMENT 1 (0 parts, len: 40)
drop_parseid_fc, sqlstate: '00000'
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 104)
(2.4334 page 2)
dbs SEGMENT 1 (2 parts, len: 104)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 36328)
buf(12): 'DROP PARSEID'
parsid PART (1 argument, size: 36296)
dialog_call, mess_type: delete
buf(12):
000009DC 00001002 12003C00
>b07cnext key(4): FF000016
b07cnext root 104319; *** no_next_record ***
>b07cnext key(138):
00000000 00000000 00B50000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
b07cnext root 104319; *** no_next_record ***
>b07cnext key(4): FF000018
b07cnext root 104319; *** no_next_record ***
>b07cnext key(4): FF00001A
b07cnext root 104319; *** no_next_record ***
>b07cnext key(138):
00000000 00000000 00B50000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
b07cnext root 104319; *** no_next_record ***
>b07cnext key(4): FF000010
b07cnext root 104319; *** no_next_record ***
>KB05 id6986 commit
[T18 ===== id6987 new TransNo] 2.5294 page 2
KB05 id6987 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 40)
(2.5322 page 2)
ok / RETURN SEGMENT 1 (0 parts, len: 40)
drop_parseid_fc, sqlstate: '00000'
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 80)
(2.5418 page 2)
parse SEGMENT 1 (1 part, len: 80)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 36328)
buf(24):
73656C65 6374202A 2066726F 6D206461 74613034 31300D0D
'select * from data0410..'
>b07cget key(138):
00000000 00000000 00B54441 54413034 31302020 20202020 20202020
20202020 20202020 20202020 20202020 20202020 20202020 20202020
20202020
'..........DATA0410 '
b07cget root 104319; *** key_not_found ***
>b07cget key(12): FF000023 003C0020 00850000
b07cget root 104319; *** key_not_found ***
>b03eval zeroStartKey
Stop Key(1023):
FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF
FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF
FFFFFFFF
b03eval root 607; e_ok
PageCnt 1; AllPageCnt 1
>b07cdel key(12): 2F000000 20202020 00B10001
b07cdel root 104319; *** key_not_found ***
>KB05 id6987 commit
[T18 ===== id6988 new TransNo] 2.6164 page 2
KB05 id6988 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 104)
(2.6192 page 2)
ok / RETURN SEGMENT 1 (3 parts, len: 104)
select_fc, sqlstate: '00000'
shortinfo PART (0 arguments, len: 0, size: 36328)
parsid PART (1 argument, size: 36312)
mass_select_found, mess_type: select
buf(12):
000009DC 00002301 3C002C00
resulttablename PART (1 argument, len: 0, size: 36280)
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 104)
(2.6424 page 2)
dbs SEGMENT 1 (2 parts, len: 104)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 36328)
buf(9): 'DESCRIBE '
parsid PART (1 argument, size: 36296)
mass_select_found, mess_type: select
buf(12):
000009DC 00002301 3C002C00
>KB05 id6988 commit
[T18 ===== id6989 new TransNo] 2.6664 page 2
KB05 id6989 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 152)
(2.6692 page 2)
ok / RETURN SEGMENT 1 (2 parts, len: 152)
describe_fc, sqlstate: '00000'
columnnames PART (4 arguments, size: 36328)
buf(30):
06444154 41494408 48454144 45524944 07504152 414D4944 05455254
454B '.DATAID.HEADERID.PARAMID.ERTEK'
shortinfo PART (4 arguments, size: 36280)
1. pos: 1 io_len: 7 output integer(10) mandatory
2. pos: 8 io_len: 7 output integer(10) optional
3. pos: 15 io_len: 7 output integer(10) optional
4. pos: 22 io_len: 101 output varchar_asc(100) optional
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 128)
(2.6948 page 2)
execute SEGMENT 1 (3 parts, len: 128)
internal, user_cmd
commit_immediately
parsid PART (1 argument, size: 36328)
mass_select_found, mess_type: select
buf(12):
000009DC 00002301 3C002C00
resulttablename PART (1 argument, size: 36296)
buf(15): 'SQL_CURSOR_0021'
resultcount PART (1 argument, size: 36264)
result_count: UNDEF
>KB05 id6989/-25088 select TABID 0-03CA zerokey
>b02first_ql zerokey
b02first_ql root 607; *** no_next_record ***
KB05 id6989/-25088 return_result
>b07cget key(138):
00000000 00000000 00B55351 4C5F4355 52534F52 5F303032 31202020
20202020 20202020 20202020 20202020 20202020 20202020 20202020
20202020
'..........SQL_CURSOR_0021 '
b07cget root 104319; *** key_not_found ***
>KB05 id6989 commit
[T18 ===== id6990 new TransNo] 2.7548 page 2
KB05 id6990 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 104)
(2.7576 page 2)
*** 100 / RETURN SEGMENT 1 (2 parts, len: 104)
select_fc, errpos: 1, sqlstate: '02000'
errortext PART (1 argument, size: 36328)
buf(13): 'Row not found'
resulttablename PART (1 argument, size: 36296)
buf(15): 'SQL_CURSOR_0021'
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 80)
(2.7784 page 2)
parse SEGMENT 1 (1 part, len: 80)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 36328)
buf(23): 'CLOSE "SQL_CURSOR_0021"'
>KB05 id6990 commit
[T18 ===== id6991 new TransNo] 2.7976 page 2
KB05 id6991 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 88)
(2.8004 page 2)
ok / RETURN SEGMENT 1 (2 parts, len: 88)
close_fc, sqlstate: '00000'
parsid PART (1 argument, size: 36328)
close_found, mess_type: close
buf(12):
000009DC 00002101 06002800
shortinfo PART (0 arguments, len: 0, size: 36296)
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 96)
(3.46 page 3)
execute SEGMENT 1 (2 parts, len: 96)
internal, user_cmd
commit_immediately
parsid PART (1 argument, size: 36328)
close_found, mess_type: close
buf(12):
000009DC 00002101 06002800
resultcount PART (1 argument, size: 36296)
result_count: UNDEF
>KB05 id6991 commit
[T18 ===== id6992 new TransNo] 3.278 page 3
KB05 id6992 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 72)
(3.306 page 3)
ok / RETURN SEGMENT 1 (1 part, len: 72)
close_fc, sqlstate: '00000'
parsid_of_select PART (1 argument, size: 36328)
mass_select_found, mess_type: select
buf(12):
000009DC 00002301 3C002C00
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 104)
(3.458 page 3)
dbs SEGMENT 1 (2 parts, len: 104)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 36328)
buf(12): 'DROP PARSEID'
parsid PART (1 argument, size: 36296)
close_found, mess_type: close
buf(12):
000009DC 00002101 06002800
>b07cnext key(4): FF000021
b07cnext root 104319; *** no_next_record ***
>KB05 id6992 commit
[T18 ===== id6993 new TransNo] 3.818 page 3
KB05 id6993 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 40)
(3.846 page 3)
ok / RETURN SEGMENT 1 (0 parts, len: 40)
drop_parseid_fc, sqlstate: '00000'
REQUEST: ascii, full_swap, 70500-ODB (1 segment, len: 104)
(3.942 page 3)
dbs SEGMENT 1 (2 parts, len: 104)
internal, user_cmd
commit_immediately
command PART (1 argument, size: 36328)
buf(12): 'DROP PARSEID'
parsid PART (1 argument, size: 36296)
mass_select_found, mess_type: select
buf(12):
000009DC 00002301 3C002C00
>b07cnext key(4): FF000023
b07cnext root 104319; *** no_next_record ***
>b07cnext key(138):
00000000 00000000 00B50000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
b07cnext root 104319; *** no_next_record ***
>KB05 id6993 commit
[T18 ===== id6994 new TransNo] 3.1422 page 3
KB05 id6994 e_ok
RECEIVE: ascii, full_swap, 70500-ODB (1 segment, len: 40)
(3.1450 page 3)
ok / RETURN SEGMENT 1 (0 parts, len: 40)
drop_parseid_fc, sqlstate: '00000'
===== timeout.id0 =======================================3.1546 page 3
>KB51 inspect locklist
KB51 inspect locklist e_ok
>KB51 inspect locklist
KB51 inspect locklist e_ok
===== T16 ===== nil.id0 =================================3.1658 page 3
REQUEST: ascii, full_swap, 70500-DBM (1 segment, len: 152)
(3.1658 page 3)
dbs SEGMENT 1 (2 parts, len: 152)
session_sqlmode, internal_cmd
command PART (1 argument, size: 36328)
buf(31): 'CONNECT "DBM" IDENTIFIED by :PW'
data PART (1 argument, size: 36280)
buf(44):
00C791FA C53AF78E 420D499F 9BD8FE2D 4DC692E3 40369BDC 30004C4F
43414C48 4F535420 39463820 20202020
'.....:[EMAIL PROTECTED] 9F8 '
[T16 ===== id6995 new TransNo] 3.1914 page 3
>b01t_create tfnTemp; fileTfnNo = 0; ttfnPars
session: nil; fid = 0
fn: 1A00 0000FFFFFFFF0600 000000000000
b01t_create root 105; e_ok
>b01t_create tfnTemp; fileTfnNo = 0; ttfnInto
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0800 000001000000
b01t_create root 14994; e_ok
>KB05 id6995 select_row direct TABID 0-7F key(9): 00C31000 0020454E 47
'..... ENG'
>b02direct_ql key(9): 00C31000 0020454E 47 '..... ENG'
b02direct_ql root 14892; e_ok
KB05 id6995 return_result
>KB05 id6995 connect
KB05 id6995 e_ok
RECEIVE: ascii, full_swap, 70500-DBM (1 segment, len: 3344)
(3.2323 page 3)
ok / RETURN SEGMENT 1 (3 parts, len: 3344)
connect_fc, sqlstate: '00000'
user_info_returned PART (1 argument, size: 36328)
buf(18):
03444241 03444241 08535441 4E444152 4400 '.DBA.DBA.STANDARD.'
conv_tables_return PART (4 arguments, size: 36288)
buf(1024):
00010203 04050607 08090A0B 0C0D0E0F 10111213 14151617 18191A1B
1C1D1E1F 20212223 24252627 28292A2B 2C2D2E2F 30313233 34353637
38393A3B 3C3D3E3F 40616263 64656667 68696A6B 6C6D6E6F 70717273
74757677 78797A5B 5C5D5E5F 60616263 64656667 68696A6B 6C6D6E6F
70717273
'................................ !"#$%&'()*+,-./0123456789:;<'
'=>[EMAIL PROTECTED]'
sessioninfo_return PART (1 argument, size: 35248)
buf(2208):
00000009 DF094444 2D4D4F4E 2D595920 20202020 20202020 20202020
20202020 20202020 20202020 20202020 20202020 20202020 20202020
20202020 20202020 20202020 20202020 20202020 20202020 20202020
20202020 20202020 20202020 20202020 20202020 20200C10 0E05042D
1505042D
'......DD-MON-YY '
' .....-...-'
REQUEST: ascii, full_swap, 70500-DBM (1 segment, len: 80)
(3.2795 page 3)
dbs SEGMENT 1 (1 part, len: 80)
session_sqlmode, user_cmd
with_info
command PART (1 argument, size: 36328)
buf(21): 'DIAGNOSE VTRACE FLUSH'
RECEIVE: ascii, full_swap, 70500-DBM (1 segment, len: 40)
(3.2955 page 3)
ok / RETURN SEGMENT 1 (0 parts, len: 40)
diagnose_fc, sqlstate: '00000'
REQUEST: ascii, full_swap, 70500-DBM (1 segment, len: 80)
(3.3051 page 3)
dbs SEGMENT 1 (1 part, len: 80)
session_sqlmode, user_cmd
command PART (1 argument, size: 36328)
buf(19): 'COMMIT WORK RELEASE'
>KB05 id6995 commit destroy_temp
>b01p_destroy tfnTemp; fileTfnNo = 0; ttfnPars
session: nil; fid = 0
fn: 1A00 0000FFFFFFFF0600 000000000000
b01p_destroy root 105; e_ok
>b01p_destroy tfnTemp; fileTfnNo = 0; ttfnInto
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0800 000001000000
b01p_destroy root 14994; e_ok
[T16 ===== id6996 new TransNo] 3.3391 page 3
KB05 id6996 e_ok
>KB05 id6996 release
KB05 id6996 e_ok
RECEIVE: ascii, full_swap, 70500-DBM (1 segment, len: 40)
(3.3479 page 3)
ok / RETURN SEGMENT 1 (0 parts, len: 40)
commit_release, sqlstate: '00000'
===== timeout.id0 =======================================3.3575 page 3
>KB51 inspect locklist
KB51 inspect locklist e_ok
>KB51 inspect locklist
KB51 inspect locklist e_ok
>KB51 inspect locklist
KB51 inspect locklist e_ok
>KB51 inspect locklist
KB51 inspect locklist e_ok
>KB51 inspect locklist
KB51 inspect locklist e_ok
>KB51 inspect locklist
KB51 inspect locklist e_ok
>KB51 inspect locklist
KB51 inspect locklist e_ok
===== T17 ===== id6803 ==================================3.3967 page 3
(3.3967 page 3)
*** REQUEST ERROR: 3
>KB05 id6803 rollback destroy_temp
>b01p_destroy tfnTemp; fileTfnNo = 0; ttfnPars
session: nil; fid = 0
fn: 1A00 0000FFFFFFFF0600 000000000000
b01p_destroy root 89418; e_ok
>b01p_destroy tfnTemp; fileTfnNo = 0; ttfnInto
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0800 000001000000
b01p_destroy root 104306; e_ok
>b01p_destroy tfnTemp; fileTfnNo = 0; ttfnJoinResul
session: nil; fid = 1
fn: 1A00 0000FFFFFFFF0B00 000001000000
b01p_destroy root 29879; e_ok
[T17 ===== id6997 new TransNo] 3.4246 page 3
KB05 id6997 e_ok
>KB05 id6997 release ignore
KB05 id6997 e_ok
RECEIVE: mess_code 40 , mess_swap=00,
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
