Implicit type conversion in DB/2 inserts?

Posted by IronGoofy on Stack Overflow See other posts from Stack Overflow or by IronGoofy
Published on 2010-06-09T11:49:34Z Indexed on 2010/06/09 11:52 UTC
Read the original article Hit count: 143

Filed under:

db2

|

type-conversion

We're using SQL Inserts to insert some data via a script into DB/2 tables, e.g.

CREATE TABLE TICKETS (TICKETID VARCHAR(10) NOT NULL);

On my home installation, this statement works fine (note that I'm using an integer which is autoatically cast into a VarChar):

INSERT INTO TICKETS (TICKETID) VALUES (1);

while at my customer's site I get a type error.

My question(s):

Is this behavior version dependent? (I use a DB2 Express V9.7, while the customer has an Enterprise V9.5)
Is there a config option to change the behavior? (I would like my home install to behave as close as possible as the production environment is going to be.)

© Stack Overflow or respective owner

Related posts about db2

link DB2 AS/400 (system i) and DB2 AIX

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, everybody. I have two different database in DB2, a in DB2 AS400 and other in DB2 AIX, is possible link this database, similar to link by Oracle? Thank you in advance. erva. >>> More
Speed-start your Linux App: Using DB2 and the DB2 Control Center

as seen on Internet.com - Search for 'Internet.com'
This article guides you through setting up and using IBM DB2 7.2 with the Command Line Processor. You'll also learn to use the graphical Control Center, which helps you explore and control your databases, and the graphical Command Center, which helps you generate SQL queries. Other topics covered… >>> More
DB2 LUW Security - The DB2 DBA as a Locksmith

as seen on Internet.com - Search for 'Internet.com'
Database security should have multiple locks at multiple layers with multiple keys (and perhaps some barbed wire, an electric fence, a moat and a mean junkyard dog as well). With all these locks and keys, some locksmith skills are certainly useful. Rebecca Bond introduces some of her favorite DB2… >>> More
Why can't Perl's DBD::DB2 find dbivport.h during installation?

as seen on Stack Overflow - Search for 'Stack Overflow'
We are using a Perl utility to dump data from DB2 database. We installed DBI package and it is asking for DBD package also. We dont have root access and when we try to install DBD package we are getting the following error: ERROR BUILDING DB2.pm [lijumathew@intblade03 DBD-DB2-1.78]$ make make[1]:… >>> More
DBI::DBD package not getting installed for Perl?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, We are using a Perl utility to dump data from DB2 database. We installed DBI package and it is asking for DBD package also. We dont have root access and when we try to install DBD package we are getting the following error. ERROR BUILDING DB2.pm [lijumathew@intblade03 DBD-DB2-1.78]$ make make[1]:… >>> More

Related posts about type-conversion

General type conversion without risking Exceptions

as seen on Stack Overflow - Search for 'Stack Overflow'
I am working on a control that can take a number of different datatypes (anything that implements IComparable). I need to be able to compare these with another variable passed in. If the main datatype is a DateTime, and I am passed a String, I need to attempt to convert the String to a DateTime… >>> More
javascript arrays and type conversion inconsistencies

as seen on Stack Overflow - Search for 'Stack Overflow'
I have been playing with javascript arrays and I have run into, what I feel, are some inconsistencies, I hope someone can explain them for me. Lets start with this: var myArray = [1, 2, 3, 4, 5]; document.write("Length: " + myArray.length + "<br />"); for( var i in myArray){ document.write(… >>> More
Automatic type conversion in Java?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a way to do automatic implicit type conversion in Java? For example, say I have two types, 'FooSet' and 'BarSet' which both are representations of a Set. It is easy to convert between the types, such that I have written two utility methods: /** Given a BarSet, returns a FooSet */ public… >>> More
Explicit Type Conversion and Multiple Simple Type Specifiers

as seen on Stack Overflow - Search for 'Stack Overflow'
To value initialize an object of type T, one would do something along the lines of one of the following: T x = T(); T x((T())); My question concerns types specified by a combination of simple type specifiers, e.g., unsigned int: unsigned int x = unsigned int(); unsigned int x((unsigned int())); Visual… >>> More
Error using traits class.: "expected constructor destructor or type conversion before '&' token"

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a traits class that's used for printing out different character types: template <typename T> class traits { public: static std::basic_ostream<T>& tout; }; template<> std::ostream& traits<char>::tout = std::cout; template<> std::wostream& traits<unsigned… >>> More