Question Re: Calling Query Definition in Script in CLM 2.0 in Spend Management Q&A

Calling Query Definition in Script in CLM 2.0

Former Member — Tue, 14 Oct 2014 12:54:21 GMT

Hi All,

I am working on CLM 2.0. Would like to know if its possible to call query definition within script in CLM 2.0?

Thanks,

Saloni

Re: Calling Query Definition in Script in CLM 2.0

vikram_shanmugasundaram — Tue, 14 Oct 2014 13:18:26 GMT

Hi Saloni,

You could check by launching the Reference Guide >IAPI java docs and check if the classes below are listed. If they are, you should be good.

IapiPromptParamSetIfc

IapiQueryExecFactory

IapiQueryExecIfc

IapiQueryResultSetIfc

IapiQueryResultSetMetaDataIfc

You can also use the blog as a reference.

http://scn.sap.com/community/sourcing/blog/2012/08/08/query-iapis--a-good-alternative-for-dbhandle

Regards,

Vikram

Re: Calling Query Definition in Script in CLM 2.0

Former Member — Tue, 14 Oct 2014 16:26:25 GMT

Hi Vikram,

I have gone through the Blog. I didn't find these API's in Reference Guide. Is it possible to call query definition through DBHandle API?

Thanks,

Saloni

Re: Calling Query Definition in Script in CLM 2.0

vikram_shanmugasundaram — Wed, 15 Oct 2014 01:19:43 GMT

Hi Saloni,

DBHandle class is used to execute SELECT statements directly against the Sourcing database. We generally do not recommend using the DBHandle class because it requires using very specific coding protocols to ensure proper transaction management.

Please note, DBHandle class cannot be used to execute a Query Definition. Instead IapiQuery classes I had listed earlier should be used.

Hope this helps.

Regards,

Vikram

Re: Calling Query Definition in Script in CLM 2.0

Former Member — Wed, 15 Oct 2014 14:04:26 GMT

Hi Vikram,

I want to use query only to retrieve value from database. Can it still be bad to use DBHandle API?

Thanks,

Saloni