Interesting: A ONE row SELECT will return SQLCODE = 100
SELECT PaymentNo INTO vPaymentNo IND iv1 FROM PAYMENTS WHERE OrderNo > = 9596096 and a GROUP by SELECT will return SQLCODE = 100 SELECT OrderNo,Max(PaymentNo) INTO vOrderNo IND iv1 ,vMaxPaymentNo IND iv2 FROM PAYMENTS WHERE OrderNo > = 9596096 GROUP BY OrderNo But an AGGREGATE SELECT will always just return 0! SO you'll have to test with SELECT COUNT(*) first! David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Bernard Lis" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Tuesday, July 05, 2005 2:47 PM Subject: [RBG7-L] - Select Max question > set var MaxPaymentNo int=null > SELECT MAX(PaymentNo) INTO MaxPaymentNo IND iv1 FROM PAYMENTS WHERE OrderNo > = 9596096 > > sqlcode returns 0 even though the record does not exist. > MaxPaymentNo becomes 0 and the indicator iv1 is also 0 > > Is this the way it's supposed to be? > > Bernie Lis > > >
