Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / December 2005

Tip: Looking for answers? Try searching our database.

how to change  the data type

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ravi - 01 Dec 2005 13:05 GMT
HI all, we r using db2 V 8.2, when i am trying to change data type ie.
SMALLINT to INTEGER(no data in the table),  iam getting  this error
messege. Pl. help me slove the error.

ERROR is

[IBM][CLI Driver][DB2/NT] SQL0443N  Routine "ALTOBJ" (specific name "")
has returned an error SQLSTATE with diagnostic text "SQL1013  Reason
code or token: dbname
".  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).  "

Thanks in Advance,

Ravi.
Brian Tkatch - 01 Dec 2005 14:00 GMT
What is the statement that is failing?

B.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.