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. 1 2714
What is the statement that is failing?
B. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: rdraider |
last post by:
I'm doing a data conversion project, moving data from one SQL app to
another.
I'm using INSERT INTO with Select and have the syntax correct. But when
executing the script I get:
Server: Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to float.
Is it possible to change the data type during the INSERT INTO statement?
|
by: Adam |
last post by:
I am importing a table from Informix into Access XP via an ODBC
connection. In one of the fields, I will need it to allow 4000
characters. In Access help, it shows the data type can be changed to
"memo" and that will allow up to 65,535 characters. After importing
the table, I checked the data type and it automatically was set to
memo, but with the 255 character limitation. When I attempt to go
over 255, it will not allow it. Does...
|
by: John E. |
last post by:
I have a datagrid with one column that is boolean (it is a checkbox column).
So that myDataTable.Column..DataType.UnderlyingSystemType ==
System.Boolean. For printing purposes, I would like to change this from a
boolean to a string, so that I may manipulate the output to read "X" instead
of true, and "" for false. If I attempt to change the DataColumn type
currently, I get an error stating that I cannot change the type of a column
when...
|
by: manokumar |
last post by:
hiye, i notice that some if not all of my folders in winxp
pro. are set as read only and its giving me some problem
with development. so as the natural thing, i unchecked the
read only option and click apply then click ok. and when i
right click on the same folder again JUST TO MAKE SURE the
read only option is checked AGAIN. so again, unchecked,
and again its check and the cycle repeats. anyway, i'm the
administrator to this computer. so...
|
by: nyt |
last post by:
I have a problem of number and text field.
I got the database file(mdb) that contains many combo boxes used and
its list values are created by "value list"
For eg field
Field name= 'furniture' , data type='Number' ,Display Control='Combo
Box', RowSource Type = 'Value List' and
Row Source = ' 0;"chair";1;"Table";2;"Bed" '
Therefore, in data sheet view of table, if we select (1 : Table ) ,
| |
by: Henrootje |
last post by:
I have a lot of tables that hold a lot of numeric fields.
The names of all of these tables start with ' tblRO'
Now it turns out that all of the numeric fields with type double
precision have the property 'schaal' (<- dutch, the one above
'precision' ) set to zero. This should be '10' .
Is there a way to change this through VBA? Using a loop or so?
TIA Henro
|
by: balaki |
last post by:
Hi All,
I am using VB.Net 2003 and Ms-Access 2003. I want to change the data type of fileds programmatically. I could not find any method in vb.net to do this.
i) I tried using the sql query "ALTER TABLE TableName ALTER COLUMN FieldName Number" It works for data type like 'Number', 'Memo' etc. But if I want to change to 'Long Integer' (sub type of Number), it does not work.
ii) I tried using ADOX as shown below. It shows the 'Operation...
|
by: CDMAPoster |
last post by:
In:
http://groups.google.com/group/comp.databases.ms-access/msg/f06bd4c45037ef29
Lyle wrote:
:Terry Kreft wrote:
:
:>Suck it and See?
:
|
by: mlwerth |
last post by:
Dear Access Group:
This is the most basic and most embarrassing of questions, but I
cannot find where to change the data type of a text field that I have
in Access 2003 to a number field. I've searched high and low through
help databases and on the internet.
The directions say to :
Open the table in Design view
Click the Data Type column of the field you want to change, click the
|
by: thesti |
last post by:
hi,
i'm going to develop a program using VB .NET.
i've bound some textboxes to the same DataSource (DataSet1.Tables(0).
and i enable the user to type the primaryKey of the data in the Table, so if the user has typed an existing PK in the table, the position of the CurrencyManager will be changed. in the 'KeyUp' event of the ID textBox, i implement this code
Private Sub txtID_KeyUp(ByVal sender As Object, ByVal e As...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |