|
View previous topic :: View next topic
|
| Author |
Message |
jeyan883
New User
Joined: 26 Apr 2010
Posts: 17
Location: Chennai
|
|
|
|
Hi
I am getting -551 Error ( Authorization Failure )
but in SYSTSPRT Message Shows different one
TOKENS=DBTPIIM INSERT DBTPIIS.Tablename
Actually I am Accessing DBTPIIM Database but in the error message it is showing DBTPIIS.tablename ( I don't have access for DBTPIIS that's why it is showing -551 ) but why it is taking DBTPIIS how to find out ( there is no call statements in PGM , Listing also no where else DBTPIIS is used )
in PKG i have given the owner name as OWNER (DBTPIIM)
QUALIFIER (DBTPIIM)
Please kindly help .. Thanks in Advance [/quote][/quote] |
|
| Back to top |
|
 |
Ragav86
New User
Joined: 27 Jan 2010
Posts: 37
Location: chennai
|
|
|
|
| is the table available in DBTPIIM collection? |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
cobol program with imbedded sql? SP,
if cobol program - what does dbrm look like,
what are bind statements and output? |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
actually, what are you doing?
what is the sql?
if you are executing thru TMP (ikjeft...) what are the systin parms? |
|
| Back to top |
|
|
jeyan883
New User
Joined: 26 Apr 2010
Posts: 17
Location: Chennai
|
|
|
|
| Ragav86 wrote: |
| is the table available in DBTPIIM collection? |
Hi Ragav
Table is defined and data also available in the DBTPIIM Database but I am not aware about the Collection, I have created DBB, PKG , PRM Card in the Changeman to Promote this job.. Thanks |
|
| Back to top |
|
|
jeyan883
New User
Joined: 26 Apr 2010
Posts: 17
Location: Chennai
|
|
|
|
| dbzTHEdinosauer wrote: |
actually, what are you doing?
what is the sql?
if you are executing thru TMP (ikjeft...) what are the systin parms? |
Hi
Please find the below SYSTSIN Parameters
//SYSTSIN DD DSN=Changeman Program path
DSN SYSTEM(DB81)
RUN PROGRAM(Program name ) PLAN(Program name )
END
PKG Info
OWNER (DBTPIIM)
QUALIFIER (DBTPIIM)
MEMBER (Program Name )
Thanks for your reply |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| dbrm? |
|
| Back to top |
|
|
jeyan883
New User
Joined: 26 Apr 2010
Posts: 17
Location: Chennai
|
|
|
|
| dbzTHEdinosauer wrote: |
| dbrm? |
Hi
Query
Delete from tablename where Class Followed by Condition
DBRM Cretaed in the changeman DBR Path ( Compilation Success failed only during execution time )
my Doubt is why it is Showing
TOKENS=DBTPIIM DELETE DBTPIIS.PROG_MSR ? |
|
| Back to top |
|
|
jeyan883
New User
Joined: 26 Apr 2010
Posts: 17
Location: Chennai
|
|
|
|
| Ragav86 wrote: |
| is the table available in DBTPIIM collection? |
Hi
Pls find More info
Delete from Tablename ( that is alias not table )
Defined as table in DBTPIIS, alias in DBTPIIM Pls help |
|
| Back to top |
|
|
jeyan883
New User
Joined: 26 Apr 2010
Posts: 17
Location: Chennai
|
|
|
|
| dbzTHEdinosauer wrote: |
| dbrm? |
Hi
Any Updates I Can able to execute the query in Spufi that is working Fine
Delete/Update from DBTPIIM.aliasname where class Condition ( bcz I have all access for DBTPIIM)
but in program -551 is showing ( As i Said previously )
is it possible to do that operation through PGM ( I hope U understand the scenario
Defined as table in DBTPIIS and the same should be the alias in DBTPIIM ) |
|
| Back to top |
|
|
|
|
