Adam,
T-SQL is what is used with MS SQL. There are differences but a majority
of your DB2 SQL statements will work. Here is a link I frequently refer
to:
http://msdn.microsoft.com/en-us/library/ms189826.aspx. My biggest
gripe is the date/time handling in MS SQL.
Regards,
Pat Landrum
Senior Programmer/Analyst
Hanover County Public Schools
200 Berkley Street
Ashland, VA 23005
Email: plandrum@xxxxxxx
Phone: 804-365-4658 Fax: 804-365-4628
Never trust a computer you can't throw out a window - Steve Wozniak
Notice: This message or any accompanying documents may contain
confidential or privileged information of Hanover County Public Schools.
If you are not the intended recipient, disclosure, copying or
distribution is strictly prohibited by state and federal law. If you
received this message in error, please notify the sender as soon as
possible.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Wednesday, March 25, 2009 8:19 AM
To: Midrange Systems Technical Discussion
Subject: Re: SQL Differences
Your question doesn't make much sense to me.
Windows doesn't support SQL. So you'd be converting from i to MS SQL,
Oracle, DB2, MySQL, ect... the fact you may be running on Windows is
almost immaterial.
As to converting from SQL from i syntax to another...that really
depends on the destination.
Truth of the matter, the i sticks very close to the standards (haven't
I mentioned that to you specifically a couple of times already?) so
you'd probably got a good chance that little or no conversion would be
required for many statements. Particularly the simpler the statement.
If the job's a decent size, I'd look for a tool to help. I know IBM
offers a utility to convert MS SQL or Oracle statements into i syntax.
It's likely MS and/or Oracle or a third party have something similar
for going the other direction. Then again, maybe not as that would be
an acknowledgment that the i supports more than just RPG.
Charles
On Wed, Mar 25, 2009 at 8:03 AM, Adam West <adamster@xxxxxxxxx> wrote:
IF you had to be converting an application from the i to a windoze
box, how would you convert if any changes necessary to your SQL?
Assuming of course the files are mapped in some way. I am interested in
any major or minor issues you have noticed.
Thank you,
Adam
--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
midrange.com
