Hi,
what would be the best way to transfert high volume data (100 tables,
500Meg each) between DB2/AS400 to Sybase?
Thanks Etienne.
Montreal
3  1913 
do a del-ascii export from db2 side
do a bcp import on sybase side
you will have to manually or through scripts, process the data for
things like timestamps, "-" instead of "NULL".
regards,
dotyet
Thank dotyet,
Do you know what kind of other exceptions I would need to check in the
data?
Does most of the datatype are compatible between db2 and sybase? Per
exemple, can varchar in db2 be higher than 255 characters? I know that
in sybase a varchar is limited to 255 chars.
Thanks,
Etienne
"dotyet" <do****@yahoo.c om> wrote in message news:<11******* *************** @z14g2000cwz.go oglegroups.com> ... do a del-ascii export from db2 side
do a bcp import on sybase side
you will have to manually or through scripts, process the data for
things like timestamps, "-" instead of "NULL".
regards,
dotyet
Etienne wrote: Thank dotyet,
Do you know what kind of other exceptions I would need to check in the
data?
Does most of the datatype are compatible between db2 and sybase? Per
exemple, can varchar in db2 be higher than 255 characters? I know that
in sybase a varchar is limited to 255 chars.
Thanks,
Etienne
"dotyet" <do****@yahoo.c om> wrote in message news:<11******* *************** @z14g2000cwz.go oglegroups.com> ...
do a del-ascii export from db2 side
do a bcp import on sybase side
you will have to manually or through scripts, process the data for
things like timestamps, "-" instead of "NULL".
regards,
dotyet
Check limits in Appendix A of the SQL Reference: http://publib.boulder.ibm.com/infoce...mstlimtabs.htm http://publib.boulder.ibm.com/infoce.../rzahgdref.htm
--
Karl Hanson This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Irmen de Jong |
last post by:
Hi,
Things like Twisted, medusa, etc.... that claim to be able
to support hundreds of concurrent connections because of the
async I/O framework they're based on....
can someone give a few examples of some web sites actually
using those Python frameworks?
Thanks :)
--Irmen
|
by: David Chaumeil |
last post by:
I have an ODBC link to DB2 Database. I can see the values of the DB2's
tables in Access but not in SQL Server DTS.
IN DTS, I connect the Source but when i want to see the values in the
Data transformation task, i have this message :
HResult of 0x90040e37 (-2147217865) returned. Erreur inattendue. Un
résultat d'erreur a été renvoyé sans message d'erreur.
Someone have a solution?
|
by: Niyazi |
last post by:
Hi,
I have to retrieve a data from AS400 DB2 and after working with data I have
to export into one of existing Excel file.
I can connect into specific library in AS400 DB2 using AS400 Client-Access
v5.2 program using (in VB.NET) ODBC driver (DSN Name …) . I can retrieve
datam work on it using VB.NET and I can send into 'NEW' Excel file.
My first problem starts here:
|
by: DrUg13 |
last post by:
In java, this seems so easy. You need a new object
Object test = new Object() gives me exactly what I want.
could someone please help me understand the different ways to do the
same thing in C++. I find my self sometimes, trying
Object app = Object();
Object *app = Object();
Object app = new Object();
|
by: Paul Say |
last post by:
I have a asp.net application that will need to create a document/report from
data in a database. The user will fill out a form supplying various criteria
for parameters. I would like the document/report to then be displayed on
screen as well as the option to download in PDF format.
I am just wondering which is the best reporting development tool to use
between SQL Reporting Services and Crystal Reports.
The report will have three...
| | |
by: Ron Mexico |
last post by:
I have written a graphing engine (very similar to what BigCharts.com
offers). Basically, it's an ASPX page that accepts parameters and calls
back-end business objects (dlls) to create a graph. When the graph is
created as a jpeg, it is returned to the browser as binary data. When it is
used at a low volume, it performs great and returns correctly drawn graphs
in a timely manner. However when the amount of traffic is increased to a
high...
|
by: Joel Hedlund |
last post by:
Hi all!
I use python for writing terminal applications and I have been bothered
by how hard it seems to be to determine the terminal size. What is the
best way of doing this?
At the end I've included a code snippet from Chuck Blake 'ls' app in
python. It seems to do the job just fine on my comp, but regrettably,
I'm not sassy enough to wrap my head around the fine grain details on
this one. How cross-platform is this? Is there a more...
|
by: =?Utf-8?B?RGFtZW9u?= |
last post by:
Hi -
I am attempting to write lines to a file at high volume, multiple threads.
Here is my scenario:
(initial "WriteToFile" object created via a parent multithreaded process,
which receives files, can call custom code for each file received - much like
BizTalk)
1. Receive multiple files, each file received creates a "WriteToFile" object
|
by: Ted |
last post by:
I have cross posted this to comp.lang.c++ and to sci.math.num-
analysis
in the belief that the topic is of interest to some in both groups.
I am building my toolkit, in support of my efforts in producing high
performance C++ code; code that is provably correct. The issue here
is orthogonal to the question of expression templates, which at
present seem to me to be relatively simple.
|
by: gitimaya |
last post by:
Hi,
I work in AS400 and UNIX platforms. Got a problem. I need to write a ftp application which would send a NON-AS400 file (IFS or flat file) from the AS400 box to the UNIX box. Can any one help me in this
Thanks And Regards
Geet
|
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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...
| |
