This is what I am trying to do: SELECT id, name FROM users WHERE isActive=true (AND CASE WHEN {param} != null THEN name={param} ELSE null E
I would like to have the list of stored procedure created in a certain database. I tried db2 "display procedure MyDb.*" But I get error DB21034E The comman
%sql select Name_of_School, Safety_Score from SCHOOLS where \ Safety_Score= (select MAX(Safety_Score) from SCHOOLS) i am trying to execute this query i got t
I am connected to IBM DB2 database with java but data is stored as binary format in database so when I fetch any value it comes as binary or hexdecimal format.
I click the button "Go to UI" and appears the following message: {"trace":"46b4bb4886e31314ef92057b01d07ffb","errors":[{"code":"iam_sqlid_error","message":"HWCS
--/ BEGIN FOR V AS MYCURSOR CURSOR FOR SELECT ID,NAME,AGE FROM PEOPLE DO BEGIN INSERT INTO PERSON(NAME,AGE) VALUES(V.NAME,V.AGE);