QUIZ and subfiles

o.kappert@qc.aibn.com o.kappert at qc.aibn.com
Thu Mar 30 17:07:02 CDT 2023


It has been awhile but I'll give it a go....

It should not be going to a subfile.
Create a file eq for 
QUIZLIST=FILENAME;Rec=-132,,f,ascii;disc=1000000;save
Then run the quiz report, should work


Olav



    ------ Original Message ------
    From: byrnejb at harte-lyne.ca
    To: powerh-l at lists.sowder.com
    Sent: Thursday, March 30, 2023 4:06 PM
    Subject: QUIZ and subfiles

          I am trying to produce a CSV file from a type 642 QUIZ 
SUBFILE.  The QUIZ
  script compiles ok but when it is run it does not create the expected 
output
  file.  If I run the script without the SET SUBFILE statement in it 
then the
  output that appears on the terminal is what I am trying to save to a 
file.

  If I run the compiled script then all that appears to happen is that 
the QUIZ >
  prompt appears.

  Has anyone any idea what I have tripped over?  The problem script is:

  SET NOSUBFILE

  ACCESS *QZART5A1

  DEFINE QZD-QUOTE CHARACTER SIZE 1 = '*'
  DEFINE QZD-DELIM CHARACTER SIZE 1 = ','
  DEFINE QZD-QDELIMQ CHARACTER SIZE 3 = '*,*'

  SORT ON QZD-NET D                                                  &
       ON ACCOUNT-NUMBER

  REPORT SUMMARY                                                     &
         QZD-QUOTE                                                   &
       ACCOUNT-NUMBER                                                &
         QZD-QDELIMQ                                                 &
       DESCRIPTION                                                   &
         QZD-QDELIMQ                                                 &
       QZD-GROSS                                                     &
         QZD-QDELIMQ                                                 &
       QZD-NET                                                       &
         QZD-QDELIMQ                                                 &
       QZD-NET-R                                                     &
         QZD-QDELIMQ                                                 &
       QZD-COUNT                                                     &
         QZD-QUOTE

  SET SUBFILE AT ACCOUNT-NUMBER NAME QZART5A2 KEEP                   &
      NODICTIONARY PORTABLE SIZE 9600

  SET REPORT LIMIT 500000

  BUILD QZART5AB


  --
  ***          e-Mail is NOT a SECURE channel          ***
          Do NOT transmit sensitive data via e-Mail
     Unencrypted messages have no legal claim to privacy
   Do NOT open attachments nor follow links sent by e-Mail

  James B. Byrne                mailto:ByrneJB at Harte-Lyne.ca
  Harte & Lyne Limited          http://www.harte-lyne.ca
  9 Brockley Drive              vox: +1 905 561 1241
  Hamilton, Ontario             fax: +1 905 561 0757
  Canada  L8E 3C3

  --
  = = = = = = = = = = = = = = = = = = = = = = = = = = = =
  Mailing list: powerh-l at lists.sowder.com
  Subscribe: 'subscribe' in message body to 
powerh-l-request at lists.sowder.com
  Unsubscribe: 'unsubscribe <password>' in message body to 
powerh-l-request at lists.sowder.com
  https://lists.sowder.com/mailman/listinfo/powerh-l
  This list is closed, thus to post to the list you must be a 
subscriber.
  Add 'site:lists.sowder.com powerh-l' to your search terms to search 
the list archive at Google.





More information about the powerh-l mailing list