QUIZ and subfiles

James B. Byrne byrnejb at harte-lyne.ca
Thu Mar 30 16:06:38 CDT 2023


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



More information about the powerh-l mailing list