Hi Folks, Having just completed a migration from Sybase to Oracle, I can tell you from personal experience that direct SQL can pose some challenges:
- Literals... ""s are ok in Sybase, Oracle requires ''s. - Stored procedures... they "work" quite differently in Oracle with respect to returning results. This cost me much effort in my conversion. Although it was easier at the time to use direct SQL, I did end up converting many of the instances back to Remedy workflow when possible, even though I do not anticipate another data base platform change. :-) Hope this is helpful. Larry Larry Robinson [email protected] Office of Information Technology NC State University 919-515-5432 Voice Raleigh, NC 27695-7109 919-513-0877 FAX On Jun 2, 2010, at 10:07 AM, William Rentfrow wrote: > I've found a few rare instances where using direct SQL was the best way > to accomplish the task at hand. It is rare. > > When using direct SQL by far the biggest issue you're likely to run into > is having the "T" (B, H) table be wrong between systems. > > The steps below are pretty simple - when I did use direct SQL I always > did the following. > > 1.) Add field name T_table > 2.) First action executed was always a set fields that used direct SQL > to set the correct T-table # in the T_table field like... > > Select schemaid from arschema where name='HPD:Help Desk' > > From there on you just used "T"+T_table in your direct SQL calls. > > That way it was portable across systems, etc. If you take those steps > then direct SQL's downsides are mostly mitigated right from the start. > There are other implications of course (E.G., exporting workflow from an > Oracle database system to SQL Server database system) but the odds of > running into them are low. > > > William Rentfrow > Principal Consultant, StrataCom Inc. > [email protected] > Blog: www.williamrentfrow.com > O 715-592-5185 > C 715-410-8056 > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Matt Worsdell > Sent: Wednesday, June 02, 2010 8:51 AM > To: [email protected] > Subject: Re: ARERR 299 Too many levels in filter processing > > All valid points, however it is still a legitimate option and doesn't > necessarily mean a system is hard to manage. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
