RE: [sqr-users] SQR211A1 Package was not found

[Peter Burton <Peter_Burton@Hyperion.com>]

Murugesan,

Have somebody with DBA privileges on the database in question run an SQR
program against the database in order for SQR to create the proper packages
for it to run.  Or the DBA can issue the following command if they do not
want to run an SQR program:

        db2 connect to {database} [user {username} using {password}]
        db2 bind $SQRDIR/dbcalls.bnd grant public sqlwarn no collection sqr
        db2 terminate

After this is done anybody can run a report against that database.

Peter

> _____________________________________________ 
> From:
> sqr-users-bounces+peter_burton=hyperion.com@sqrug.org@HYPERION   On Behalf
> Of "Narayanaswamy Murugesan (Cognizant)" <Nmuruges@chn.cognizant.com>
> Sent: Wednesday, March 31, 2004 1:10 AM
> To:   sqr-users@sqrug.org
> Subject:      [sqr-users] SQR211A1 Package was not found
> 
> Hi,
> 
> I tried to run an SQR program which has a embedded sql in it.I have used
> DB2 UDB 8.1.0 Database.It throws following error
> 
> (SQR 5528) DB2 SQL PREPARE/DECLARE error -805 in cursor 20:
> SQL0805N  Package "SQR.SQR211A1 0X4941734345644B52" was not found.
> SQLSTATE=51002
> 
> Can anyone tell me that what could cause this issue ?
> 
> Thanks and Regards
> Murugesh
>  - InterScan_Disclaimer.txt << File: InterScan_Disclaimer.txt >> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> <http://www.sqrug.org/mailman/listinfo/sqr-users> 
> 
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. 
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users