hi thomas,
sorry to bother you again but i am still having 2 more problems. it would be grateful if you help me out.
1. The query below is selecting the max value from the table. The table can be blank so it will return me a null value which i need to set to 0. How do i do it?
Here's a sample query i am using in Oracle :
Here's a sample query i am using in Oracle :
select (nvl(max(To_Number(vdocno)),0)) into ls_docno from ABC;
What is the keyword for nvl in sapdb.
2. I need to create a dynamic query which has to be executed in a procedure.How do i do it?
Here's a sample i have created in sapdb :
Here's a sample i have created in sapdb :
set ls_sql = 'Insert into ' ||ls_tablename|| '(CTAGID,CREDIT) VALUES(' || '''' || ls_tagid || '''' || ',' || '' || li_credit || '' || ')';
EXEC SQL EXECUTE IMMEDIATE :ls_sql;
EXEC SQL EXECUTE IMMEDIATE :ls_sql;
The error i am getting is
Syntax error or access violation;-5015 POS(1530) Missing keyword:WHILE,SELECT,IF,EXECUTE,CALL,SET,RETURN,FETCH,DECLARE.
Regards,
Prakash.
The hottest things. The coolest deals. Get them online! _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
