Moro wrote : >hi
>i�ve got two general questions. would be nice if some could give me some >hints. >(1) when do i have to use colons with varia�bles in dbprocs? >create dbproc test (in myval char(30), out dummy_id integer) as >var > myid integer; >begin > set myid = me.dumy_seq.nextval; -- without colons > set dumy_id = myid; > insert into me.dumy values (:myval, :myid); -- colons needed >end; You have to use colons if you pass variables as parameters to a sql statement contained in your db-procedure. me.dummy_seq.nextval is an expression (no sql statement) ==> no colons needed. insert into me.dumy values (:myval, :myid) is a sql statement ==> colons needed. >(2) is there a tabular summary of built-in functions (ansi functions >seems to work) an predefined variables like %rowtyp in oracle available? For built-in functions please have a look into www.sapdb.org/htmhelp/48/0d801eb4f211d2a97100a0c9449261/content.htm For predefined variables see www.sapdb.org/htmhelp/a7/41ee29605911d3a98800a0c9449261/content.htm Regards, Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
