Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
drop procedure testx<< create procedure testx() LANGUAGE SQL BEGIN DECLARE TABLE x AS ( ordinal integer, nam VARCAHR(50), val(50), ); DECLARE SQLCODE INTEGER DEFAULT 0; DECLARE cursor CURSOR WITH RETURN TO CALLER FOR -- example of a possible variable input -- GetNVPairs(string) is my UDF which will parse the string into a table of (nam, val) pairs select * from TABLE(GetNVPairs('field_1:val_1|field_2:val_2x|field_3:val_3y')); -- want to do something like 'dynamically' insert into table_y ( field_1, field_2, field_3) values (val_1, val_2, val_3) -- but how? OPEN cursor; fetch cursor into x; while SQLCODE <> 100 do fetch cursor into x; end while; close cursor; END
|DB2 returns zero(0) count after repeated loading of millions of records...Any idea what is happening here?||3||249|
|datediff of ssrs||3||190|
|determine create date for a DB2 LUW Table||4||188|
|I am trying to building a ddl statement off a cobol layout||3||136|