cancel
Showing results for 
Search instead for 
Did you mean: 

Running SQL -statement in BW

Former Member
0 Kudos

Hi,

Who knows a transaction code or a trick to run a SQL-statement in BW. I want to use this in order to check a Select statement used in a startroutine.

Can this be done via the application or should this statement be directly entered on the database

Greetings Floris

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Floris,

You can do it at database lvl if you have enough DB access.

Were you not able to acheive what u need thru the Debug mode? (simulate update of the datapackage with Debug on Update rules).

Regards,

Sree

Answers (1)

Answers (1)

Former Member
0 Kudos

Why not write a routine with the SQL statement? An quick way of doing it in a closed system like production is to do it in the routine in an InfoPack. Put a break-point before teh statement and hit the execute button of the Ipack. Processing will stop at the break-point and debug from there on.