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

[premnath sunkara <spn1981@yahoo.com>]

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