RE: replicate DB2 table to MS SQL

Thanks! I always forget about those being there. That would be an easy way
to get the structure.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Roger Harman
Sent: Monday, November 20, 2017 9:51 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: replicate DB2 table to MS SQL

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.
--
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.
--
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