Change column Data Type from Integer to Decimal
in [DB2]
|
From: jmarr02s on 29 Nov 2006 12:00 I am trying to change my Amount column Data Type from Integer to Decimal (precision 9 digits, scale 3, that is 6 digits to the left of decimal and 3 digits to the right of decimal. Here is the error message I received SQL0443N Routine "SYSPROC.ALTOBJ" I sense this is a security issue, something my DBA must resolve and some aspect I do not have permission to do? Thanks, John [IBM][CLI Driver][DB2/AIX64] SQL0443N Routine "SYSPROC.ALTOBJ" (specific name "ALTOBJ") has returned an error SQLSTATE with diagnostic text "DBA7904, DBAD". SQLSTATE=38553 Explanation: An SQLSTATE was returned to DB2 by routine "<routine-name>" (specific name "<specific-name>"), along with message text "<text>". The routine could be a user-defined function or a user-defined method. User Response: The user will need to understand the meaning of the error. See your Database Administrator, or the author of the routine. Errors that are detected by the IBM supplied functions in the SYSFUN schema all return the SQLSTATE 38552. The message text portion of the message is of the form: SYSFUN:nn where nn is a reason code meaning: 01 Numeric value out of range 02 Division by zero 03 Arithmetic overflow or underflow 04 Invalid date format 05 Invalid time format 06 Invalid timestamp format 07 Invalid character representation of a timestamp duration 08 Invalid interval type (must be one of 1, 2, 4, 8, 16, 32, 64, 128, 256) 09 String too long 10 Length or position in string function out of range 11 Invalid character representation of a floating point number 12 Out of memory 13 Unexpected error Errors that are detected by the IBM supplied routines in the SYSIBM or SYSPROC schemas and IBM supplied procedures in the SYSFUN schema all return the SQLSTATE 38553. The message text portion of the message contains a message number that may be an SQLCODE, (for example, SQL0572N), a DBA error message (for example, DBA4747), or some other indication from the routine as to what error was encountered. Note that if the message for the message number would normally contain tokens, these token values are only available in the db2diag.log file. sqlcode : -443 sqlstate : (the SQLSTATE returned by the routine).
From: Phil Sherman on 29 Nov 2006 20:26 You guessed right - you don't have the authority to run SYSPROC.ALTOBJ. the key to this is the DBA7904 error. Try issuing the commands: db2 "? SQL0443" db2 "? DBA7904" to get information about the error messages. You'll need DBADM and LOAD authority to run ALTOBJ. Phil Sherman jmarr02s wrote: > I am trying to change my Amount column Data Type from Integer to > Decimal (precision 9 digits, scale 3, that is 6 digits to the left of > decimal and 3 digits to the right of decimal. > > Here is the error message I received SQL0443N Routine "SYSPROC.ALTOBJ" > > I sense this is a security issue, something my DBA must resolve and > some aspect I do not have permission to do? > > Thanks, > > John > > > [IBM][CLI Driver][DB2/AIX64] SQL0443N Routine "SYSPROC.ALTOBJ" > (specific name "ALTOBJ") has returned an error SQLSTATE with > diagnostic text "DBA7904, DBAD". SQLSTATE=38553 > > > > > Explanation: > > An SQLSTATE was returned to DB2 by routine "<routine-name>" > (specific name "<specific-name>"), along with message text > "<text>". The routine could be a user-defined function or a > user-defined method. > > User Response: > > The user will need to understand the meaning of the error. See > your Database Administrator, or the author of the routine. > > Errors that are detected by the IBM supplied functions in the > SYSFUN schema all return the SQLSTATE 38552. The message text > portion of the message is of the form: > > > SYSFUN:nn > > > where nn is a reason code meaning: > > > 01 Numeric value out of range > > 02 Division by zero > > 03 Arithmetic overflow or underflow > > 04 Invalid date format > > 05 Invalid time format > > 06 Invalid timestamp format > > 07 Invalid character representation of a timestamp duration > > 08 Invalid interval type (must be one of 1, 2, 4, 8, 16, 32, 64, > 128, 256) > > 09 String too long > > 10 Length or position in string function out of range > > 11 Invalid character representation of a floating point number > > 12 Out of memory > > 13 Unexpected error > > Errors that are detected by the IBM supplied routines in the > SYSIBM or SYSPROC schemas and IBM supplied procedures in the > SYSFUN schema all return the SQLSTATE 38553. The message text > portion of the message contains a message number that may be an > SQLCODE, (for example, SQL0572N), a DBA error message (for > example, DBA4747), or some other indication from the routine as > to what error was encountered. Note that if the message for the > message number would normally contain tokens, these token values > are only available in the db2diag.log file. > > sqlcode : -443 > > sqlstate : (the SQLSTATE returned by the routine). >
|
Pages: 1 Prev: Linked Server from MSSQL 2005 to iSeries Next: Audit Triggers |