Re: Need help on two Pro*C queries

Hi,

I wrote :
>
>1. The following query returns a sqlca.sqlcode value
> of -1722. I think this means "invalid number" with
> the equal sign not producing a number. Is it
> possible to do comparisons similar to what is shown?
>
> EXEC SQL SELECT BENEFIT_AMOUNT
> INTO :d2
> FROM PRI_BEN
> WHERE EE_ID = :lEmpId AND
> BENEFIT_TYPE = 'I' AND
> TO_CHAR(BENEFIT_DATE,'MM/DD/YYYY')=TO_CHAR('12/31/1986','MM/DD/YYYY');
>

  The problem here was that

     TO_CHAR(BENEFIT_DATE,'MM/DD/YYYY')=TO_CHAR('12/31/1986','MM/DD/YYYY');   should have been :

     BENEFIT_DATE=TO_DATE('12/31/1986','MM/DD/YYYY');   I'm still stumped on the other query which I did not post   correctly. It should have read :

 2. The following query returns a sqlca.sqlcode value

    of -937. I think this means "not a single-group function" with     the TYPE field being single valued and EFFECTIVE_DATE being     derived from many values so that a GROUP BY clause is needed.     But how?  

    EXEC SQL SELECT TYPE,TO_CHAR(MIN(EFFECTIVE_DATE),'MM/DD/YYYY')

             INTO :vszTYPE,:vszEFFECTIVE_DATE
             FROM CMP
             WHERE EE_ID = :lEmpId ;
 

 Thanks,  

 Emmett   Received on Thu Mar 06 1997 - 00:00:00 CET