[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]
RE: [sqr-users] CURSOR error message when running SQR on Unix wit hreadonly user (directmail)

Subject: RE: [sqr-users] CURSOR error message when running SQR on Unix wit hreadonly user (directmail)
From: "Richard C Spoth" <Spoth.Richard@healthnow.org>
Date: Mon, 2 Feb 2004 06:11:50 -0500
Cc: "'sqr-users@sqrug.org'" <sqr-users@sqrug.org>, sqr-users-admin@sqrug.org
List-id: This list is for discussion about the SQR database reporting language from Hyperion. <sqr-users.sqrug.org>
You could also have your DBA grant the new "report" user permission to 
create Stored Procedures. 

Rick Spoth





Peter Burton <Peter_Burton@Hyperion.com>
Sent by: sqr-users-admin@sqrug.org
01/30/04 08:15 PM
Please respond to sqr-users

 
        To:     "'sqr-users@sqrug.org'" <sqr-users@sqrug.org>
        cc: 
        Subject:        RE: [sqr-users] CURSOR error message when running SQR 
on Unix wit       h 
readonly user


Martha,

By default SQR will automatically create stored procedures as needed.  To
disable this functionality add the -XP to the command line.

Peter

> -----Original Message-----
> From:          sqr-users-admin@sqrug.org@HYPERION  On Behalf Of 
mc_integra8
> <mc_integra8@yahoo.ca>
> Sent:          Friday, January 30, 2004 7:02 PM
> To:            sqr-users@sqrug.org
> Subject:               [sqr-users] CURSOR error message when running SQR 
on Unix
> with readonly user
> 
> I am hoping someone can help me with this.  Here is all the version 
info:
> 
> SQR: SQR/3.0.12.3/Sun/Solaris 2.4/Sybase 4.9.2/Mar 19 1996
> Unix:  Solaris OS V2.8,
> database: Sybase V11.9.2.
> 
> For the last couple of years, I have a SQR program executing with no
> problems.  Due to security issues with the sybase user (local) that
> executes this program (it has dbo access to the database db_local), I 
was
> asked to change the sybase user to a different user that has less
> privileges.  I had a new sybase user setup (report) that has read,
> execute, update privileges to a database called db_local).  I am now
> running into an error, this is the error:
> 
> (SQR 5528) Sybase DBSQLEXEC error in cursor 2:
> (10331) CREATE PROCEDURE permission denied, database concorde, owner dbo
> SQL: create procedure SQR_19849_1075416278;1 @__p1 varchar(12) as select
> cpty_margin_ai  from db_local..reporac where trade_id = @__p1
> Error on line 154:
> (SQR 3722) Couldn't set up cursor.
> SQR: Program Aborting.
> 
> Please note that the new user, report & local both have readonly to the
> database concorde.
> 
> This error also occurs on NT, here is the version info:
> SQR/4.0.2/PC/WINDOWS NT 4.0/Sybase CT-LIB 10.0.3/MAY02 1997
> 
> I have attached my SQR program
> 
> Thanks in advance,
> Martha
> 
> 
> 
> 
> ---------------------------------
> Post your free ad now! Yahoo! Canada Personals
> 
> 
> BEGIN-REPORT
> do main
> END-REPORT
> BEGIN-SETUP
> declare Printer
> Type=HPLaserJet
> orientation=Landscape
> Font=45
> Top-Margin=0.5
> Left-Margin=0.0
> !Lines-Inch=10
> Lines-Inch=9
> Chars-Inch=16.6
> Point-size=7
> Symbol-Set=8U
> Font-Style=Fixed
> Page-size 65 230
> printer-init <27>&l3A
> END-SETUP
> BEGIN-HEADING 6
> print ''               (1,1)
> print 'OUTSTANDING REPOS/REVERSES LENDS/BORROWS' (1) center bold
> do print_as_of_date
> print '<----- Before Margin Requirements ----->'               (+3,138) 
bold
> print '<------ Including Margin Requirements ----->'           (,183) 
bold
> print 'Customer'               (+1,1) bold
> print 'Cusip'                          (,12) bold
> print 'Maturity'               (,23) bold
> print 'Repo'                           (,36) bold
> print 'Trade'                          (,43) bold
> print 'On Date'                                (,51) bold
> print 'Off Date'               (,63) bold
> print 'Trade'                          (,75) bold
> print 'Type'                           (,84) bold
> print 'Depo'                           (,89) bold
> print 'Nominal'                                (,99) bold
> print 'Instrument'             (,107) bold
> print 'Price'                          (,127) bold
> print 'Bonds'                          (,145) bold
> print 'Cash/Collatl'           (,154) bold
> print 'Net Diff'               (,169) bold
> print 'Bonds'                          (,189) bold
> print 'Cash/Collatl'           (,202) bold
> print 'Net Diff'               (,217) bold
> print '(in mm)'                                (+1,99) bold
> print 'Date'                           (,25)   bold
> print 'Rate'                           (,36)   bold
> print 'Price'                          (,43)   bold
> graphic (+1,1,230) horz-line
> print ' '                              (+1)
> END-HEADING
> BEGIN-FOOTING 2
> print 'Printed: '              (2,1,0)  bold
> date-time                              (2,11,0)
> page-number                            (2,220)  'Page '
> END-FOOTING
> BEGIN-PROCEDURE main
> move 0 to #bond_before_tot
> move 0 to #grand_bond_before_tot
> move 0 to #net_before_tot
> move 0 to #grand_net_before_tot
> move 0 to #net_diff_before_tot
> move 0 to #grand_net_diff_before_tot
> move 0 to #bond_after_tot
> move 0 to #grand_bond_after_tot
> move 0 to #net_after_tot
> move 0 to #grand_net_after_tot
> move 0 to #net_diff_after_tot
> move 0 to #grand_net_diff_after_tot
> do get_data
> do grand_print_totals
> END-PROCEDURE main
> BEGIN-PROCEDURE get_data
> BEGIN-SELECT
> nm_cpty_name                                   (+1,1)
> ON-BREAK LEVEL = 1 SKIPLINES = 2
> sort_type                      (,11)   ON-BREAK
> LEVEL = 2 AFTER=print_totals SKIPLINES = 2 PRINT=NEVER
> cusip                                  (+1,12)
> sec_mat_date                   (,23)   edit
> DD/Mon/YYYY
> repo_rate                      (,36)   edit 99.99
> trade_price                    (,42)   edit 999.99
> on_date                                        (,51)           edit
> DD/Mon/YYYY
> off_date                       (,63)           edit
> DD/Mon/YYYY
> trade_id                       (,75)
> trade_type                     (,84)
> depository                     (,89)
> nominal                                        (,96)           edit
> 9,999.999
> sec_name                       (,107)
> market_price                   (,127)          edit 999.999
> bonds_amt                      &bonds_before_amt
> (,137)                 edit b9,999,999,999
> net_amt                + interest_amt
> &net_before_amt                                (,152)          edit 
b9,999,999,999
> bonds_amt + net_amt + interest_amt  &net_before_diff
> (,166)                 edit b9,999,999,999
> bonds_after_margin_amt
> &bonds_after_amt               (,182)                  edit 
b9,999,999,999
> cash_after_margin_amt + int_after_margin_amt &net_after_amt
> (,197)                 edit b9,999,999,999
> bonds_after_margin_amt + cash_after_margin_amt + int_after_margin_amt
> &net_after_diff                (,212)                  edit 
b9,999,999,999
>                add &bonds_before_amt    to #bond_before_tot
>                add &net_before_amt      to #net_before_tot
>                add &net_before_diff     to #net_diff_before_tot
>                add &bonds_after_amt     to #bond_after_tot
>                add &net_after_amt       to #net_after_tot
>                add &net_after_diff      to #net_diff_after_tot
> from           db_local..reporac
> order by nm_cpty_name, sort_type, trade_type, sec_mat_date, cusip
> END-SELECT
> END-PROCEDURE get_data
> BEGIN-PROCEDURE get_date
> BEGIN-SELECT
> dt_current                             &dt_current
> from concorde..concorde
> END-SELECT
> do date
> END-PROCEDURE get_date
> BEGIN-PROCEDURE date
> let $date = &dt_current
> END-PROCEDURE date
> BEGIN-PROCEDURE print_as_of_date
>                                do get_date
>                                print 'As of date: '
> (,202) bold
>                                print $date  (,216)
> edit DD-Mon-YYYY
> END-PROCEDURE print_as_of_date
> 
> BEGIN-PROCEDURE print_totals
> print '------------'                                   (+1,139)
> print '------------'                                   (,154)
> print '-----------'                            (,169)
> print '------------'                                   (,184)
> print '------------'                                   (,199)
> print '-----------'                            (,215)
> print #bond_before_tot
> (+2,137) edit 99,999,999,999
> print #net_before_tot                                  (,152) edit
> 99,999,999,999
> print #net_diff_before_tot                     (,167) edit
> 9,999,999,999
> print #bond_after_tot                                  (,182)  edit
> 99,999,999,999
> print #net_after_tot                                   (,197) edit
> 99,999,999,999
> print #net_diff_after_tot                      (,213) edit
> 9,999,999,999
> add #bond_before_tot                           to #grand_bond_before_tot
> add #net_before_tot                            to #grand_net_before_tot
> add #net_diff_before_tot               to #grand_net_diff_before_tot
> add #bond_after_tot                            to #grand_bond_after_tot
> add #net_after_tot                             to #grand_net_after_tot
> add #net_diff_after_tot                                to 
#grand_net_diff_after_tot
> move 0 to #bond_before_tot
> move 0 to #net_before_tot
> move 0 to #net_diff_before_tot
> move 0 to #bond_after_tot
> move 0 to #net_after_tot
> move 0 to #net_diff_after_tot
> END-PROCEDURE print_totals
> 
> BEGIN-PROCEDURE grand_print_totals
> print '============'                                   (+3,139)
> print '============'                                   (,154)
> print '============'                                   (,168)
> print '============'                                   (,184)
> print '============'                                   (,199)
> print '============'                                   (,214)
> print #grand_bond_before_tot
> (+2,137) edit 99,999,999,999
> print #grand_net_before_tot
> (,152)                 edit 99,999,999,999
> print #grand_net_diff_before_tot
> (,167)                 edit 9,999,999,999
> print #grand_bond_after_tot
> (,182)                 edit 99,999,999,999
> print #grand_net_after_tot
> (,197)                 edit 99,999,999,999
> print #grand_net_diff_after_tot
> (,213)                 edit 9,999,999,999
> END-PROCEDURE grand_print_totals
> 
Here was a non admissible message part of 'application/ms-tnef' MIME
type. It has been automatically discarded before sending the message to
the list. 





CONFIDENTIALITY NOTICE: This email message and any attachments are for the sole 
use of the intended recipient(s) and may contain proprietary, confidential, 
trade secret or privileged information.  Any unauthorized review, use, 
disclosure or distribution is prohibited and may be a violation of law.  If you 
are not the intended recipient or a person responsible for delivering this 
message to an intended recipient, please contact the sender by reply email and 
destroy all copies of the original
message.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
Prev by Date: [sqr-users] Monthly sqr-users Hints Posting
Next by Date: RE: [sqr-users] DB2 Optimizer question
Previous by thread: RE: [sqr-users] CURSOR error message when running SQR on Unix with readonly user
Next by thread: [sqr-users] Using On-Error=Skip
Indexes: [ Thread] [ Author] [ Date]
SQR-USERS List and Archive Info
SQRUG Home Page