I want to add the obj_typ (U, FN, P, V, TR...) for the dependency ...

but I don't know how

I see, there is no short way...

30 years ago I write a cobol-parser in 6 weeks in programming langage "turbo pascal". But cobol was/is an easy language, and I was...

new thought: a kind of syntax-check

Example-Statement: delete from mytable

allowed characters between "delete" and "from" and "myTable" are only blanks, right?

If I erase the blanks in the definition, there must be...

...minefield is the right word:-)

@Eirikur: it doesn't work, because it returns also the "is truncate" when the Sp contained a truncate of a table, i'm not interessting in.

See my example...Your...

sorry, but I am looking for something different...

Your scripts only returns the depend SPs, but NOT the access-type.

I need both.

with "access-type" I mean:

does the SP contains a INSERT-statement and/or

...