Re: JDBC Connection properties for RDi Data Source Explorer

Jon, I wish it was that easy. We did modernize some files with a timestamp. But, they let the person doing the modernization go. So, they could hire more Microsoft people.

They replicate the data to Microsoft, where they have tools like MS SQL Studio Manager. I tried show them IBM Data Studio, and they tried it and called it "Not as good as Microsoft"...

It does not have the instant code assist like Microsoft...

DB2 is too different from MS sql, they have top 100 versus our Fetch first 100 rows only...

They connect strings with a "+" plus-sign, while in db2 you have to use a double bar: "||".

IBM I lacks good SQL tools like Microsoft, as they tell me...

They tried to access the data directly on the IBM I, but it was too slow from VB, Silerlight, C#, Javascript, HTML5, or whatever the coding language of the year is. I think they have done about 5 re-writes in a new Modern language of the year. To stay "current".

So, about a decade ago, they decide to replicate the data to MS SQL.

Too much time and money has been invested to go back...


-Ken Killian-

-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon Paris
Sent: Monday, November 6, 2017 2:38 PM
To: Wdsci-L <wdsci-l@xxxxxxxxxxxx>
Subject: Re: [WDSCI-L] JDBC Connection properties for RDi Data Source Explorer

This isn't Data Studio - no Mac version so I don't have that. The feature I need is not within the Studio bit anyway.

As to your SQL stuff - why not cast it to timestamps thorough a view/UDF/whatever and shut them up that way?


Jon Paris

www.partner400.com
www.SystemiDeveloper.com