Merritt Graves
unread,Sep 22, 2009, 3:32:55 PM9/22/09Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to dbfit
Hello, Is there an alternate way to get the parameter details of a
given procedure in DB2?
Inspect Procedure
--------------------------------------------------------------------------------
IBM.Data.DB2.DB2Exception: ERROR [42704] [IBM][DB2] SQL0204N
"SYSIBM.SYSROUTINEPARMS" is an undefined name. SQLSTATE=42704
at IBM.Data.DB2.DB2Command.a(CommandBehavior A_0, String A_1,
DB2CursorType A_2, Boolean A_3, Boolean A_4, Boolean A_5, Int32 A_6)
at IBM.Data.DB2.DB2Command.a(CommandBehavior A_0, String A_1)
at IBM.Data.DB2.DB2Command.ExecuteReader(CommandBehavior behavior)
at IBM.Data.DB2.DB2Command.ExecuteDbDataReader(CommandBehavior
behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at dbfit.DB2Environment.ReadIntoParams(String[] queryParameters,
String query, String addPrefix) in D:\work\dbfit\impl\dotnet\src
\environment\Db2Environment.cs:line 89
at dbfit.DB2Environment.GetAllProcedureParameters(String procName)
in D:\work\dbfit\impl\dotnet\src\environment\Db2Environment.cs:line 56
at dbfit.fixture.Inspect.InspectProcedure(Parse table) in D:\work
\dbfit\impl\dotnet\src\fixture\Inspect.cs:line 53
at dbfit.fixture.Inspect.DoTable(Parse table) in D:\work\dbfit\impl
\dotnet\src\fixture\Inspect.cs:line 33