On 2/14/07, Martin Thorpe <[EMAIL PROTECTED]> wrote: > > Hello sorry for the SOT but does anyone use DB2? If so how does it differ > from > MySql, MSSql and Oracle 9i. The main thing I have been using is Oracle 9i > but I will need to be using DB2 soon. I was wondering if there are any > gotchas/big differences or will my SQL work pretty much. > > For instance Oracle uses sequences as opposed to MySql and MSSql auto > numbering. Anything like that in DB2? >
Martin, I access DB2 on a mainframe all the time here at Duke. There aren't that many differences in the SQL that I produce for DB2 versus the tables that we duplicate in SQL Server. Our version of DB2 doesn't support string concatentation with +, and there are a few functions that have different names... like "lower" versus "lcase"... "strip" vs "trim", etc. I usually avoid sequences and autonumbers for the very reason that they aren't particularly portable, so I'm not sure if DB2 has such a thing or not.. besides I don't actually build tables in DB2, just report off them. And we don't use stored procedures or triggers at all in the DB2 world so I couldn't really comment on those either. Rick -- I'm not certified, but I have been told that I'm certifiable... Visit http://www.opensourcecf.com today! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269832 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
