Calling Query Definition in Script in CLM 2.0

[Former Member]

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

[vikram_shanmugasundaram]

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

[Former Member]

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

[vikram_shanmugasundaram]

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

[Former Member]

Hi Vikram,

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

Thanks,

Saloni