Re: Writing Flat Files with SQR

[Mike Olson <msolson@FASTENAL.COM>]

Joe,
This is just a guess but maybe you don't have write privileges to the
directory where you are trying to create the text file.  Try specifying
the full path to a directory where you know you have write permissions.

LET $GMExecFile='c:\temp\ZFS04014.txt'     !In Begin-Report

> -----Original Message-----
> From: Joe [SMTP:jejohn1216@SURFREE.COM]
> Sent: Tuesday, August 24, 1999 11:35 AM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Writing Flat Files with SQR
>
> This is a follow-up to my earlier post about viewing LIS files with
> Excel -- Thanks to all who helped me out!
>
> I am getting the error message:
>
> 'Specified file number not opened for writing.' when I run my SQR with
> the logic in it to create a TXT file with delimiters.  I have the
> following logic in the SQR:
>
>    #DEFINE Del         ';'            ! After the #include statements
>
>    LET $GMExecFile='ZFS04014.txt'     !In Begin-Report
>    OPEN $GMExecFile as 1 For-Writing Record=500 Status=#OpenStat   !In
> Begin-Report
>
>    DO Write-Output-Record             !In Begin-Report
>    DO Close-File                      !In Begin-Report
>
> begin-procedure Write-Output-Record
> Write 1 From                          !This line brings the error
>
>   $tl_cust_name        {Del}
>   $tl_cust_id          {Del}
>   $tl_product          {Del}
>   $tl_project_id       {Del}
>   $descr               {Del}
>   $spn_sales_person
>
> end-procedure !Write-Output-File
>
> I have gone over the chapter in SQR in PeopleSoft dealing with this,
> and I have studied all the responses I got from my earlier post. I
> can't see what is missing or wrong here.
>
> Help!?!
>
> TIA Much!
>
> Joe Johnson
> jejohn1216@surfree.com
>
> __________________________________________
> $14.95 a month Unlimited Internet Access.
> Get your first month for $1.00.
> http://www.surfree.com/promo