RE: replicate DB2 table to MS SQL -- MIDRANGE-L

Do not use DSPFFD. Query the SYSCOLUMNS table for the info you need.

Roger Harman
COMMON Certified Application Developer – ILE RPG on IBM i on Power

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Cunningham
Sent: Monday, November 20, 2017 6:02 PM
To: Midrange Systems Technical Discussion
Subject: RE: replicate DB2 table to MS SQL

We do have that and use it to get MS SQL data into RPG apps and I could see how that would be the underlying mechanism to execute the CREATE TABLE but I'm stuck on how to generate the CREATE TABLE command that replicates the DB2 table. I could probably do a DSPFFD to an output file and then build up the CREATE in DDL format that MS SQL likes but that also seems like it could get intense

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Monday, November 20, 2017 8:57 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: replicate DB2 table to MS SQL

Sure, look at Scott Klement's JDBC4 product. Free. Lets you run SQL statements from the IBM i and execute on the Sequel database.

On Mon, Nov 20, 2017 at 5:46 PM, Mike Cunningham <mike.cunningham@xxxxxxx>
wrote:

I have a need to replicate a DB2 table to MS SQL. I know I could
manually create the MS SQL table with the same column names and
attributes as the
DB2 table and then coy the data between the two systems but the DB2
tables in question change on a fairly frequent basis. A column is
added or dropped on average about once a week. (in reality its more
like 4 changes made one time a month but average is one a week). I
would prefer to just make the change to the DB2 table and have that
change automatically replicated to the MS SQL table. In my case I can
drop and recreate the MS SQL tables on every sync process so there
would be no need to do an ALTER TABLE on the MS SQL side. Does anyone
know of any utilities that might do this already so I don't need to grow my own utility?

Thanks
Mike Cunningham

________________________________
This email may contain confidential information about a Pennsylvania
College of Technology student. It is intended solely for the use of
the recipient. This email may contain information that is considered
an "educational record" subject to the protections of the Family
Educational Rights and Privacy Act Regulations. The regulations may be
found at 34 C.F.R. Part 99 for your reference. The recipient may only
use or disclose the information in accordance with the requirements of
the Federal Educational Rights and Privacy Act Regulations. If you
have received this transmission in error, please notify the sender
immediately and permanently delete the email.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD

________________________________
This email may contain confidential information about a Pennsylvania College of Technology student. It is intended solely for the use of the recipient. This email may contain information that is considered an “educational record” subject to the protections of the Family Educational Rights and Privacy Act Regulations. The regulations may be found at 34 C.F.R. Part 99 for your reference. The recipient may only use or disclose the information in accordance with the requirements of the Federal Educational Rights and Privacy Act Regulations. If you have received this transmission in error, please notify the sender immediately and permanently delete the email.