I T E C    N E W S L E T T E R                     Vol 3  No 14                                             December 21, 1995                    HAVE A MERRY CHRISTMAS, A HAPPY HANUKKAH,                           AND A HAPPY NEW YEAR                                      - FROM THE ITEC STAFF       We will be operational over the holidays but will only be operating       with a skeleton staff.  All accounts will be monitored.  Ron Brown's       cell phone, if you can't get a hold of anyone else, is 716/471-1608.  1.0  SUNYCard information to join ITEC's web page  2.0  Down time on 6610 (snybscva.cs.snybuf.edu) machine  3.0  ITEC's new Class C internet address:  what to do  4.0  ORACLE 7.1.5.2.3 and CDE 4.0.13.17.2 for ALPHA AXP now available  5.0  New Oracle Products arriving soon             6.0  1994 IOUW Proceedings now available     7.0  SQR NEWS!!  Some great suggestions from other campuses         1.0  SUNYCard information to join ITEC's web page       Keep checking our web page (http://www.itec.suny.edu), because       SUNYCard information will shortly be joining it.  A formal       announcement will be sent when it actually does, however.  Pat Arms,       Chuck Goolden's SUNYCard Assistant, is currently working on the html       pages.       With the added reason to check out our ITEC page, it is hoped that       more and more SUNY personnel will become familiar with ITEC.  2.0  Down time on 6610 (snybscva.cs.snybuf.edu) machine       Snybscva.cs.snybuf.edu machine will be down on December 28th from 7       a.m. to 10 a.m.  3.0  ITEC's new Class C internet address:  what to do       ITEC's new Internet name will be va.itec.suny.edu which replaces       snybscva.cs.snybuf.edu.  This change will take place at 8 a.m. on       January 4, 1996.       An alias name should be in existance for about a month after this       change takes place.  So those of you who use snybscva.cs.snybuf.edu       as your main machine to get email, etc. don't worry too much as       there will be a grace period to get things changed on your end.       In that regard, just before the name change happens, for those that       use our machine for Internet access, please unsubscribe yourself       from lists before January 4th, if that is possible, and resubscribe       after the 4th.  To globally unsubscribe from lists, send the       following command:       At the $:  $ send listserv@ubvm signoff * (Netwide       or as the body of text inside an email message:  signoff * (Netwide       If you miss this entirely and do not unsubscribe, write the listserv       node and request a review of those subscribed.  If you don't get the       entire list, you should get at least an announcement of who is the       list owner.  Send an email message to the owner, telling them that       your machine's name changed and ask to be deleted whereupon you       can resubscribed.  To get this listing:              $ send listserv@nodeaddress review nameoflist       For itec-l whose home is ubvm, you would send            $ send listserv@ubvm review itec-l       If you have any problems during this transition, please write to       SCACAD for help.  4.0  ORACLE 7.1.5.2.3 and CDE 4.0.13.17.2 for ALPHA AXP now available       Oracle 7.1.5.2.3 for Alpha AXP OpenVMS is now available through       GETSOFTWARE.  The corresponding version of the CDE tools is       4.0.13.17.2 which can also be found in GETSOFTWARE under "THIRD       PARTY" as seen below:  23  ORA71523AXP   7.1.5.2 669249  12/95     AXP Oracle 7.1.5.2.3  24  ORAAXPCDE4013172      307440  12/95     CDE Tools for DEC AXP OpenVMS       The readme file was sent out to SUNYDBA's about a month ago with the       readme file for this version of Oracle.  If you need it, please send       e-mail to the SCADM account.         NOTE:  In the above mentioned e-mail, there was discussion on how to       install this code (AXP version!) on OpenVMS 6.2 (in order to       eliminate some unresolved externals).  It was incorrectly stated       that an object file SL.OBJ should be replaced, this is not the case       for version 7.1.5.2.3, only for 7.1.3.2 of Oracle for Alpha AXP       OpenVMS.  Please see the two listed in GETSOFTWARE for installing       7.1.2.3 or 7.1.5.2.3 of Oracle on a Alpha AXP OpenVMS 6.2 platform.  29  ORA7132ONAXP62 7.1.3.2   126  12/95 PATCH to link Oracl 7132 on Alpha 6.2  30  ORA7152ONAXP62 7.1.5.2   126  12/95 PATCH to link Oracl 7152 on Alpha 6.2  5.0  New Oracle Products arriving soon        =================================================================       New Oracle Products for VMS       =================================================================       The Developer 2000 tools for Alpha AXP OpenVMS are scheduled to be       released in the first quarter of 1996.  They have already begun       shipping for the UNIX platforms.       Oracle 7.1.5.2.3 for VAX VMS should be arriving shortly, the product       has been shipped by Oracle and we are currently waiting for the       delivery!       We will also be getting a more recent version of the CDE tools for       both 7.1.3.2 and 7.1.5.23 on the VAX platform.       =================================================================       New Oracle Products for Windows        =================================================================       We will be getting a new version of the Designer 2000 product       (version 1.2) as soon as it begins shipping.       We have a new version of the Developer 2000 (V1.1) tools for       Windows, but it is recommended that it be used against a version of       Oracle 7.1.4 or later.  For this reason, we are waiting for the       7.1.5.2.3 VAX version of Oracle to be put on GETSOFTWARE before       making it available.    6.0  1994 IOUW Proceedings now available        The 1994 IOUW Proceedings are now available through GETSOFTWARE       under the "THIRD PARTY" category and is listed as follows:       14  IOUW94           ---   39879  12/95    IOUW 1994 Proceedings  7.0  SQR NEWS!!  Some great suggestions from other campuses       A new version will be arriving soon.  It will be version 3.0.12, the       next release after that will be in March of 1996.  The AXP version       will arrive first, with the VAX version arriving shortly thereafter       (about 2-3 weeks I was told).       +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++       Join a SQR listserver:       email to : listproc@usa.net       with a message body of :       subscribe sqr-users        ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++       THANK YOU ANDY HARRADINE FROM POTSDAM!  Andy reported a Postscript       bug in version 3.0.7 of SQR and worked with SQR on duplicating it       for them.  Below is Andy's e-mail discussing the problem and a work       around.       Also below is e-mail from Bob Hayden (Canton) (THANK YOU BOB!)       about ESQR2SQR dumping.  The command Bob used is below, followed by       MITI's response.     =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-To:	SBSCVA::SCADMCC:	Subj:	Postscript Bug with SQR3 on AXP for VMS Michael,I'm not sure if MITI carboned you on this message so I am forwarding theirresponce on.Thank you..AndyFrom:	IN%"johnk@sun4.miti.com" 27-NOV-1995 13:47:51.22To:	IN%"LORI@potsdam.edu"  "Lori Blaha - Central Computing, Potsdam College"Subj:	RE: ATTN:  John Kellog     Hi Lori,          I received a reply back from our programmers about the Postscript      problem on OpenVMS. They added a ^D to the end of the .lis file in      version 3 to signify end-of-file to the printer. Without this, some      printers will time-out waiting for more data. The ^D is supposed to be      the last character in the file. This appears to be true on the Unix      hosts I tested on, but not the VMS hosts. The extra linefeed on VMS is      a bug. I submitted bug # 914 for this problem.           The only suggestion I have to work around this problem is to close the      .lis file and read it back in, and then write it to another file minus      the last line. For example:              begin-report          print ...          do eliminate_last_line         end-report              begin-procedure eliminate_last_line         move 0 to #lineno         move $sqr-report to $old_report         new-report 'junk.lis'         open $old_report as 1 for-reading record=80         open 'temp.lis' as 2 for-writing record=80         while 1          read 1 into $string:80          if #end-file           break          end-if          if #lineno = 0           move 1 to #lineno          else           write 2 from $previous_string          end-if          move $string to $previous_string         end-while         let $cmd = 'rename temp.lis ' || $old_report         call system using $cmd #status         end-procedure          Regards,          John L. Kellogg    =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-       From Bob Hayden (Canton) about ESQR2SQR dumping.  The command Bob       used is below, followed by MITI's response:     =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-    $ ESQR2SQR TAB BOBLIST    %SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual    address=00000000,    PC=00028A8C, PSL=0BC00000    %TRACE-F-TRACEBACK, symbolic stack dump follows    module name     routine name                     line       rel PC    ////////////////////////////////////////////////////////////////////     From:	SBSCVA::SCADM        "CSSC ORACLE Support Group" 12-DEC-1995 11:35:13.69To:	SBSCVA::SCADMCC:	@MRRR,SCADMSubj:	RE: SQR WORKBENCHHi Bob!I duplicated the problem here with our executable, I then called MITI.  Theytoo were able to duplicate the problem and have opened a bug with regards toit.The tech person suggested (as a temporary work around) using ESQR and afterspecifying the format, query and layout that you can go under report and selectbuild sqr.I know that isn't what you want to hear, but at least there is a temporarywork around.They will ship us a patch / new version when this bug has been resolved.THANK YOU!Mike :-)    =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-                                                Editor:  Betty Spencer                                                                                            Oracle news provided by                                                Mike Notarius           ITEC's General Office            716/878-4611                  Director's Office         716/878-4206                  Operations                716/878-5122                  After hours               716/878-6642                  FAX                       716/878-4235                  web page             http://www.itec.suny.edu

ITEC Home Page