M DECUS U. S. Chapter     SIGs Newsletter,   Volume  5, Number 4  December 1989 >                         Wombat Examiner,   Volume 11, Number 4  @ ----------------------------------------------------------------6           Call for Product Improvement Requests (PIRs)-                     T. Chris Wool, PIR Editor @ ----------------------------------------------------------------  A Again this year, the  DATATRIEVE/4GL  SIG  is operating a Product A Improvement Request System.  This  is your opportunity to pass on A to the DATATRIEVE and 4GL developers your ideas for improving the A various products.  The  range  of  PIRs  is broad - from specific A "nit-picking" about syntax  to  long  range goals and directions. A You can influence the  development  of  the  products only to the A extent that you participate  in  the  PIR process.  A significant > number of today's features in DATATRIEVE were originally PIRs.  A The PIR process starts with the submission of Product Improvement A Requests.  These requests are compiled, and then submitted to the A SIG membership.  The membership  votes on the relative importance A of the PIRs.  The ranked PIRs  are then sent to Digital for their  review, comments, and action.   A In the back  of  this  issue  of  the  SIGs  Newsletter  is a PIR A Submission Form.  If you  wish  to  submit a PIR, please complete A the form and return it to  the  address on the form no later than A January 29, 1990.   This  is  you  last  change  for this year to A submit  a   product   improvement   request  for  VAX-DATATRIEVE, # DATATRIEVE-11, RALLY, and TEAMDATA.     @ ----------------------------------------------------------------+                       From the Editor's Pen @ ----------------------------------------------------------------A This is your  last  change  to  turn  in  your  Special RALLY PIR A ballot.  Your ballot must  be  received by Chris Wool by December A 15, 1989.  You have a little long (until January 29, 1990) to get A in your PIRs for the next  round.  Don't miss this opportunity to ) "communicate" directly to the developers.   A This month a new column has  been starting in the Wombat Examiner A and 4GL Dispatch.  The column  is  "The RALLY Check Point."  This A column, like  the  "Dear  Wombat  Wizard"  column,  is written by A various individuals and is  designed to answer specific questions A or problems and give tips  on  the  use  of RALLY.  The first few A columns over  the  next  few  months  are  contributed by Digital A employees  from  the   Northern  District  Professional  Software A Services and will  be  edited  for  the  Wombat  Examiner and 4GL A Dispatch by Associate Editor  Lorey  B.  Kimmel.   We are looking A forward to the interest in RALLY  and  we will try to rise to the A challenge of dealing with  material  in  the newsletter in a "new 
 language."  A Again so quickly we are approaching the end of another year.  The A staff of the  Wombat  Examiner  and  4GL  Dispatch extends to you ; warmest seasons greetings.  Have a happy and safe new year.   A At the end of a  year  and  the  beginning  of a new one, we take A stock, count  our  blessings,  and  discharge  our  debts.   I am A indebted to the staff of the Wombat Examiner and 4GL Dispatch for A their good work and fine  support  over  the last year.  To Steve A Cordiviola, Pat Scopelliti, Herb  Reines, Richard Copeland, Lorey A Kimmel, and Bart Lederman, thanks!    You  have made my job a lot > easier and a lot more fun than it would have been without you.  :                                   Joe H. Gallagher, Ph. D.(                                   Editor    %                   "About the Authors"   A The material in this  months  RALLY  Check  Point column is taken A from "VAX RALLY  Hints  and  Techniques"  produced and created by A Digital employees in Australia,  New Zealand, Canada, Europe, and A the US; the material was  edited  and compiled by Ian Smith, Marg A Williams,  and  Vince   Moran   of  Digital's  Northern  District A Professional Software Services and edited for the Wombat Examiner 5 and 4GL Dispatch by Associate Editor Lorey B. Kimmel.   6                 <This is the beginning of the article>  A ----------------------------------------------------------------- +                       The RALLY Check Point A -----------------------------------------------------------------    PROBLEM:   Confirm record on DELETE  A When the delete record  action  is  taken  by the user (e.g. when A they press the REMOVE key)  the application needs to confirm that A the user actually wanted  to  perform  that action.  For example, = display a prompt confirming that the record is to be deleted.   	 SOLUTION:   A An ADL procedure needs  to  be  run  at  the BEFORE DELETE action A site.  You should also  create a standard confirm form/report (or A task)  which  can  be   run   from  other  form/reports  in  your  application.  A Do a FORK to execute  the  special  form/report.   It will read a A variable  field  and  store  the   value  in  a  global  variable A (CONFIRM_DELETE_YN).  This form/report field should have a Y or N  validation applied to it.   A After exit from  the  task  execution  will  continue  in the ADL A procedure which can examine the global variable CONFIRM_DELETE_YN A to see if it is set to "Y".    In this case the ADL can exit with A no further action required.   Otherwise the procedure should call * SET_FAILURE() to force the DELETE to fail.  0 (ADL procedure to confirm delete of this record) confirm_delete_yn := 'N';  fork confirm_delete'  if confirm_delete_yn <> 'Y' then!         (abort the DELETE action)          SET_FAILURE();    @ ----------------------------------------------------------------)                        Dear Wombat Wizard @ ---------------------------------------------------------------- Dear Wombat Wizard:   A Does DATATRIEVE think that 25  =  30?    I have been working on a A very complex report on our client  list.  The report is output to A a file and  then  read  into  another  domain  to analyze summary A statistics.  Since  the  output  of  the  Report Writer goes into A another domain, the column  layout  is  very  critical.  I used a @ print statement in the Report Writer which looks something like:  3 print . . . space 0, client_name(-), space 0, . . .   A The field CLIENT_NAME is declared  with  a PIC X(25) clause.  But ' when we changed the print statement to    > print . . . space 0, fn$upcase(client_name)(-), space 0, . . .  A our procedures stopped working with a bang and a crash!  After an A hour of chasing why  the  record  was  now five characters longer A than before, we discovered that the upper case client name was 30 A characters long,  not  25  as  before.    What  gives?   Why does > DATATRIEVE think a length of 30 is the same as a length of 25?  $                              Signed,  :                              Worried that DTR can't count.  
 Dear Worried:   A Whew!  For a second there, I thought you were going to ask why is ; Halloween the same as Christmas.  It that case 31 = 25, or    (                          31 OCT = 25 DEC  A But to answer your question,  the string functions, in particular A FN$STR_EXTRACT and FN$UPCASE,  have  a  default edit-string of 30 A characters.  If you  don't  believe  me, check the VAX DATATRIEVE A Reference Manual under the  function  FN$STR_EXTRACT.   So ... if A you don't specify otherwise,  the "little Wombat function server" A on the  inside  of  DATATRIEVE  will  assume  that  the output of A FN$UPCASE is 30 characters long.   To persuade the "little Wombat A function server" to use some  other  length, try FORMAT ... USING  as in   J print ... space 0, format fn$upcase(client_name) using x(25), space 0, ...  A And yes, DATATRIEVE counts  very  well;  somethings it's just not  clear how it is counting.   $                              Signed,  >                              The Wombat Wizard (HGR, BZL, TCW)    A ----------------------------------------------------------------- /                  RALLY as a DATATRIEVE Function ?  Bart Z. Lederman, System Resources Corp., Burlington, MA 01803 A -----------------------------------------------------------------e  A RALLY is a 4GL product sold by Digital; you've probably seen somebA articles about it here  in  the  Newsletter.  Like DATATRIEVE, it-A has a call interface which allows  it  to be linked in and called A from other programs.  There are actually two ways to call it: one-A requires a number  of  different  entry  points  to be called andAA checked; the  other  is  a  'simplified'  interface which acceptsmA single  RALLY  commands  such  as  "RALLY  RUN  rga_file".   This : interface can be easily accessed as a DATATRIEVE function.  > The definition which has to be added to DTRFND.MAR looks like:  ) ; FN$RALLY - Access to RALLY applicationso ; B. Z. Lederman       ; Input is a RALLY command linet ; No output  ;x; ; This function requires linking to the shared RALLY image.n  5         .LINK   "SYS$SHARE:RALLY$SHARE.EXE"/SHAREABLEl  % $DTR$FUN_DEF FN$RALLY, RALLY$RALLY, 1h)     $DTR$FUN_OUT_ARG  TYPE = FUN$K_STATUSs     $DTR$FUN_NOVALUE     $DTR$FUN_NOOPTIMIZEiH     $DTR$FUN_IN_ARG  TYPE = FUN$K_DESC, DTYPE = DSC$K_DTYPE_T, ORDER = 1 $DTR$FUN_END_DEF  A You then rebuild DATATRIEVE  as documented in the "Customization"m manual.   A How to  use  it?    Well,  basically,  you  input  the same RALLYiA commands to  this  function  as  you  would  enter  in  DCL.  Forc example:  3 DTR> FN$RALLY("RALLY RUN SYS$EXAMPLES:RALLY$TAPES")l  A I have not tried  any  other  commands  like RALLY EDIT, but they  should work.  @ ----------------------------------------------------------------8                       Wombat Magic, Spring 1989 - Part 45 Session Co-Chairs: Dana Schwartz, DOD, Washington, DC D                    Bert Roseberry, U. S. Coast Guard, Washington, DCJ Session Editor: Joe H. Gallagher, Ph. D., 4GL Solutions, Overland Park, KS@ ----------------------------------------------------------------A Editors' note:  The  following  is  Part  4  of  a  highly editedJA transcription of the  Wombat  Magic  Session  at  the 1989 SpringmA DECUS Symposium in Atlanta,  Georgia,  which  occurred on May 11, A 1989.  Part 3 appeared in the November 1989 newsletter.  MaterialeA which was presented on  transparencies  has  been merged into theiA oral presentation.  An attempt  has  been made to convey both thebA technical content of  the  Magic  Session  as  well as the humor,nA covert intellectual swaggering,  and  the spirited interchange ofeA the presentations.   Material  which  appears  in the text withinaA square brackets [] has been added  by the editor in an attempt torA improve  the  understandability  of   this  very  exciting  MagicGA Session.  The material  presented  here  is  not presented in then) same order as it occurred in the session.w    % John Putnam, Harris Bank, Chicago, ILa  A This is "proposed" magic; I'm  actually stumping for votes on theiA next PIR, as in  wouldn't  it  be  nice  to  use the grouping andfA re-definition features  of  a  record  definition  on  a declaredm	 variable?   A Now [currently], one has  to  use  the string extract function to A pull things apart.   But  if  one  could make a record definitione like:    DEFINE RECORD CDATE_REC USINGa
 01 CDATE_REC.     03 CDATE PIC X(6). &    03 CDATE_BREAKDOWN REDEFINES CDATE.       05 YY PIC XX.p       05 MM PIC XX.e       05 DD PIC XX.v ;a   and just say   DECLARE XDATE USING CDATE_REC. XDATE.CDATE = "890511"( PRINT XDATE.MM|"/"|XDATE.DD|"/"|XDATE.YY  
 would give  
   05/11/89  A But even better use would be the  case where you have a file that A has a concatenated RMS  key  of  an  account number followed by a  date in the form      NNNNQQQQQQQQo  A where NNNN is a four byte  account  number and QQQQQQQQ is a quad 7 word date.  Then the record definition would look like:"   01 CEKY_REC.
    05 KEY.       07 ACCT PIC 9(4).r       07 DATE USAGE IS DATE.#    05 CKEY REDEFINES KEY PIC X(12).     . . .   Then one could use   READY ACCT_DOM READY TRANS  DECLARE X USING CKEY_REC.r X.DATE = "TODAY" FOR A IN ACCT_DOM BEGINv     X.ACCT = A.ACCTh      FOR TRANS WITH TKEY = X.CKEY
         . . .      ENDr  A and save the use of an  external  file!  If DATATRIEVE had such al capability, then maybe  A      This sort of temporary could  be viewed as a virtual domain <       that is open [always ready] and has a selected record.>      The variable name could be viewed as a contest variable.A      This may be a cheap extension  to the language with lots of.       BANG for the bucks.M  A There may be some other  interesting  things.   One of the thingsaA that I do currently  with  FMS  and  DATATRIEVE is define a wholenA bunch  of  DECLARED  variables  and  use  the  DISPLAY_FORM.   Anp equivalent syntax might be  ! DECLARE X USING X_REC FORM IS FM.  MODIFY X  A This could be  a  way  of  propagating  a  record environment and A storing it in the  CDD  and  making  it  available to a number ofoA different  routines.     And   because   of  DATATRIEVE  and  itsaA interpretive nature, that would propagate automatically.  So thatC- would save a lot of code maintenance as well.l  A The  last  thing  is  because   of  the  structure  of  a  record A definition, it  would  be  possible  to  pass  a  large  block ofxA information to a user  defined  function.    If  X were a virtualo# record definition, then a call liket   FN$MYROOT(X)  A would be  very  powerful  especially  if  MYROOT  were  a call toR DECWindows!t    : Lieutenant Richard Young, U. S. Air Force, Panama City, FL  A I've been trying to create  DATATRIEVE procedures so that someonedA less experienced than myself  can  use  them.   In creating theseEA procedures we use a lot of the usual *."prompt text" prompts.  In-A my situation we have a database of missile types -- and there are-A a lot of missile types out there.   And I want to be able to do aaA multi-prompt [that is, enter  a  variable  number  of values of awA field to use in a record  select  expression].   So I went to theiA DTR/4GL SIG campground and  asked  Joe  Gallagher how to do this.lA And here is how to search  for  a  variable number of values of ae field.  A Suppose we have a domain  we  have  to  search which has a field, ( MISSILE-TYPE which is PIC X(6).  Then we     DECLARE BUFFER PIC X(70).r! DECLARE COUNTER USAGE IS INTEGER.s DECLARE TEMP PIC X(6). BUFFER = ""M3 COUNTER = *."number of missile types to search for"w REPEAT COUNTER BEGIN     TEMP = *."missile type"p     BUFFER = BUFFER||TEMP|"?")     END, READY MISSILE-DATABASE3 FOR MISSILE-DATABASE WITH BUFFER CONT MISSILE-TYPE  	     . . .s  A The size of global variable  BUFFER  is  the size of the field towA search (in this case the field MISSILE-TYPE is 6 characters) plusnA 1, times the number  of  different  value  to search for (in thisiA case 10).  We specify the number of values we need to enter; then A we enter the  values.    The  values  are  placed  in the buffer,TA BUFFER,  with  each  value  separated  by  character  which neveroA appears within the field  MISSILE-TYPE.   The character "?" never.; appears in field MISSILE-TYPE so we can use that character.C  A The magic is that we reverse the order of the Boolean expression.p( Normally the Boolean expression would be  5            WITH MISSILE-TYPE boolean-operator "value"   
 but we use  /                   WITH BUFFER CONT MISSILE-TYPEu  A The reason that we need a character like "?" in the buffer is thetA the values  in  the  buffer  have  got  to  have  a registration. A Suppose we had  missile  types  "123456", "456789", and "789012".rA If we wanted to search  for  missile types "123456" and "789012", A and put these two values in the buffer without being separated by A a "?", then  the  buffer  would  contain  "123456789012".   If we A searched the buffer  to  see  if  the  missile type "456789" were A there, we would improperly  find  that  it  was.   However, if we A separate the values in the  buffer  by "?", then the buffer would  contain        BUFFER = "123456?789012?"-  " and it would not contain "456789".    4 Bert A. Roseberry, U. S. Coast Guard, Washington, DC  A Unfortunately this isn't going to  be  a  funny one, but since no-A one has present magic on  TEAMDATA,  I  figured that if I came upt8 with anything I'd be a shoe in for the TEAMDATA doc set.  A For those of you who  have  never  used TEAMDATA or looked at it,tA it's a really interesting  product.    One  of  the things I findoA annoying about the  product  though,  is  when you delete variousmA things such as  tables  or  sheets  or  whatever,  it goes into a A folder called WASTEBASKET.  Then  you  have to open up the folder A WASTEBASKET and  get  rid  of  it  again.    Most unsophisticated A TEAMDATA users won't  take  that  extra  step.    So  as a systemhA manager, you need a way go  in  a get rid of everything that's ino8 peoples WASTEBASKET folder.  The best way to do this is:   $RUN SYS$SYSTEM:RDO & RDO> INVOKE DATABASE FILENAME "TEAMDB"! RDO> START_TRANSACTION READ_WRITEn= RDO> FOR A IN VDD$VIA$ROOTDIR WITH A.DIR$NAME = "WASTEBASKET"D@ RDO> FOR B IN VDD$VIA$ROOTDIR WITH B.DIR$PARENT=A.DIR$ELEMENT_ID RDO> ERASE B END_FOR END_FOR RDO> COMMITD  A and you can set this up to  run  as a command procedure to run atS. night to empty all the TEAMDATA waste baskets.    0 Mike Reopell, Williams College, Williamstown, MA  A At the college we  have  a  lot  of  reasons to do reports and/oruA mailing labels that are  specific  to regional areas.  EverythingtA was based on zip codes.  This is a real brief version of what ourE! DATATRIEVE procedure looked like.d   . . .h READY ADDRESS SHARED READI READY PERSON SHARED READ . . .-0 FOR ALL ADDRESS WITH  ZIPCODE BT "...","..." AND0                       ZIPCODE BT "...","..." AND                       . . .o BEGIN:3     FOR FIRST 1 PERSON WITH ID_NUM = ADDRESS.ID_NUM 	     BEGINe;         FOR ALL ADDRESS WITH ADDRESS.ID_NUM = PERSON.ID_NUM 
         . . .h  A However, with the Post  Office  in its infinite wisdom constantly-A changing zip codes and adding new regions, the RSE in the initial A loop [WITH ZIPCODE BT ...] was getting out of hand.  Plus it tiedaA people specifically to zip  codes.    I'll  try to clarify that ao
 little later.c  A Basically what we did was select all records by zip code and someeA other stuff, we than tie  that  to  the PERSON file while has all A the information about  specific  classes  of  alumni, and then we A have to go back for  all  address again because alumns don't havelA one address.   They  could  have  a  home,  business, and severaldA seasonal addresses.  And we need to get their current zip code to  store for a zip code sort.    A So for the new release of our  data base, they came up with these A things called GEO_CODEs.    Take  out  ZIPCODE,  put in GEO_CODE.  Presto.    READY ADDRESS SHARED READe READY PERSON SHARED READ . . .cA FOR ALL ADDRESS WITH WITH GEO_CODE = "XYZ" BEGIN FOR    FIRST   1  PERSON WITH ID_NUM . . . BEGIN/         FOR ALL ADDRESS WITH ID_NUM . . . BEGINs             . . .b  A The nice part about  GEO_CODEs  and  the  reason that they reallycA wanted to have them was they  could  go  as assign an alumni to aeA specific regional area without  changing  the  zip  code.  Plus I 3 only had to go a look at one alternate keyed field.   A The problem was on a small test of 100 records, the ZIPCODE based(A procedure took 1  minute  and  7  seconds  and  the GEOCODE based A procedure took 1 minute and 48 seconds - only a small increase inEA CPU time.  But on  a  larger  test  of 4,000 records, the ZIPCODEMA based procedure to 1 hour  and  5  seconds while the GEOCODE basebA procedure  was  killed  after  11  hours  and  33  seconds havingcA performed 2,342,843 direct I/Os.   At  this  point, I had no ideahA what  was  going  on.    Basically,  DATATRIEVE  gets Alzheimer'suA disease; it has no idea where it  is.  Within the second FOR loopnA on ADDRESS, DATATRIEVE gets lost and  sits  in a state of I/O for( ever.   A I thought I figured out a way around this; I hadn't really solved.A it. I called Digital's Hot  Line;  the DATATRIEVE people blame it A on the DCL people and the  DCL  people blame it on the DATATRIEVE 3 people.  Neither one of them answers your question.   A What I did was break  the  problem  down into its smallest parts. A When you go into  a  domain  twice  when  the initial loop uses afA record  selection  expression  on  an  alternate  key  with  manyn duplicates, causes the problem.d  A When I was using ZIPCODE with  50,000 records, I had about 46,000lA unique zip codes.   But  with  GEOCODE, those 50,000 records gaveoA only about 70  unique  regional  codes;  I  had  lots and lots ofi3 duplicates.  That is the root cause of the problem.   7 Well, I didn't cure this problem, I went around it withD   READY ADDRESS SHARED READ  READY PERSON SHARED READ DEFINE FILE TMP_ADR_ID;e READY TMP_ADR_ID WRITE . . .I@ FOR ADDRESS WITH WITH GEO_CODE = "XYZ" ... REDUCED TO ADDRESS_ID2     STORE TMP_ADR_ID USING TMP_ID = ADDRESS_ID_NUM . . .i FOR TMP_ADR_ID BEGIN"     FOR FIRST 1 PERSON . . . BEGIN         FOR ADDRESS . . . BEGIN              . . .n             . . .r  A By storing the ADDRESS_ID_NUM in a temporary domain, we avoid theeA two FOR loops in  ADDRESS.    This  situation actually results infA less CPU time  and  fewer  I/Os  than  the original ZIPCODE-basedg
 procedure.  A But I made the  mistake,  like  Harry  Miller,  of talking to Joe A Gallagher about this problem, and  what Joe suggested was the usee of an alias like   READY PERSON SHARED READ READY ADDRESS SHARED READ & READY ADDRESS AS ADDRESS_2 SHARED READ . . .mA FOR ALL ADDRESS WITH WITH GEO_CODE = "XYZ" BEGIN FOR    FIRST   1t PERSON WITH ID_NUM . . . BEGIN1         FOR ALL ADDRESS_2 WITH ID_NUM . . . BEGINr             . . .o  A This hasn't been tested yet.    I  know mine works, but I suspectdA the alias also works.   And  Andy [Schneider] is shaking his heado [in agreement].     * Pat Scopelliti, Corning, Inc., Corning, NY  A Over the years we have  had  "Dueling Logical Names" and "DuelingdA Functions" and  "Dueling  Escapes."    What  we  have  tonight isa "Dueling Centering."   DECLARE B PIC X(66). DECLARE X PIC X(40). X = *."title to be centered" B = " " = PRINT FN$STR_EXTRACT(B,1,(132-FN$STR_LOCATE(X||"~","~"))/2)|Xi    5 Mary Ann Lightfoot, Aratex Services, Inc., Encino, CA   A I work in a shop full  of  guys and I'm always getting flack thatEA DATATRIEVE can't do this, can't  do  that, and shouldn't do this.tA And most of the file we have are very large; we have one that hasyA our field [service?]  information  in  it  and  it's over 300,000AA blocks long.  And, of  course,  that  is what the general managersA want to see.  They want to  see  the revenue.  Part of the recordt of the huge file looks like:   . . .I
    05 KEY.       07 CUST PIC 9(9) COMP 3.       07 LINE PIC 9(9) COMP 3.       07 ITEM PIC X(15).    05 MORE_FIELDS.       . . .     05 PURCHASE_ORDER PIC X(10).e6    05 CUST_MANE COMPUTED BY (CUST VIA CUSTOMER_TABLE).6    05 NEW_KEY_FIELD COMPUTED BY (CUST|PURCHASE_ORDER).       . . .  ;e  A When I extract a portion  of  the  huge  file into a much smaller.A file which is keyed  on  NEW_KEY_FIELD  with  a record that looksh like   . . .     05 NEW_KEY_FIELD PIC X(19).    05 MORE_FIELDS. . . .t  A there is  a  big  performance  win,  because  the  small  file isn' equivalent to the huge one with an RSE.     / Richard Copeland, Corning, Inc., Wilmington, NCs  A [Editor's note: Last summer, Richard moved from Wilmington to thes# Corning facilities in Corning, NY.]e  A This magic is called "If you  feed  a Wombat long enough, it gets"A very very large!"  This  is  not  particularly magical, but it is6A one of the more interesting  things we have done with DATATRIEVE.iA But it may expand your horizons  a  little bit.  When you have an7A application in  DATATREIVE  it  become  very  popular.   You keeppA adding record to it and keep adding  to it and it go on for years A and years.  And it gets bigger and bigger and bigger.  How do youtA rid of any of  the  records  and  still retain DATATREIVE access? A That was our problem.  We  started building this file in 1981 andGA by 1988 the [detail]  file  was  taking  up  half of an RA81 diskuA drive and getting  bigger  all  the  time  and  becoming a reallyuA unwieldy size.  At first we tried to split the file into the dataDA for the last six months and then all older data.  But the archive + data was still too big to easily deal with.o  A The file organization is  a  master  record which contains headeroA information about large  pieces  of  glass.   The detailed domaineA contains 20 or so records  about  the  small pieces of glass thatnA are made out of  the  large  ones.    Most  of  the people in ouriA organization are interested in  the  detail information, and theytA are not very interested in  the header [master file] information. A But we keep it  anyway.    But  the  header  information is a loteA smaller than  the  detail  information.    One  of  the pieces ofAA information in the  header  is  the  creation  date of the detailA record; that's very important.  A We decided to keep  on  the  last  4  years of detail information=A online.  We surveyed the people  who  use this data and they said A that they didn't really  need  instantaneous access to data olderh< than four years as long as we can get to it in a day or so.   A We created a magnetic tape  for  each year that would be archived A and we left the header record  alone.    We used the COPY commandi0 to transfer the file to individual year's tape.   A On rare occasions  (maybe  once  every  two  weeks) when the usere" needs to access the archived data:  A   1. The user finds the header record and gets the creation date.S   2. Exits from DATATRIEVE."A   3. Executes a  DCL  command  file  that  prompts  for the year, A      mounts  the  proper  tape,  defines  a  logical  HISTTAPE asE      TAPE:FILENAME.DATA   4. Starts  DATATREIVE,  READYs   the   domain  that  points  to       HISTTAPE.,   5. Then uses a FOR to get the needed data.  A This works  just  like  a  disk-based  domain  except  that it isiA sequential access file and no collections can be used.  And it is > quite fast!  That's how we solved our very large file problem.    @ ----------------------------------------------------------------,                     Author Index - Volume 10=    Joe H. Gallagher, Ph. D., 4GL Solutions, Overland Park, KSn@ ----------------------------------------------------------------A The annual Author Index of  the  Wombat Examiner and 4GL Dispatch A has been constructed in the  same  manner as the Author Index forsA the first nine volumes which appeared October of 1988, Volume 10,rA Number 2, page DTR-12.  Volume  10 of the Wombat Examiner and 4GLeA Dispatch is Volume 4 of the  DECUS SIGs Newsletter and covers theZA period September of 1988 through August  of 1989.  An attempt has 7 been made to use the author's full name when available.T    ' Babiarz, John                N4p8, N6p4E( Beer, Alan H.                N1p20, N2p7' Carpenter, John              N1p4, N4p1 ) Chimene, Jeff                N1p13, N12p1C! Copeland, Richard            N2p3a( Cordiviola, Steven           N4p8, N10p5" Diba, Ali                    N7p13! Doyle, Ellen A.              N5p6g" Dubiner, Eric S.             N11p5" Ferrara, Raymond             N4p11" Fournier, Thomas R.          N1p16' Fredrickson, Steven C.       N8p2, N9p5(A Gallagher, Joe H.            N1p1, N1p3, N1p9, N1p11, N2p1, N2p5, A                              N2p12,  N3p3,   N3p25,  N4p1,  N4p7,EA                              N4p9,  N4p10,  N4p11,  N4p12, N4p13,MA                              N5p4, N5p9, N5p12, N6p1, N6p2, N7p1,bA                              N7p16,  N8p1,   N8p3,   N9p1,  N9p1,c)                              N11p1, N11p9i" Ganel, Shaul                 N11p4" Garcia, Evelyn               N4p13! Gross, Charles R.            N8p2a! Hall, Sue                    N2p5 ( Hatfield, David A.           N8p1, N11p5) Henning, John L.             N11p1, N12p7 ! Herzmark, Leonard E.         N2p9 " Hicks, Larry                 N12p3" Holst, Sabastian             N4p10. Hulse, Lesley A.             N5p1, N8p1, N11p5! Jasmann, Lawrence M.         N2p5i" Kah, Ann F.                  N1p15! Lasher, Lew                  N2p5nA Lederman, Bart Z.            N4p4,  N7p5,  N9p3,  N10p13,  N11p3,r)                              N11p6, N12p9h" Lehman, Donna                N10p4! Mathis, Jack                 N6p9t! McDavid, Glenn T.            N6p5s! McKim, James                 N9p6s2 Miller, Harry J.             N1p18, N10p10, N11p10" Naecker, Philip A.           N7p13' Reines, Herbert G.           N1p3, N6p1y# Reynolds, Bernadette         N10p10I" Richards, Brian              N4p11' Roduner, Larry D.            N2p6, N7p2 ! Rogers, Tony                 N9p7mA Roseberry, Bert A.           N1p2, N1p20, N2p8, N3p1, N5p4, N6p2,N0                              N7p14, N7p17, N11p9! Schneider, Andrew W.         N2p5I5 Schwartz, Dana J.            N1p16, N5p1, N6p9, N11p9 . Scopelliti, Pasquale F.      N4p3, N6p5, N11p1! Simutis, John D.             N6p1O! Stern, Jr., Donald E.        N4p9 ( Swan, David M.               N6p7, N7p15( Tellis, Winston              N8p3, N12p3" Unknown,                     N4p14A Wool, T. Chris               N1p4,  N5p1,   N8p3,   N8p5,  N10p1,u*                              N11p10, N12p5  @ -----------------------------------------------------------------                     Keyword Index - Volume 10t=    Joe H. Gallagher, Ph. D., 4GL Solutions, Overland Park, KSa@ ----------------------------------------------------------------A The annual Keyword Index of  the Wombat Examiner and 4GL Dispatch A has been constructed in the same  manner as the Keyword Index for A the first nine volumes which appeared in November of 1988, VolumeUA 10, Number 3, page DTR-25.    Articles  in Volume 10 (Volume 4 of A the DECUS SIGs Newsletter) were  manually assigned up to five keyAA words or key phrases.  These  assignments were made by best guesspA and experience.   Each  article,  editorial,  letter to editor or"A chair, and each individual  Wombat  Magic presentation or problemaA solution was given a  separate  reference  designation and set ofR	 keywords.6  A If a particular product was identified, that product abbreviationNA became one of the five  keywords.   However, most of the articlesyA deal with VAX-DATATRIEVE and this keyword was not always assignedhA if there were  other  more  specific  keywords  that needed to benA assigned.  References dealing  with DTR-11, TEAMDATA, RALLY, CDD,hA FMS, and  the  non-Digital  4GLs  of  ACCENT  R,  CORTEX, INGRES,r3 ORACLE, POWERHOUSE, and SMARTSTAR are easily found.      Al  ' ACCENT R                          N10p4e- ACCENT R WG                       N8p3, N12p3 ' arrays, pseudo                    N1p16e' AT BOTTOM OF PAGE                 N7p13E& AT TOP OF                         N6p1& AT TOP OF PAGE                    N2p5' Atlanta support                   N11p9 ' author index                      N2p12 ' award, outstanding SIG            N11p1M   BB  & ballot analysis, PIR              N1p4' BASIC                             N12p1h' bibiography                       N10p5l   Co  & calculator                        N6p4& CDD                               N5p1, CDD/Plus                          N4p3, N5p1( centering                         N11p10' comment searcher                  N1p20h& COMPUTED BY                       N2p38 COMPUTED BY CHOICE OF             N4p8, N6p1, N6p1, N6p5, contest                           N1p9, N2p1' contest data                      N5p12 & contest question                  N7p1- context variable                  N4p11, N6p1n& continuation flag                 N6p1' CORTEX WG                         N11p5t' Cropper, Douglas                  N11p1 ' cross referencing                 N10p1y& CROSS, avoiding                   N2p5   Do  ' data base restructure             N10p4 & data, cleaning up                 N6p5( date arithmetic                   N11p106 date data type                    N5p4, N10p10, N11p10. date formatting                   N4p13, N4p13- date reformatting                 N1p9, N1p20e( DCL                               N10p13& DECGRAPH                          N1p2- DECLARE...COMPUTED BY...MAX       N4p9, N4p10 3 DECREPORTER                       N1p4, N4p1, N11p1 ' DECUS membership test             N7p14 & DECUS, goals                      N8p1& disk usage                        N4p4. domain, scratch                   N4p13, N4p13A DTR                               N1p2, N1p3,  N1p4, N1p9, N1p11, A                                   N1p13,  N1p16,   N1p18,  N1p20,eA                                   N2p3, N2p5,  N2p5,  N2p6, N2p7,aA                                   N2p8, N2p9,  N3p1,  N4p1, N4p4, 3                                   N5p6, N8p5, N11p1a& DTR V4.2                          N5p1' DTR$DATE_INPUT                    N1p20 & DTR, callable                     N6p4A DTR-11                            N1p4, N1p9,  N1p15, N2p5, N4p1, A                                   N4p10,   N4p13,   N4p13,  N5p1, '                                   N11p1t   Ed  & EDIT ALL                          N2p5' EDITing in DTR                    N7p15l& editor, SUMSLP                    N2p8& editors and chairs                N1p1- errata                            N3p2, N11p3l& errata, see                       N4p7& error message                     N3p1& error messages, capture           N9p5& escape sequences                  N2p6. exit status                       N1p13, N7p13& EXIT, control of                  N6p2   Fs  & field test site                   N6p9' file access in function           N7p17 & file names, computed              N8p3& file names, printing              N9p3' FILLER, use of                    N1p15t& FIMS                              N4p3& fiscal year                       N6p1& FMS                               N5p6& FMS, list in                      N7p2' fn$attach                         N12p1 & fn$baby_ed                        N3p1' fn$char                           N11p9.' fn$convert_reclaim                N11p6d& fn$create_log                     N8p3. fn$date                           N5p4, N11p10( fn$dcl                            N10p13' fn$define_log                     N7p13s' fn$edit                           N11p6-' fn$edit_blob                      N7p13-& fn$exit                           N6p2& fn$fao                            N4p4' fn$fdl_create                     N11p6P( fn$floor                          N10p10& fn$julian                         N4p8' fn$lov                            N7p17r' fn$mod                            N1p16i& fn$month                          N6p1/ fn$nint                           N1p18, N10p10e' fn$pos_extract                    N12p9R. fn$random                         N1p11, N1p18& fn$soundex                        N7p5' fn$str_case_blind_compare         N12p9e' fn$str_element                    N12p9 A fn$str_extract                    N1p16,   N4p4,   N5p9,   N10p5,e(                                   N10p10' fn$str_find_first_in_set          N12p90' fn$str_find_first_not_set         N12p9,' fn$str_length                     N10p53; fn$str_loc                        N2p3, N5p9, N10p5, N11p10v- fn$str_replace                    N1p11, N5p9 & fn$trim_filespec                  N9p3& fn$upcase                         N5p4& fn$year                           N6p1. FOCUS                             N4p10, N5p123 FOCUS WG                          N5p1, N8p1, N11p5 ' FOR...FOR                         N4p115& FOR...REDUCED...SORTED BY         N4p9& FORMAT fn$str_extract             N4p43 FORTRAN                           N1p20, N2p9, N6p4p& FUN$K_STATUS                      N3p1& function return status            N3p1' functions                         N1p11p   GN  ' games, craps                      N1p18N& GET_FORM                          N7p24 global variable buffer            N4p9, N4p10, N4p11& group field, principal            N9p1   H   & help menu                         N2p5& hierarchies                       N5p6& history of Wombat Examiner        N1p1A humor                             N1p16,   N1p20,   N4p14,  N6p9,i5                                   N7p14, N11p9, N11p9,   I,  - index                             N3p3, N3p25A& index, KWIC                       N5p9& index, newsletter                 N5p9' INGRES WG                         N12p33' init file                         N10p4N& installation                      N5p1   K0  & key remapping, dynamic            N9p7' keyword index                     N3p25J& KWIC index                        N3p3   L   ' Lederman, Bart Z.                 N11p1P& line movement, partial            N2p6& lines in report, vertical         N2p6( lines, dial-in                    N10p13' list of values in DTR             N7p17 & LN03                              N2p6( login analysis                    N10p13   Mp  - MACRO                             N7p5, N11p3 ( management, system                N10p13& MATCH                             N7p2' messages, VMS style               N1p13p& missing records                   N2p5   NN  & news                              N4p3& NOECHO                            N6p5& normalization                     N6p7& numeric format                    N1p3   Ow  & OCCURS clause                     N7p1- ORACLE WG                         N4p2, N11p4N   Pu  & pages per volume                  N1p1& parsing                           N2p9' parsing, text                     N10p1 & password                          N6p5A PIR                               N1p4, N5p1,  N8p5, N9p1, N12p5,-'                                   N12p7-& PIR process                       N8p1, PLOT ENSIGN                       N2p8, N3p2& PLOT MULTI-BAR                    N4p8& PLOTS                             N2p8& pollution monitoring              N2p9& PORT, declare                     N6p43 POWERHOUSE WG                     N4p2, N8p1, N11p5 ' prime number generator            N7p16u& PRINT NEW-PAGE                    N2p5& print, very complex               N6p5& problem contest                   N9p1A problem solution                  N4p8, N4p8,  N4p9, N4p9, N4p10, A                                   N4p10,  N4p11,   N4p11,  N4p13,e.                                   N4p13, N5p12& problem statement                 N4p7& procedure in RSE                  N2p5& procedure, input                  N2p7' PROCEDURES, dummy                 N7p15d& protection, field level           N6p7   Qe  ( quad data type                    N11p10   Re  A RALLY                             N2p5, N4p1,  N5p1,  N9p5, N9p6,L-                                   N9p7, N11p1 , RALLY WG                          N4p2, N8p2' Rdb blob                          N7p13 & records, "relative"               N6p9& records, previous                 N6p9- REDEFINES                         N1p15, N2p9 & relinking                         N1p2& report writer                     N2p3& report, multi-group               N9p6' responses to PIRs, Digital's      N12p7 & RUNNING TOTAL                     N6p1   S   ' screen formatting                 N1p161' screen management                 N10p4 ' screen paging                     N7p13 ' scrolling regions                 N11p9 & Searching all fields              N9p1& seminars                          N2p1' sessions, least popular           N11p9 & sharable images                   N1p2' single statement                  N4p11r, SMARTSTAR WG                      N4p2, N8p2' SMG$                              N7p17 ' solution performance              N4p12sA sorted extremum                   N1p9, N4p7,  N4p8,  N4p8, N4p9, A                                   N4p9,   N4p10,   N4p10,  N4p11,b.                                   N4p11, N4p12& sorting                           N6p1- Soundex                           N7p5, N11p3 ' Starkey, Jim                      N7p16 & steering committee meetings       N2p1& stock holding report              N6p5& string vs numeric                 N1p3& suite activities                  N2p1& SUMSLP                            N3p2   Ty  & table translation                 N1p3& tables                            N2p7& tables, for protection            N6p7' talk to developers                N1p20 ? TEAMDATA                          N1p2, N4p1, N5p1, N8p5, N11p1.& test data                         N4p7' text, management                  N1p1540 time, average                     N10p10, N11p10& time, entry of                    N5p4& titles, centered                  N2p3< top 10 list                       N1p16, N1p20, N11p9, N11p9' TPU                               N7p13,   U,  ' user complaints                   N1p16 & USING T                           N6p5   V   & validation                        N2p7' VIA TABLE                         N1p13 & Volume 10                         N1p1' Volumes 1 to 9                    N2p128& volunteer                         N9p1& volunteer recruitment             N2p1- volunteers, new                   N4p3, N11p1    W   ' Wombat Examiner & 4GL Dispatch    N2p129- Wombat Examiner, index            N3p3, N3p25      X, Y, Z1  & X-Windows                         N4p3& zip codes                         N2p5    @ ----------------------------------------------------------------9         Keyword In Context (KWIC) Title Index - Volume 10n=    Joe H. Gallagher, Ph. D., 4GL Solutions, Overland Park, KS @ ----------------------------------------------------------------A The annual Keyword in Context  Title  Index  for Volume 10 of the A Wombat Examiner and 4GL Dispatch  was  created in the same way as A the KWIC index for Volumes 1  to 9 which appeared in the November , 1988 issue, Volume 10, Number 3, page DTR-3.  A From the title of  each  article  in  Volume  10 (Volume 4 of the A DECUS SIGs  Newsletter),  a  standard  keyword  in context (KWIC) A index was  constructed.    Many  entries  were  removed.  RemovedyA entries included all non-essential  punctuation, all articles (a,5A an, and the), many  isolated  digits, all conjunctions which were A not used as DATATRIEVE reserved  words, many verbs which were not A used as  DATATRIEVE  reserved  words,  many  adjectives, and many1 adverbs.    x Keyword                            Keyword in Context Rotated Title                                            Reference  t 'TWAS                      'Twas the Night before Implementation  A Seasonal Poem -                            N4p14s 1988                       1988 DECUS Update  Fall                                                             N4p3                             1988 Fall DECUS Symposium, Anaheim, CA  Results of Problem Contest at Wombat Magic  N4p7,   N4p8,  N4p8,                                                                                                                 N4p9,  N4p9,  N4p10,n                                                                                                                N4p10, N4p11, N4p11,r                                                                                                                N4p12, N4p13, N4p13s                            1988 Fall Symposium in Anaheim  DTR/4GL Activities at the                           N2p1os 1989                       1989  DATATRIEVE Contest - Spring                                                   N7p1Nt 4GL                        4GL Dispatch, Volumes 1 to 9  Author Index of Wombat Examiner and                   N2p12   A   t ACCENT R                   ACCENT R TIPS & TECHNIQUES                                                          N10p4t                            ACCENT R Working Group News  Atlanta DECUS                                          N12p3s ACTIVITIES                 Activities at the 1988 Fall Symposium in Anaheim  DTR/4GL                           N2p1                             Activities in Atlanta  DTR/4GL SIG Sponsored Working Group                          N8p1,   N8p1,  N8p2, y                                                                                                                N8p2, N8p3cs ADDING                     Adding a Soundex Function to DATATRIEVE                                             N7p5 s                            Adding the Function LIB$TRIM_FILESPEC to DATATRIEVE                                 N9p3 s ANAHEIM                    Anaheim  Contest at Wombat Magic in                                                 N1p9 s                            Anaheim  DTR/4GL Activities at the 1988 Fall Symposium in                           N2p1                             Anaheim, CA  Results of Problem Contest at Wombat Magic 1988 Fall DECUS Symposium,  N4p7,   N4p8,  N4p8,                                                                                                                 N4p9,  N4p9,  N4p10,                                                                                                                 N4p10, N4p11, N4p11,1                                                                                                                N4p12, N4p13, N4p13s ANALYSIS                   Analysis and Digital's Responses  PIR Ballots                                       N1p4 t                            Analysis of PIR Ballots                                                             N12p5t APPLICATIONS               Applications  Cross Referencing DATATRIEVE                                          N10p1 ATLANTA                    Atlanta  DTR/4GL SIG Sponsored Working Group Activities in                          N8p1,   N8p1,  N8p2,ay                                                                                                                N8p2, N8p3 t                            Atlanta DECUS ACCENT R Working Group News                                           N12p3t                            Atlanta Symposia  DTR/4GL SIG News of the                                           N11p1t                            Atlanta Symposium  INGRES Working Group Report for                                  N12p3t AUTHOR                     Author Index of Wombat Examiner and 4GL Dispatch, Volumes 1 to 9                    N2p12   B   u BAD                        Bad Dial-In Lines with DATATRIEVE (and DCL)  Identifying                            N10p13 t BALLOTS                    Ballots  Analysis of PIR                                                            N12p5s                            Ballots Analysis and Digital's Responses  PIR                                       N1p4ct BEFORE                     before Implementation  A Seasonal Poem - 'Twas the Night                            N4p14t BIBLIOGRAPHY               Bibliography Using VAX DATATRIEVE  Database for a Scientific                        N10p5   CL  u CALCULATING                Calculating Median Time with DATATRIEVE                                             N10p10 s CALL                       Call for Product Improvement Requests (PIRs)                                        N5p1 t CALLING                    Calling Utilities as DATATRIEVE Functions                                           N11p6s CHOICE                     CHOICE OF Fields  Sorting on COMPUTED BY                                            N6p1 s COMPUTED                   COMPUTED BY CHOICE OF Fields  Sorting on                                            N6p1 s CONTEST                    Contest - Spring 1989  DATATRIEVE                                                   N7p1                             Contest at Wombat Magic 1988 Fall DECUS Symposium, Anaheim, CA  Results of Problem  N4p7,   N4p8,  N4p8,r                                                                                                                N4p9,  N4p9,  N4p10,o                                                                                                                N4p10, N4p11, N4p11,                                                                                                                 N4p12, N4p13, N4p13s                            Contest at Wombat Magic in Anaheim                                                  N1p9 s CONTEXT                    Context (KWIC) Title Index - Volumes 1 to 9  Keyword in                             N3p3 t CORTEX                     CORTEX Working Group Report                                                         N11p5t CROSS                      Cross Referencing DATATRIEVE Applications                                           N10p1   Dp  t DATABASE                   Database for a Scientific Bibliography Using VAX DATATRIEVE                         N10p5s DATATRIEVE                 DATATRIEVE  Adding a Soundex Function to                                            N7p5 s                            DATATRIEVE  Adding the Function LIB$TRIM_FILESPEC to                                N9p3 u                            DATATRIEVE  Calculating Median Time with                                            N10p10 t                            DATATRIEVE  Database for a Scientific Bibliography Using VAX                        N10p5s                            DATATRIEVE  Parsing Text Using                                                      N2p9 u                            DATATRIEVE (and DCL)  Identifying Bad Dial-In Lines with                            N10p13wt                            DATATRIEVE Applications  Cross Referencing                                          N10p1s                            DATATRIEVE Contest - Spring 1989                                                    N7p1St                            DATATRIEVE Functions  Calling Utilities as                                          N11p6s                            DATATRIEVE; With a Note on Edit-Strings  Measuring Disk Usage with                  N4p4 u DCL                        DCL)  Identifying Bad Dial-In Lines with DATATRIEVE (and                            N10p13et DECUS                      DECUS ACCENT R Working Group News  Atlanta                                          N12p3                            DECUS Symposium, Anaheim, CA  Results of Problem Contest at Wombat Magic 1988 Fall  N4p7,   N4p8,  N4p8,t                                                                                                                N4p9,  N4p9,  N4p10,i                                                                                                                N4p10, N4p11, N4p11,y                                                                                                                N4p12, N4p13, N4p13s                            DECUS Update  Fall 1988                                                             N4p3 u DIAL-IN                    Dial-In Lines with DATATRIEVE (and DCL)  Identifying Bad                            N10p13ot DIGITAL'S                  Digital's Response to DTR/4GL SIG Product Improvement Requests                      N12p7s                            Digital's Responses  PIR Ballots Analysis and                                       N1p4 s DISK                       Disk Usage with DATATRIEVE; With a Note on Edit-Strings  Measuring                  N4p4 t DISPATCH                   Dispatch, Volumes 1 to 9  Author Index of Wombat Examiner and 4GL                   N2p12s DTR/4GL                    DTR/4GL Activities at the 1988 Fall Symposium in Anaheim                            N2p1 t                            DTR/4GL SIG News of the Atlanta Symposia                                            N11p1t                            DTR/4GL SIG Product Improvement Requests  Digital's Response to                     N12p7                            DTR/4GL SIG Sponsored Working Group Activities in Atlanta                           N8p1,   N8p1,  N8p2,Ny                                                                                                                N8p2, N8p3    EI  s EDIT-STRINGS               Edit-Strings  Measuring Disk Usage with DATATRIEVE; With a Note on                  N4p4 s EDIT/SUMSLP                EDIT/SUMSLP File  Errata for ENSIGN                                                 N3p2  EDITOR                     Editor  Letter to the                                                               N7p2, N11p3, N12p1 s EDITOR'S                   Editor's Pen  From the                                                              N1p1 y EDITORIAL                  Editorial  An                                                                       N8p1, N9p1Is ENSIGN                     ENSIGN EDIT/SUMSLP File  Errata for                                                 N3p2 t ERRATA                     Errata                                                                              N5p12s                            Errata for ENSIGN EDIT/SUMSLP File                                                  N3p2,t EXAMINER                   Examiner and 4GL Dispatch, Volumes 1 to 9  Author Index of Wombat                   N2p12   Fp  s FALL                       Fall 1988 DECUS Update                                                              N4p3                             Fall DECUS Symposium, Anaheim, CA  Results of Problem Contest at Wombat Magic 1988  N4p7,   N4p8,  N4p8,                                                                                                                 N4p9,  N4p9,  N4p10,                                                                                                                 N4p10, N4p11, N4p11,                                                                                                                 N4p12, N4p13, N4p13s                            Fall Symposium in Anaheim  DTR/4GL Activities at the 1988                           N2p1as FIELDS                     Fields  Sorting on COMPUTED BY CHOICE OF                                            N6p1,s FILE                       File  Errata for ENSIGN EDIT/SUMSLP                                                 N3p2 t FOCUS                      FOCUS Working Group Report                                                          N11p5s FROM                       From the Editor's Pen                                                               N1p1 s FUNCTION                   Function LIB$TRIM_FILESPEC to DATATRIEVE  Adding the                                N9p3 s                            Function to DATATRIEVE  Adding a Soundex                                            N7p5 t FUNCTIONS                  Functions  Calling Utilities as DATATRIEVE                                          N11p6t                            Functions for VAX-DATATRIEVE  Some More String                                      N12p9   G    GROUP                      Group Activities in Atlanta  DTR/4GL SIG Sponsored Working                          N8p1,   N8p1,  N8p2,Oy                                                                                                                N8p2, N8p3Ct                            Group News  Atlanta DECUS ACCENT R Working                                          N12p3t                            Group Report  CORTEX Working                                                        N11p5t                            Group Report  FOCUS Working                                                         N11p5t                            Group Report  ORACLE Working                                                        N11p4t                            Group Report  POWERHOUSE Working                                                    N11p5y                            Group Report  Working                                                               N4p2, N5p1 t                            Group Report for Atlanta Symposium  INGRES Working                                  N12p3   Ir  u IDENTIFYING                Identifying Bad Dial-In Lines with DATATRIEVE (and DCL)                             N10p134t IMPLEMENTATION             Implementation  A Seasonal Poem - 'Twas the Night before                            N4p14t IMPROVEMENT                Improvement Requests  Digital's Response to DTR/4GL SIG Product                     N12p7s                            Improvement Requests  Product                                                       N8p5 s                            Improvement Requests (PIRs)  Call for Product                                       N5p1et INDEX                      Index - Volumes 1 to 9  Keyword                                                     N3p25s                            Index - Volumes 1 to 9  Keyword in Context (KWIC) Title                             N3p3 t                            Index of Wombat Examiner and 4GL Dispatch, Volumes 1 to 9  Author                   N2p12t INGRES                     INGRES Working Group Report for Atlanta Symposium                                   N12p3   K   s KEYWORD                    Keyword in Context (KWIC) Title Index - Volumes 1 to 9                              N3p3Pt                            Keyword Index - Volumes 1 to 9                                                      N3p25s (KWIC)                     (KWIC) Title Index - Volumes 1 to 9  Keyword in Context                             N3p3g   L    LETTER                     Letter to the Editor                                                                N7p2, N11p3, N12p1 s LIB$TRIM_FILESPEC          LIB$TRIM_FILESPEC to DATATRIEVE  Adding the Function                                N9p3 u LINES                      Lines with DATATRIEVE (and DCL)  Identifying Bad Dial-In                            N10p13    M    MAGIC                      Magic  Wombat                                                                       N1p11, N1p13, N1p15,                                                                                                                 N1p16, N1p16, N1p18,                                                                                                                 N1p20,  N1p20, N2p3,                                                                                                                 N2p5,   N2p5,  N2p5,k                                                                                                                N2p5,   N2p6,  N2p7,l                                                                                                                N2p8,   N5p6,  N5p9,                                                                                                                 N6p2,   N6p4,  N6p5,                                                                                                                 N6p5,   N6p7,  N6p9,                                                                                                                 N6p9,  N7p13, N7p13,                                                                                                                 N7p14, N7p15, N7p16,                                                                                                                 N7p17,  N9p5,  N9p6,                                                                                                                 N9p7,  N11p9, N11p9,                                                                                                                 N11p9, N11p10,N11p10H                            Magic 1988 Fall DECUS Symposium, Anaheim, CA  Results of Problem Contest at Wombat  N4p7,   N4p8,  N4p8,                                                                                                                 N4p9,  N4p9,  N4p10,N                                                                                                                N4p10, N4p11, N4p11,e                                                                                                                N4p12, N4p13, N4p13s                            Magic in Anaheim  Contest at Wombat                                                 N1p9 s MEASURING                  Measuring Disk Usage with DATATRIEVE; With a Note on Edit-Strings                   N4p4 u MEDIAN                     Median Time with DATATRIEVE  Calculating                                            N10p10lt MORE                       More String Functions for VAX-DATATRIEVE  Some                                      N12p9   Ne  t NEWS                       News  Atlanta DECUS ACCENT R Working Group                                          N12p3t                            News of the Atlanta Symposia  DTR/4GL SIG                                           N11p1t NIGHT                      Night before Implementation  A Seasonal Poem - 'Twas the                            N4p14s NOTE                       Note on Edit-Strings  Measuring Disk Usage with DATATRIEVE; With a                  N4p4r   O   t ORACLE                     ORACLE Working Group Report                                                         N11p4   PN  s PARSING                    Parsing Text Using DATATRIEVE                                                       N2p9is PEN                        Pen  From the Editor's                                                              N1p1Dt PIR                        PIR Ballots  Analysis of                                                            N12p5s                            PIR Ballots Analysis and Digital's Responses                                        N1p4 s (PIRS)                     (PIRs)  Call for Product Improvement Requests                                       N5p1 t POEM                       Poem - 'Twas the Night before Implementation  A Seasonal                            N4p14t POWERHOUSE                 POWERHOUSE Working Group Report                                                     N11p5 PROBLEM                    Problem Contest at Wombat Magic 1988 Fall DECUS Symposium, Anaheim, CA  Results of  N4p7,   N4p8,  N4p8,                                                                                                                 N4p9,  N4p9,  N4p10,                                                                                                                 N4p10, N4p11, N4p11,                                                                                                                 N4p12, N4p13, N4p13s PRODUCT                    Product Improvement Requests                                                        N8p5It                            Product Improvement Requests  Digital's Response to DTR/4GL SIG                     N12p7s                            Product Improvement Requests (PIRs)  Call for                                       N5p1 z                            Product Status Report                                                               N4p1, N11p1   RT  t REFERENCING                Referencing DATATRIEVE Applications  Cross                                          N10p1t REPORT                     Report  CORTEX Working Group                                                        N11p5t                            Report  FOCUS Working Group                                                         N11p5t                            Report  ORACLE Working Group                                                        N11p4t                            Report  POWERHOUSE Working Group                                                    N11p5z                            Report  Product Status                                                              N4p1, N11p1y                            Report  Working Group                                                               N4p2, N5p1Rt                            Report for Atlanta Symposium  INGRES Working Group                                  N12p3t REQUESTS                   Requests  Digital's Response to DTR/4GL SIG Product Improvement                     N12p7s                            Requests  Product Improvement                                                       N8p5 s                            Requests (PIRs)  Call for Product Improvement                                       N5p1 t RESPONSE                   Response to DTR/4GL SIG Product Improvement Requests  Digital's                     N12p7s RESPONSES                  Responses  PIR Ballots Analysis and Digital's                                       N1p4  RESULTS                    Results of Problem Contest at Wombat Magic 1988 Fall DECUS Symposium, Anaheim, CA   N4p7,   N4p8,  N4p8,e                                                                                                                N4p9,  N4p9,  N4p10,                                                                                                                 N4p10, N4p11, N4p11,t                                                                                                                N4p12, N4p13, N4p13   S   t SCIENTIFIC                 Scientific Bibliography Using VAX DATATRIEVE  Database for a                        N10p5t SEASONAL                   Seasonal Poem - 'Twas the Night before Implementation  A                            N4p14t SIG                        SIG News of the Atlanta Symposia  DTR/4GL                                           N11p1t                            SIG Product Improvement Requests  Digital's Response to DTR/4GL                     N12p7                            SIG Sponsored Working Group Activities in Atlanta  DTR/4GL                          N8p1,   N8p1,  N8p2, y                                                                                                                N8p2, N8p3 s SORTING                    Sorting on COMPUTED BY CHOICE OF Fields                                             N6p1ls SOUNDEX                    Soundex Function to DATATRIEVE  Adding a                                            N7p5  SPONSORED                  Sponsored Working Group Activities in Atlanta  DTR/4GL SIG                          N8p1,   N8p1,  N8p2, y                                                                                                                N8p2, N8p3 s SPRING                     Spring 1989  DATATRIEVE Contest -                                                   N7p1 z STATUS                     Status Report  Product                                                              N4p1, N11p1t STRING                     String Functions for VAX-DATATRIEVE  Some More                                      N12p9t SYMPOSIA                   Symposia  DTR/4GL SIG News of the Atlanta                                           N11p1t SYMPOSIUM                  Symposium  INGRES Working Group Report for Atlanta                                  N12p3s                            Symposium in Anaheim  DTR/4GL Activities at the 1988 Fall                           N2p1                             Symposium, Anaheim, CA  Results of Problem Contest at Wombat Magic 1988 Fall DECUS  N4p7,   N4p8,  N4p8,                                                                                                                 N4p9,  N4p9,  N4p10,                                                                                                                 N4p10, N4p11, N4p11,                                                                                                                 N4p12, N4p13, N4p13   T   t TECHNIQUES                 TECHNIQUES  ACCENT R TIPS &                                                         N10p4s TEXT                       Text Using DATATRIEVE  Parsing                                                      N2p9lu TIME                       Time with DATATRIEVE  Calculating Median                                            N10p10 t TIPS                       TIPS & TECHNIQUES  ACCENT R                                                         N10p4s TITLE                      Title Index - Volumes 1 to 9  Keyword in Context (KWIC)                             N3p3    U   s UPDATE                     Update  Fall 1988 DECUS                                                             N4p3 s USAGE                      Usage with DATATRIEVE; With a Note on Edit-Strings  Measuring Disk                  N4p4 s USING                      Using DATATRIEVE  Parsing Text                                                      N2p9 t                            Using VAX DATATRIEVE  Database for a Scientific Bibliography                        N10p5t UTILITIES                  Utilities as DATATRIEVE Functions  Calling                                          N11p6   V   t VAX                        VAX DATATRIEVE  Database for a Scientific Bibliography Using                        N10p5t VAX-DATATRIEVE             VAX-DATATRIEVE  Some More String Functions for                                      N12p9t VOLUMES                    Volumes 1 to 9  Author Index of Wombat Examiner and 4GL Dispatch,                   N2p12s                            Volumes 1 to 9  Keyword in Context (KWIC) Title Index -                             N3p3 t                            Volumes 1 to 9  Keyword Index -                                                     N3p25   W    WIZARD                     Wizard  Wombat                                                                      N1p2,   N1p3,  N3p1,                                                                                                                 N5p1,   N5p4,  N6p1,sy                                                                                                                N8p3, N9p1it WOMBAT                     Wombat Examiner and 4GL Dispatch, Volumes 1 to 9  Author Index of                   N2p12                            Wombat Magic                                                                        N1p11, N1p13, N1p15,o                                                                                                                N1p16, N1p16, N1p18,                                                                                                                 N1p20,  N1p20, N2p3,s                                                                                                                N2p5,   N2p5,  N2p5,                                                                                                                 N2p5,   N2p6,  N2p7,                                                                                                                 N2p8,   N5p6,  N5p9,                                                                                                                 N6p2,   N6p4,  N6p5,                                                                                                                 N6p5,   N6p7,  N6p9,                                                                                                                 N6p9,  N7p13, N7p13,                                                                                                                 N7p14, N7p15, N7p16,                                                                                                                 N7p17,  N9p5,  N9p6,C                                                                                                                N9p7,  N11p9, N11p9,o                                                                                                                N11p9,       N11p10, u                                                                                                                N11p10                             Wombat Magic 1988 Fall DECUS Symposium, Anaheim, CA  Results of Problem Contest at  N4p7,   N4p8,  N4p8,                                                                                                                 N4p9,  N4p9,  N4p10,                                                                                                                 N4p10, N4p11, N4p11,                                                                                                                 N4p12, N4p13, N4p13s                            Wombat Magic in Anaheim  Contest at                                                 N1p9                             Wombat Wizard                                                                       N1p2,   N1p3,  N3p1,                                                                                                                 N5p1,   N5p4,  N6p1,sy                                                                                                                N8p3, N9p1r WORKING                    Working Group Activities in Atlanta  DTR/4GL SIG Sponsored                          N8p1,   N8p1,  N8p2, y                                                                                                                N8p2, N8p3 t                            Working Group News  Atlanta DECUS ACCENT R                                          N12p3y                            Working Group Report                                                                N4p2, N5p1 t                            Working Group Report  CORTEX                                                        N11p5t                            Working Group Report  FOCUS                                                         N11p5t                            Working Group Report  ORACLE                                                        N11p4t                            Working Group Report  POWERHOUSE                                                    N11p5t                            Working Group Report for Atlanta Symposium  INGRES                                  N12p3    