?
Solved

Best way to read from Compact SQL table and write to AS400 DB2 table

Posted on 2005-03-28
7
Medium Priority
?
354 Views
Last Modified: 2012-06-27
I want to read all records in a sql table and insert them to an as400 DB2 table.  The sql table has 4 columns and the as400 table has 8 (the other 4 columns will be empty for now).  Thank you.
0
Comment
Question by:matt2door
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 13643970
there is no way of compacting SQL Server/ Oracle / DB2 tables.

it was a task needed to be done on .dbf files
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 13643980
One easy way to copy your data is to open 2 connections (1 for SQL and 1 for DB2). you read normally from SQL, loop through records and insert them into DB2.
0
 

Author Comment

by:matt2door
ID: 13644019
Is it possible to connect to the AS400 (db2 database) in the compact framework?  Sorry, that should have been my question.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 70

Expert Comment

by:Éric Moreau
ID: 13644150
are you able to connect using the regular framework? You may have a problem with the drivers that are only built for the full framework.

A workaround is to create a webservice that will be called from you PPC. Your webservice will insert the data.
0
 

Author Comment

by:matt2door
ID: 13644182
Do you have an example of a webservice program?
0
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 1000 total points
ID: 13644377
Use the WebService application template. It contains a HelloWorld method that is commented out. All the required attributes are already set. A method of a webservice is a regular method to which you add the <WebMethod()> attribute in front.
0
 

Author Comment

by:matt2door
ID: 13644944
Thank you.
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question