[U2] Leaving U2 World to the Dark Side (SQL)

2009-02-19 Thread Don Verhagen
To those that know me on this group. I have been using the Unidata databases since 1998 when introduced to it by my former CIO. Over the years and throughout my IT career, it has served me well. Decreasing software production and maintenance costs, while at the same time increasing the value of

RE: [U2] Leaving U2 World to the Dark Side (SQL)

2009-02-19 Thread Brutzman, Bill
Don: Good luck in the new world. We will miss you... Follow-up U2/SQL comparison posts would be appreciated. --Bill -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Don Verhagen Sent: Thursday, February 19, 2009 6:04

Re: RE: [U2] Leaving U2 World to the Dark Side (SQL)

2009-02-19 Thread precisonline
Just remember Don, there's no place like home, there's no place like home --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Need help with SELECT limiting MV

2009-02-19 Thread Noah Hart
LIST FILE.NAME STATUS DATE 001A 02/18/2009 B C 02/18/2009 STATUS equals A, B, and C. There are DATEs for A and C, but not B. -- Louie In Seattle Yes, Louie understands the issue, I should have given an example before. The status and dates are

Re: [U2] accessing subrotines via IBM u2 Web Services Developer

2009-02-19 Thread Michael Rajkowski
Rich, First thing I would check is that your SOAP Service is not set to use connection pooling (check this by looking at the properties). Note that turning this off is a must, if you do not have connection pooling licenses on your system. While you are in the properties screen I would recommend

RE: [U2] Leaving U2 World to the Dark Side (SQL)

2009-02-19 Thread Tony G
Don Verhagen wrote I have accepted an Application Development management position with a company here in the Philadelphia area. However, they are not a U2 shop. I view this opportunity as a chance to build my skills in and around the .NET platform and evaluate the use MSSQL in a true

RE: [U2] Leaving U2 World to the Dark Side (SQL)

2009-02-19 Thread Address
Advertisement below. --- On Thu, 2/19/09, Tony G 1tlx6h...@sneakemail.com wrote: From: Tony G 1tlx6h...@sneakemail.com Subject: RE: [U2] Leaving U2 World to the Dark Side (SQL) To: u2-users@listserver.u2ug.org Date: Thursday, February 19, 2009, 3:55 PM Don Verhagen wrote I have accepted an

Re: [U2] Leaving U2 World to the Dark Side (SQL)

2009-02-19 Thread Dawn Wolthuis
Have fun with the new job, Don! Feel free to write back with any observations you think might be relevant. cheers! --dawn On Thu, Feb 19, 2009 at 5:04 AM, Don Verhagen u2-us...@southeast-florida.com wrote: To those that know me on this group. I have been using the Unidata databases since

RE: [U2] Leaving U2 World to the Dark Side (SQL)

2009-02-19 Thread Jeff Ritchie
Good luck Don, actually finding MSSQL pretty easy to use in a web application I am helping to develop. Excellent integration with MS's Visual Web Developer. If it makes you feel any better I am currently involved in a project to move a long term Unidata db to Oracle. Cheers, Jeff -Original

RE: [U2] Leaving U2 World to the Dark Side (SQL)

2009-02-19 Thread David Jordan
Whilst RDBMS allows easy direct manipulation of the database through products like .Net, the reality is that it is a nightmare if not thought out properly. If the business logic is in the client and you have a 1000 pcs, then a change to the business logic has to be sent out to 1,000 pcs at

Re: [U2] Need help with SELECT limiting MV

2009-02-19 Thread Jef - IT Vision
It seems to me that what you want to do may be in the too hard basket. I created a table called U2 that looks like: DICT U211:27:33am 20 Feb 2009 Page1 Field. Type Field... Conversion.. Column. Output Depth Name.. Field. Definition... Code

Re: [U2] Need help with SELECT limiting MV

2009-02-19 Thread MAJ Programming
BTW this is a 30+ year old issue and combining the fields has always been the answer. - Original Message - From: Noah Hart n...@lipmantpa.com To: u2-users@listserver.u2ug.org Sent: Tuesday, February 17, 2009 1:26 PM Subject: [U2] Need help with SELECT limiting MV I have a table with a