Debugging Trick with SQL
I'm sure you have met this situation:
- There is a bug in a System that you can't reproduce yourself locally
- You need to run a few lines in the affected instance
- You get full access to System Management Portal
- But there is just no terminal, nor console, nor access with Studio, Atelier or VSCode
- How to run your few lines for testing ???
- Enter SMP / Explorer / SQL tab= Execute Query
- Now create a Stored Procedure with any Code you need
- There is no limit for complexity. I just do a simple one with a predictable result.
-
CREATE PROCEDURE RUN.ISOS() LANGUAGE OBJECTSCRIPT { For i=1:1:20 write i," > " Write "<br>THANKS !" }
- You click EXECUTE and see a new Procedure
- Next, you examine this fresh Procedure and execute it
- Another Execute activates it
- and this is the result
- and as a well-educated specialist, you clean up your environment when you are done
- DROP PROCEDURE RUN.ISOS
I hope that helps you at some future point in time.
Documentation