Question Re: HANA mini checks SQL statement - INPUT parameters modification from Studio in Technology Q&A

HANA mini checks SQL statement - INPUT parameters modification from Studio

former_member201054 — Wed, 01 Jul 2020 23:28:19 GMT

Hi Experts,

How can I enter the desired date and time interval while executing the HANA mini checks SQL statement - "HANA Resources CPU And Memory History" from HANA studio. I would say modifying the INPUT parameters according to need.

There is one more statement " HANA_Threads_ThreadSamples_FilterAndAggregation_Rev74+_ESS" for which want to enter the desired date and time interval.

I would appreciate your reply with more details.

Thanks in advance

Re: HANA mini checks SQL statement - INPUT parameters modification from Studio

lbreddemann — Thu, 02 Jul 2020 01:06:36 GMT

To change the selection parameters in those scripts, you have to edit the SQL text.

Many statements have a "configuration section" where you can change the selection and the output options.

Note, that those are literal values, not SQL parameters and that there is no GUI input prompt for that.

Re: HANA mini checks SQL statement - INPUT parameters modification from Studio

VivekSahu — Thu, 02 Jul 2020 03:36:20 GMT

Hi Daniel,

All these SQL statements, have a /* Modification section */ , that enables you to choose certain user defined parameters. Do not change anything outside this section, and you will get the results accordingly.

Best Regards,
Vivek Sahu

Re: HANA mini checks SQL statement - INPUT parameters modification from Studio

former_member201054 — Thu, 02 Jul 2020 04:20:43 GMT

Hi Experts,

Should I not modify the Begin date and time & End date and time under the [ INPUT PARAMETERS] section in the SQL statement.?

...Please clarify

Re: HANA mini checks SQL statement - INPUT parameters modification from Studio

former_member201054 — Thu, 02 Jul 2020 04:21:47 GMT

Hi Experts,

Should I not modify the Begin date and time & End date and time under the [ INPUT PARAMETERS] section in the SQL statement.?

...Please clarify

Re: HANA mini checks SQL statement - INPUT parameters modification from Studio

former_member201054 — Thu, 02 Jul 2020 04:22:05 GMT

Hi Expert,

Should I not modify the Begin date and time & End date and time under the [ INPUT PARAMETERS] section in the SQL statement.?

...Please clarify

Re: HANA mini checks SQL statement - INPUT parameters modification from Studio

VivekSahu — Thu, 02 Jul 2020 04:28:51 GMT

INPUT parameters are just for your reference, like what can you use in /*Modification section*/ and in which format. Whatever changes or customization is expected, do it inside the /* Modification Section */ only.

Re: HANA mini checks SQL statement - INPUT parameters modification from Studio

dvankempen — Thu, 02 Jul 2020 08:47:34 GMT

Hi Daniel,

You ask a lot of questions. That is a good thing. Do make sure to tag properly. This question is about SAP HANA. Additional tags are not needed.

Make sure also to tag the correct answer as such and maybe visit some of your previous questions already answered? Thx

daniel.basis#content:questions

===

For the readers, before you leave, don't forget to up/down vote the answers. You can vote on the question too.

Thanks.

Re: HANA mini checks SQL statement - INPUT parameters modification from Studio

AtulKumarJain — Thu, 02 Jul 2020 13:39:39 GMT

Hi Daniel,

Yes,you can modify the begin date and time and end date time,so you can narrow down the search creteria and get most accurate result .

Best Regards,

Atul