[Help] SP SYSTEM statement
Posted in 1996
Help me, please.
I can't use SYSTEM statement into Stored Procedure,
I can't open debug file into SP -
if I'm not "user informix" both (OK for login informix).
julian has DBA priveleges.
$ id
uid=202(julian) gid=200(informix)
$ dbaccess
create procedure tst()
system 'id';
end procedure;
execute procedure tst();
668: System command cannot be executed.
132: ISAM error: rowsize too big
create procedure tst1()
SET DEBUG FILE TO 'gtrace.lst'; TRACE ON;
end procedure;
execute procedure tst1();648: Cannot open DEBUG file for stored procedure trace.
132: ISAM error: rowsize too big
$ l query.tstquery.tst not found
$ dbaccess
OUTPUT TO query.tst
SELECT * FROM table_name;
73 row(s) retrieved. !
$ l query.tst
-rw-r--r-- 1 julian informix 5645 May 02 11:40 query.tst
onaudit file contains for execute procedure tst() by
informix & julian:
ONLN|1996-05-02 15:51:03.000|bcb|545|bkb|informix|0:SCSP:id
ONLN|1996-05-02 15:53:39.000|bcb|564|bkb|julian|132:SCSP:id
What means the unix error code 132 ?
I think I have all permissions,
why I can't execute SYSTEM statement?
Our platforms: SCO OSE 3.0, OnLine Dynamic Server 6.00.UE2
Thanks,
Julian.
---------------------------------------------------
Julian S. Zalutsky - MIS
Joint-Stock Commercial Bank "Brestcombank"
Republic of Belarus
------ E-mail: julian@martcom.belpak.brest.by -----