AW: missing delimiter error with REPMCLI

Jesus Barreto wrote:
> 
> Hi,
> I have a problem with REPMCLI y execute something(Create a View, Create a
> Function, Create a StroredProcedure) that it content the function IFNULL
> for
> ej:
> CREATE VIEW
> "RV_C_INVOICELINE"
> ("AD_CLIENT_ID","AD_ORG_ID","C_INVOICELINE_ID","C_INVOICE_ID","SALESREP_ID
> ","C_BPARTNER_ID","C_BP_GROUP_ID","M_PRODUCT_ID","M_PRODUCT_CATEGORY_ID","
> DATEINVOICED","DATEACCT","QTYINVOICED","PRICELIST","PRICEACTUAL","PRICELIM
> IT","DISCOUNT","MARGIN","LINENETAMT","LINELISTAMT","LINELIMITAMT","LINEDIS
> COUNTAMT","LINEOVERLIMITAMT")
> AS
> SELECT
>       il.AD_Client_ID, il.AD_Org_ID,
>       il.C_InvoiceLine_ID, i.C_Invoice_ID, i.SalesRep_ID,
>       i.C_BPartner_ID, i.C_BP_Group_ID,
>       il.M_Product_ID, p.M_Product_Category_ID,
>       i.DateInvoiced, i.DateAcct,--   Qty
>       il.QtyInvoiced*i.Multiplier AS QtyInvoiced,--   Item Amounts
>       il.PriceList, il.PriceActual, il.PriceLimit,
>       DECODE(PriceList, 0, 0,
>         ROUND((PriceList-PriceActual)/PriceList*100,2)) AS Discount,
>       DECODE(PriceLimit, 0, 0,
>         ROUND((PriceActual-PriceLimit)/PriceLimit*100,2)) AS Margin,--
>       Line Amounts
>       ROUND(i.Multiplier*LineNetAmt, 2) AS LineNetAmt,
>       ROUND(i.Multiplier*PriceList*QtyInvoiced, 2) AS LineListAmt,
>       DECODE(IFNULL(il.PriceLimit, 0), 0,
> ROUND(i.Multiplier*LineNetAmt,2),
> * * *PROBLEM----^
>               ROUND(i.Multiplier*PriceLimit*QtyInvoiced,2)) AS LineLimitAmt,
>       ROUND(i.Multiplier*PriceList*QtyInvoiced-LineNetAmt,2) AS
> LineDiscountAmt,
>       DECODE(IFNULL(il.PriceLimit,0), 0, 0,
>               ROUND(i.Multiplier*LineNetAmt-PriceLimit*QtyInvoiced,2)) AS
> LineOverLimitAmt
> FROM  RV_C_Invoice i, C_InvoiceLine il, M_Product p
> WHERE i.C_Invoice_ID=il.C_Invoice_ID
>   AND il.M_Product_ID=p.M_Product_ID
> 
> 
> And I get the next Error:
> Missing Delimiter
> 
> I detect that is this function, because if I omit the function IFNULL, it
> works fine
> 

If you will check the reference manual, chapter functions, you will NOT find 
the function IFNULL. Therefore I am not astonished that using such an unknown 
something will cause an error.
Please use function VALUE instead and you will succeed.

Elke
SAP Labs Berlin

> Thanks,
> Jesus Barreto
> 
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:    http://lists.mysql.com/maxdb?unsub=elke.zabach@xxxxxxx

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx