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”

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”