Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
CREATE PROCEDURE RE39r (IN V_ID INTEGER, IN V_TYPE CHAR(2)) SPECIFIC RE39r DECLARE CUR1 CURSOR WITH RETURN TO CALLER FOR IF V_TYPE = 'CH' THEN select * from abc where id = V_ID; elseif V_TYPE = 'OM' THEN SELECT * FROM DEF WHERE ID = V_ID; ELSEIF V_TYPE = 'RI' THEN SELECT * FROM KLM WHERE ID = V_ID; END IF; OPEN CUR1; END P1
|OPENQUERY INSERT not recognizing linked server||12||529|
|How do identify a "break in coveage"||8||159|
|DB2 Integer to Decimal||1||109|
|Can I insert a row into a MS SQL table from a SQLRPGLE program?||5||109|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!