zOs/SQL/SOERENS

    SELECT
            NI750POS_TYP
          , NI750ASSET_CLASS
          , NI750ABS_VAL_VC
     FROM OA1A.TNI750A1 --
     WHERE NI750REP_COMP_ID=3100
       AND NI750PART_ID=8
       AND NI750REP_ORDER_ID = 'TEST0000000000000001'
  --   AND NI750REP_ORDER_ID >= 'TEST0000000000000001'
     ORDER BY--NI750POS_TYP
               CAST(NI750POS_TYP AS DECIMAL (31, 8))
             , ABS(NI750ABS_VAL_VC) DESC
             ,NI750ASSET_CLASS
     FOR FETCH ONLY