Because its much faster in some cases, possibly by an order of magnitude > 10. Use what works best as the need dictates. BMC does direct sql stuff via jdbc with their SLM product.
Axton Grams On Fri, Sep 19, 2008 at 8:50 AM, Frank, Gordon M. (CMS/CTR) <[EMAIL PROTECTED]> wrote: > ** > > To be Frank, > > > > Why would you want to do this? > > > > In a secondary question, why did you purchase the Remedy ARS product, if you > are going to perform SQL anyways? > > > > The ARS and its 4.5 GL interface is a very good and eliminate the need to > perform manual SQL. I have yet to see a system which the ARS can not handle. > > > > Have you tried the ODBC interface? > > > > I see these types of posts all the time and I have to ask, "If you want a > low level SQL or API interface, why did you purchase BMC Remedy Action > Request System?" If built correctly, BMC Remedy ARS should save you in > "developer maintenance" costs. > > > > On another note and to be helpful rather than critical, if you are going to > update T Tables directly, you had better be very, very, very familiar with > the Database Reference. Version 7.1 has a Database reference called, "BMC > Remedy Action Request System 7.1.00 Database Reference." It can be found on > the BMC SupportWeb. > > > > Gordon M. Frank > > Lockheed Martin > > > > ________________________________ > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of manoj jain > Sent: Friday, September 19, 2008 8:26 AM > To: [email protected] > Subject: Re: Inserting data in the T table directly from the database. > > > > ** > > Hi, > > > > I have checked this in my side value is reflecting in my side fill all the > require field(Core field) > then try again . > > > > Bye, > > Manoj Jain > > > On 9/19/08, Anuj DUA <[EMAIL PROTECTED]> wrote: > > Hi, > > I am trying to insert data into T table directly from the database. I have > also inserted the values (ENTRYID) in the respective H table. But the data > is not getting reflected in the form. > > If anyone has any idea of this, pls share. > > > With Regards, > Anuj Dua > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
