By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,190 Members | 1,653 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,190 IT Pros & Developers. It's quick & easy.

Change column Data Type from Integer to Decimal

P: n/a
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).

Nov 29 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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).
Nov 30 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.