Re: AW: missing delimiter error with REPMCLI

El Friday 29 October 2004 06:26, Zabach, Elke escribió:
Thanks Elke,
your solution was fine, but about the function IFNULL it  does exist, because 
if you execute a simple select in SQL Studio like this:

        SELECT IFNULL(null,'hello World') FROM DUAL

the result is:

'hello World'
i've done many satisfactory tests with this function but when using with 
loadercli or repmcli i got problems.

And  there are a lot of things(function, command,......) that actually doesn't 
appear in manual.    

> 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_I
> >D
> > ","C_BPARTNER_ID","C_BP_GROUP_ID","M_PRODUCT_ID","M_PRODUCT_CATEGORY_ID",
> >"
> > DATEINVOICED","DATEACCT","QTYINVOICED","PRICELIST","PRICEACTUAL","PRICELI
> >M
> > IT","DISCOUNT","MARGIN","LINENETAMT","LINELISTAMT","LINELIMITAMT","LINEDI
> >S 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