RE: dbmorecmds works

...
> 
> Mmm... sp_help is really old. Should be present even on Sybase... I'll
> test this evening.
> 

Do not work with Sybase 11.9.2 (my Sybase test server)

Shell:
$ ./dbmorecmds 
found local.tempdb for sa in "../../../PWD"
Start
About to logon
after bread crumb
after dblogin
About to open [][sa]
After second bread crumb
After dbopen [local]
About to dbuse [tempdb]
After dbuse [tempdb]
Dropping table
Msg 3701, Level 11, State 1
Server '', Line 1
Cannot drop the table '#dblib0024', because it doesn't exist in the
system catalogs.

creating table
insert
insert into #dblib0024 values (0, 'row 000')
insert into #dblib0024 values (1, 'row 001')
insert into #dblib0024 values (2, 'row 002')
insert into #dblib0024 values (3, 'row 003')
insert into #dblib0024 values (4, 'row 004')
insert into #dblib0024 values (5, 'row 005')
insert into #dblib0024 values (6, 'row 006')
insert into #dblib0024 values (7, 'row 007')
insert into #dblib0024 values (8, 'row 008')
insert into #dblib0024 values (9, 'row 009')
select 1
Segmentation fault (core dumped)

GDB:
Loaded symbols for /usr/lib/gconv/ISO8859-1.so
#0  0x400245f9 in dbmorecmds (dbproc=0x804fca8) at dblib.c:4944
4944            if (dbproc->tds_socket->res_info->more_results == 0) {
(gdb) bt
#0  0x400245f9 in dbmorecmds (dbproc=0x804fca8) at dblib.c:4944
#1  0x08048f8e in main (argc=1, argv=0xbffff8e4) at dbmorecmds.c:158
#2  0x4009d336 in __libc_start_main (main=0x8048c40 <main+64>, argc=1, 
    ubp_av=0xbffff8e4, init=0x804890c <dbdead+12>, 
    fini=0x80494f0 <_IO_stdin_used+12>, rtld_fini=0x4000d2fc <_dl_fini>,
    stack_end=0xbffff8dc) at ../sysdeps/generic/libc-start.c:129
(gdb) print dbproc->tds_socket_res_info
There is no member named tds_socket_res_info.
(gdb) print dbproc->tds_socket->res_info
$1 = (TDSRESULTINFO *) 0x0
(gdb) 

TDS dump (end):
Sending packet @ 07:51:33.975287
0000 0f 01 00 2d 00 00 00 00-21 20 00 00 00 00 65 78 |...-.... ! ....ex|
0010 65 63 75 74 65 20 6d 61-73 74 65 72 2e 2e 73 70 |ecute ma ster..sp|
0020 5f 68 65 6c 70 20 73 70-5f 68 65 6c 70          |_help sp _help|


07:51:33.975368 in dbsqlok() 
Received header @ 07:51:33.979235
0000 04 01 00 cc 00 00 00 00-                        |........|


Received packet @ 07:51:33.979334
0000 ff 41 00 02 00 00 00 00-00 ff 41 00 02 00 00 00 |.A...... ..A.....|
0010 00 00 ff 41 00 02 00 00-00 00 00 ff 51 00 02 00 |...A.... ....Q...|
0020 01 00 00 00 ff 41 00 02-00 00 00 00 00 ff 41 00 |.....A.. ......A.|
0030 02 00 00 00 00 00 ff 41-00 02 00 00 00 00 00 ff |.......A ........|
0040 41 00 02 00 00 00 00 00-ff 41 00 02 00 00 00 00 |A....... .A......|
0050 00 ff 41 00 02 00 00 00-00 00 ff 41 00 02 00 00 |..A..... ...A....|
0060 00 00 00 e5 3e 00 35 44-00 00 01 10 00 00 01 00 |....>.5D ........|
0070 27 00 4f 62 6a 65 63 74-20 64 6f 65 73 20 6e 6f |'.Object  does no|
0080 74 20 65 78 69 73 74 20-69 6e 20 74 68 69 73 20 |t exist  in this |
0090 64 61 74 61 62 61 73 65-2e 00 07 73 70 5f 68 65 |database ...sp_he|
00a0 6c 70 b3 00 ff 43 00 02-00 00 00 00 00 ff 41 00 |lp...C.. ......A.|
00b0 02 00 01 00 00 00 79 01-00 00 00 fe 08 00 02 00 |......y. ........|
00c0 01 00 00 00            -                        |....|


07:51:33.979543 dbsqlok() marker is ff
07:51:33.979564 processing result tokens.  marker is  ff(DONEINPROC)
07:51:33.979586 tds_process_end() more_results = 1, was_cancelled = 0 
07:51:33.979609 dbsqlok() end status was success
07:51:33.979629 dbresults()
07:51:33.979646 dbresults_r()
07:51:33.979665 processing result tokens.  marker is  ff(DONEINPROC)
07:51:33.979686 tds_process_end() more_results = 1, was_cancelled = 0 
07:51:33.979706 dbresults_r() result_type = 4054 retcode = 1
07:51:33.979726 leaving dbresults() returning 1
07:51:33.979745 dbnextrow()
07:51:33.979762 leaving dbnextrow() returning -2


sp_help is in sybsystemprocs on my server.

freddy77