Robelle | Products | Library | Support | Partners | Contact Us

Suprtool 3.9 Extract with $date(..last)

There is a problem with suprtool version 3.9, which affects tasks which use the $date(..last) option on the EXTRACT command. e.g. :

     >get      d-sales
     >item     deliv-date,date,yyyymmdd
     >extract  deliv-date = $date(*/*/last)
     Error:  Invalid date
     Error:  Year = 1996 Month = 8
     Error:  Missing comma
Here are the patch instructions for the NM version of Suprtool 3.9. Make sure that sompatch displays what is listed below, otherwise do not make the changes.
   :hello mgr.robelle
   :run sompatch.pub.sys
   sp> open suprtool.pub                    !or suprnm.pub
   sp> mod suprdate2$2$from_convert+cc      !You type this
   suprdate2$2$from_convert + cc  e85f06d7  !this displays
   08000240                                 !You type this
   e85f06d7&|8000240                        !this displays
   sp> exit
   Total number of patches being applied 1
   END OF PROGRAM

Here are the patch instructions for the CM version of Suprtool 3.9. Make sure that patch displays what is listed below, otherwise do not make the changes.

   :hello mgr.robelle
   :run patch.pub.sys

   PROGRAM PATCH B.79.06 (C) HEWLETT-PACKARD CO., 1976
     FILE=?suprtool.pub                        !or suprcm.pub
   ?m,31,00707                                 !You type all this
     021005,0                                  !You type the zero
   ?m,31,00710                                 ! etc..
     170003,0
   ?m,31,00711
     142001,0
   ?m,31,00712
     177102,0
   ?

   END OF PROGRAM
We apologize for any inconvenience this may cause you. If you have any questions, please give us a call at 1-888-ROBELLE.

....Back to the Patches Page