[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] <SQR 5730> error while executing
Are you sure the other programs are opening the sqr.log file? A program
doesn't do that unless it writes something to that file. Maybe you're
running another program at the same time as this one, and they've both tried
to open an sqr.log file. Only one can succeed.
-----Original Message-----
From: premnath sunkara [mailto:spn1981@yahoo.com]
Sent: Friday, October 24, 2003 2:04 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] <SQR 5730> error while executing
Hi Richard,
My program worked when i gave a -O with no file
specified. Thanks for the help. But can anybody
explain why it is so? Because i am facing this problem
only with this particular program whereas all other
programs are able to open the sqr.log file when
executed.
Thanks to all who responded.
Premnath Sunkara.
--- "Knapp, Richard" <KnappR@umsystem.edu> wrote:
> You need a sysdadmin to give you permissions to
> write the log file. Look for the -O flag. That
> should tell you where it is attempting to write the
> log.
>
> Richard Knapp
> Database Programmer/Analyst
> Institutional Research and Planning
> University of Missouri System
> 573-882-8856
> knappr@umsystem.edu
>
>
> -----Original Message-----
> From: premnath sunkara [mailto:spn1981@yahoo.com]
> Sent: Friday, October 24, 2003 12:34 PM
> 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
__________________________________
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