As a beginner to Teradata I am trying to pull down all sorts of metadata for our application. I am not having a problem with getting the proper Select to access all stored procedures of a data base, but my problem just lies in finding the parameters and returns types.
Than for each parameter, I was curious if there is some select to get access to the following.
You need dbc.ColumnsV:
SELECT * FROM dbc.columnsv
WHERE (DatabaseName, TABLENAME) IN
SELECT DatabaseName, TABLENAME
WHERE TableKind = 'P')