Hi,
We were in need of altering a DB2 table in which one of the column
has been changed from VARCHAR(256) to INTEGER. I have extracted the
table data into a tape before alters. After the alters was done, I am
reloading the data back into the table using IBM load utility. I
changed the load card from VARCHAR to INTEGER and loaded the table.
After loading, I could find that the data was not correct in the
table. The tape has a value of 3888537 where as the table has a value
of 521208. When I try INTEGER EXTERNAL in the load card, all rows were
getting discarded. Does any one have a solution for this?.
I am using DB2 version 6.1.
Thanks,
Balaji. 1 5451
What platform are you using, Windows? OS/390?
Rhino
"Balaji Neelakantan Pooruli" <pn******@yahoo .com> wrote in message
news:bd******** *************** ***@posting.goo gle.com... Hi,
We were in need of altering a DB2 table in which one of the column has been changed from VARCHAR(256) to INTEGER. I have extracted the table data into a tape before alters. After the alters was done, I am reloading the data back into the table using IBM load utility. I changed the load card from VARCHAR to INTEGER and loaded the table. After loading, I could find that the data was not correct in the table. The tape has a value of 3888537 where as the table has a value of 521208. When I try INTEGER EXTERNAL in the load card, all rows were getting discarded. Does any one have a solution for this?.
I am using DB2 version 6.1.
Thanks, Balaji. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Ray in HK |
last post by:
Will it be possible to specify the date format of type DATE during data
loading ?
|
by: Amir |
last post by:
Hi all,
I have a table called PTRANS with few columns (see create script below).
I have created a view on top that this table VwTransaction (See below)
I can now run this query without a problem:
select * from dbo.VwTransaction
where
|
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: Richard |
last post by:
I have been asked to copy a handfull of table spaces in to new
identical table spaces so that they can be accessed with out running
into the nightly batch update. I first did a FULLCOPY with SHARELEVEL
REFERENCE of the table space. Then I copied the DDL used to create the
original object and changed the table space name, table name, index
names and made sure that the priqty/secqty were adequate to hold the
data. I then created the objects...
|
by: Bill Stock |
last post by:
The few times in the past that I've loaded unbound data, I've tended to
cheat and use temp tables (not really unbound) or use code for small
datasets.
I'm currently involved in a project that has numerous tables in the 200
column range, with several thousand rows of data. A consulting review prior
to my involvement stressed the wasted space and database speed as the major
impetus for normalization. Although the db actually works fairly...
| |
by: Luis Esteban Valencia |
last post by:
Compilation Error
Description: An error occurred during the compilation of a resource required
to service this request. Please review the following specific error details
and modify your source code appropriately.
Compiler Error Message: CS0117: 'System.Data.DataTable' does not contain a
definition for 'WriteXml'
Source Error:
|
by: Vivek Khera |
last post by:
I have some historic data that I want to analyze. To do this I set up
postgres on a spare box I picked up for cheap, which just lucked into
having tons of RAM (1.5G). I set up postgres to use 10000 buffers,
and recompiled the kernel to allow 2Gb data size limit per process.
Since this is historical data, I'm actually merging a couple of dumps
that span the time range. I've dealt with eliminating any conflicting
data (ie, clashing...
|
by: DBQueen |
last post by:
I have a database where the user will have the opportunity to set up a
number of Tests. I want the user to be able to enter the equation if a
field for a particular test is to be a calculated value. This will be
entered into tblTests. There are 4 data fields in tblSamples (Data1,
Data2, Data3, Data4). When setting up a new test the user will fill in the
equation for any caluclated data fields into fields Calc1, Calc2, Calc3,
Calc4 in...
|
by: quantumlady |
last post by:
Hi, All.
I am working on a project with another student that will be used on Oracle, MySWL and DB2 databases. We have completed all the basic functions, but I would like to see if we can improve on one aspect of the code.
Scenario: There are 5 bank tables
private final String
tableList = {"account" , "branch", "customer", "depositor", "loan", "borrower"};
There is a string array for the table schemas
...
|
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: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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: 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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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...
| |