Db/2 – Error – “SQL Error [42725]: Reference to routine was made without a signature, but the routine is not unique in its schema.. SQLCODE=-476”

Background Trying to manage a routine and ended up with the error listed below. Error Error Image Error Text Recreate Issue SQL Code Syntax Example Trouble Shooting Objective Let us determine the signatures for our referenced object, SYSPROC.SNAP_GET_DB. SQL Identify Routine Parameters Code Output Explanation ROUTINESCHEMA SYSPROC ROUTINENAME SNAP_GET_DB SPECIFICNAME SNAP_GET_DB SNAP_GET_DB_AP LANGUAGE C IMPLEMENTATION db2monudf!snap_get_db … Continue reading Db/2 – Error – “SQL Error [42725]: Reference to routine was made without a signature, but the routine is not unique in its schema.. SQLCODE=-476”

Db/2 LUW & DBeaver – Error – An error occurred during implicit system action type “2”

Background Trying to run Explain on a Db/2 query, but running into an error. Error Error Image Error Text Troubleshooting Unselected Text When we try to explain the Query without selecting the text we get the error pasted below: Image Text Remediation Select Text Please select the text you want explained and click the "Explain … Continue reading Db/2 LUW & DBeaver – Error – An error occurred during implicit system action type “2”

Dbeaver / Date Format

Background Quick follow-up to our last post on String Representation of datetime. Referenced Post BTW, that post is here: Db/2 – LUW – SQL Error [22007]: “The string representation of a datetime value is out of range” Link Goal In this post we will discuss options for displaying date columns in "locale" sensitive ways. Implementation … Continue reading Dbeaver / Date Format

Dbeaver :- Editor – Customization – “Statement Delimiter”

Background Got around to developing programmable objects, Stored Procedures and Functions, with DBeaver. Error Ran into an error as the routine, specifically function, got a bit more complex. Image Textual Trouble Shooting The error seems to be related to statements that span multiple lines such as : if/then/end if while do / end while   … Continue reading Dbeaver :- Editor – Customization – “Statement Delimiter”

DBeaver – Database Connection Configuration – IBM – DB2 / UDB JDBC Driver

Background As always coming back to DBeaver. This time to connect to a UDB Instance running on Linux. BTW, UDB means Universal Database. UDB JDBC Driver Artifacts DB2 JDBC Driver Versions and Downloads The URL for DB2 JDBC Drivers is Link. Here is a current snapshot. v11.1 FP0 ( GA ) We chose the v11 … Continue reading DBeaver – Database Connection Configuration – IBM – DB2 / UDB JDBC Driver