CODEWITHSUNDEEP
sqlabapsap-basis
oceanlab1
oceanlab1

Reputation: 21

Saving SQL Queries in SAP

Hey guys I've written some SQL statements in SAP, I want to be able to save the code and run it when ever I need to. The SQL code either locks or unlocks specified users based on the UFLAG value entered. I'm fairly new to SAP/SQL and have no idea on how to actually save this small/simple script.

I used TCODE: db13 then navigated to the Diagnostics tab -> SQL Command Editor.

Any help would be appreciated, thanks!

Upvotes: 2

Views: 816

Answers (2)

user10909467
user10909467

Reputation: 1

In Eclipse(ADT) you can save them as favourites in SQL console. There is a downward arrow in RUN, click on the same will give you options to 'add to favourites', manage favourites etc.

Upvotes: 0

Oguz
Oguz

Reputation: 1926

As far as I know, sql scripts cannot be saved in the system. However, you can export to txt and import from txt file. enter image description here In my opinion, it is not a proper way to handle this at db layer. You should write a program and should use open sql statements.

Upvotes: 2

Related Questions