Inspect Procedure against DB2 throws exception?

45 views
Skip to first unread message

Merritt Graves

unread,
Sep 22, 2009, 3:32:55 PM9/22/09
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

Art

unread,
Sep 9, 2013, 3:46:58 PM9/9/13
to db...@googlegroups.com
I am getting the same error.  What was the resolution or workaround for this issue?
Reply all
Reply to author
Forward
0 new messages