RE: [sqr-users] <SQR 5730> error while executing

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

Whenever you run SQR, any display or show messages will be written to a
file.  You can specify the name of the file on the SQR command line, but if
you don't specify it, it will be called "sqr.log" and be written to your
current working directory.  Are you running this program from Peoplesoft or
from your PC?  That would determine was is your current working directory.
Maybe you don't have the system rights to create a file in that directory.
Perhaps you've already created a file called sqr.log and it is read-only, or
you might have it open in an editor.  Any of those cases would stop SQR from
opening (creating) it again.

-----Original Message-----
From: premnath sunkara [mailto:spn1981@yahoo.com]
Sent: Friday, October 24, 2003 10:34 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] <SQR 5730> error while executing


Hi,
       I am trying to run the following program. This
program reads from a flat file and inserts the data in
the flat file into a record. It is giving me the
following error 
<SQR 5703> Error opening the SQR log file: 'sqr.log'  
<13>: Permission denied

these are the configurations i am using

Brio product and version number :
SQR/4.3.4/PC/Windows NT 4.0/Oracle 7.3.4/Jun 03 1999 
Operating system and version number:
Windows2000 5.00.2195
Database name and version number:
Oracle
Application name: PeopleSoft 8.42
 
This is happening only for this program. All my other
programs are fine. The input file is in the following
format

34, 34, 34, 34
34, 34, 34, 34
34, 34, 34, 34

The record in the database is also fine. I mean it has
all the fields i gave in the program in the same
order.
The program is given below:


!testing  program
!using flat files to populate database

begin-program

        open 'C:\Documents and
Settings\psunkara\Desktop\test.txt' as 1 for-reading
record 3000
                !status=#filestat
!       if #filestat !0
!               show 'error opening input file'
!       else
                do read_input_file
!       end-if

end-program

begin-procedure read_input_file

        display 'inseritng records from file
C:\Documents and
Settings\psunkara\Desktop\test.txt into
UHS_PORTINVCODE'
        move 0 to #inserts
        move 0 to #tot-recs

        while not #end-file
                read 1 into $input:1000
                if #end-file 
                        break
                end-if
                unstring $input by $sepchar into -
                $UHS_NDIP -
                $UHS_NDNAME -
                $UHS_PORT -
                $UHS_DELTATRAFFIC
        
                do insert_temp_job
        end-while

        close 1
!       display 'total records inserted: ' noline
!       display #tot_recs 999,999,999

end-procedure

begin-procedure insert_temp_job

begin-sql on-error=insert_error

        insert into PS_UHS_PORTINVCODE
        (
        UHS_NDIP,
        UHS_NDNAME,
        UHS_PORT,
        UHS_DELTATRAFFIC
        )

        values
        (
        $UHS_NDIP,
        $UHS_NDNAME,
        $UHS_PORT,
        $UHS_DELTATRAFFIC
        )
        
        end-sql
!       if #sql-count=1
!               add 1 to #inserts
!               if #inserts >= 500
                        commit
!                       move 0 to #inserts
!               end-if
!               add 1 to #tot_recs
!       end-if

end-procedure

begin-procedure insert_error
        
        if #sql-status=-9 !if duplicate(this code is
for
oracle only)
                show 'insert error:duplicate role is
not allowed for
NDIP' $UHS_NDIP
        else
                show 'insert error: ' $sql-error
                show 'error number: ' #sql-status
                stop !halt program and rollback
        end-if

end-procedure

Thanking you in advance,
Regards,
Premnath Sunkara.



__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

_______________________________________________
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