B4HANA SQL Script Execution

[lakshminarasimhan_n4]

Dear All,

We have the B4HANA system and given below are the detail, 

DW4CORE 200 0014 SAPK-20014INDW4CORE DATA Warehouse

Here i need to test some SQL Script and i am able to do it from DB02, but would like to know if there is any other way other than DB02 as this t-code or the "dbcockpit" tcode is not allowed in PRD B4HANA system. In such case we need the "SQL Editor" in PRD to test few scipts.

[Savio_Dmello]

From GUI, DB02 is the only option. Alternative, you have to navigate from HANA studio/ Eclipse to execute SQL queries directly against the HANA database.

In SAP HANA Studio/ Eclipse: Navigate to the SQL Console by right-clicking on your system connection and selecting "Open SQL Console."

In SAP HANA Database Explorer: Open SAP HANA Database Explorer through the SAP Business Technology Platform (BTP) or the SAP HANA Cloud platform. Connect to your HANA instance. Use the SQL console to run your SQL queries.