QUIZ and subfiles

[o.kappert@qc.aibn.com]

as a field delimiter, I generally use the vertical bar "|".
Olav.



    ------ Original Message ------
    From: tmjva23664 at gmail.com
    To: powerh-l at lists.sowder.com
    Sent: Thursday, March 30, 2023 5:51 PM
    Subject: Re: QUIZ and subfiles

              And SET NOHEADING

          I think the only other limitation is that the report width may 
be limited.  Can save width space with

          SET REPORT SPACING 0

          Otherwise it defaults to 2 spaces.

          If there are commas in the data there could be other issues. 
Usually solved with space or tab delimiters and import it column 
aligned.



On 3/30/23 17:57, dbrzak wrote:


The comma variable should be one character not         three and this 
should be saved as a report not a subfile and the         output should 
be imported into excel as a comma delimited text         file.



It's been a while since I did this but that's what         I see








Sent from           my Galaxy







-------- Original message --------

From: "James B. Byrne" <byrnejb at harte-lyne.ca> 
<mailto:byrnejb at harte-lyne.ca>

Date: 2023-03-30 3:40 p.m. (GMT-07:00)

To: powerh-l at lists.sowder.com <mailto:powerh-l at lists.sowder.com>

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 
<mailto:ByrneJB at Harte-Lyne.ca>
        Harte & Lyne Limited          http://www.harte-lyne.ca 
<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 
<mailto:powerh-l at lists.sowder.com>
        Subscribe: 'subscribe' in message body to 
powerh-l-request at lists.sowder.com 
<mailto:powerh-l-request at lists.sowder.com>
        Unsubscribe: 'unsubscribe <password>' in message 
body to powerh-l-request at lists.sowder.com 
<mailto:powerh-l-request at lists.sowder.com>
        https://lists.sowder.com/mailman/listinfo/powerh-l 
<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.

      --
Tracy Johnson
BT



NNNN     --
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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 
<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.




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20230330/d192eb16/attachment.html>