Sure - why not?

Just hand edit every ocurrence of GETAPPELE_P to be the name you want for your SPROC. Also change the SELECT statement in the CREATE PROCEDURE to be the SELECT you are looking to do.

The USE STUFILES - should be USE {name of your db}

And if you don't do security through roles, get rid of the GRANT EXEC statement at the bottom.

Once you EXECUTE QUERY and the SPROCS is in your database, open a NEW QUERY window and put in that window just

Code:
EXEC {procedure name}
That will test run your SPROC...