?
Solved

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

Posted on 2005-03-28
7
Medium Priority
?
356 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
  • 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Industry Leaders: 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!

Question has a verified solution.

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

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Suggested Courses

609 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