[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: [sqr-users] Need help with header



If you are trying to create a flat file, as it looks, you will never
get a heading.  Heading is generated when a page break occurs. A flat
file will not have page breaks, therefore it will never generate a
heading.

Suggestion:

If you can get a count using a single select count(*) before creating
the flat file, do so.  Otherwise, write your data to a temporary table
to build the count, then write the output file from the work table
using open/write statements.



>        To:     SQR Group <sqr-users@sqrug.org>
>        cc: 
>        Subject:        [sqr-users] Need help with header
>
>
>My specs call for record identifier length of 2, start position 1, end
>position 2, =T4.  Also need data record count (total number of records
>in the report) numeric with length of 11 start at 3 and end at 13. The
>header should be 3 lines. Here's my code:
>
>BEGIN-HEADING 3   !RESERVES THE NUMBER OF LINES IN THE HEADER
>    PRINT 'T4' (+1,1,2)    !RECORD IDENTIFIER
>    PRINT #COUNT (0,3,11) !EXCLUDES HEADER REPORT
>END-HEADING         !END OF HEADING
>
>Can anyone tell me what's wrong?  I don't get a header in the output.
>
>Thanks,
>Lisa
>

>
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users