SQL Error on AS400

• SAROSH SHETTY

  SSC Journeyman

  Points: 87

  More actions

  March 6, 2006 at 9:16 am

  #170824

  I am trying to run this query on AS400 and it gives an error message as

  Token MAX was not valid. Valid tokens: FOR WITH FETCH ORDER UNION OP..

  The Query is

  SELECT DM1196PF.DRG_CODE, DM1196PF.DRG_DESC

  FROM

  DM1196PF

  WHERE

  RTRIM(DM1196PF.GRPR_NAME) = 'CMS' AND DM1196PF.GRPR_VRSN = SELECT MAX(GRPR_VRSN) AS GRPRVRSN FROM DM1196PF WHERE RTRIM(DM1196PF.GRPR_NAME) = 'CMS' GROUP BY GRPR_NAME, DRG_CODE

   

  Is there any other way to use MAX function for AS400??

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  March 6, 2006 at 10:48 am

  #624971

  Please post in an appropriate forum...the "Question of the Day" forum is specifically for responding to the Question of the Day quiz.

  -SQLBill