Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Querying data on another db2 server
We have sort of a OLTP and datawarehouse set up on two different db2 servers. I have written a stored procedure that needs to query data from the other db. Oracle I do select * from table@servername SQL Server I select * from servername..table I know the db2 'servername' from the examples... -
CLP for DB2 Newbie / Oracle expert
This is the code in Oracle. Of course it could be a cursor as well, which I would expect it to be for DB2. Basically I want to do the equivalent of an anonymous block and tie a bunch of statements together without having a stored procedure. DECLARE TYPE tbl_Name IS TABLE OF... -
CLP for DB2 Newbie / Oracle expert
I am creating a script to update the DB to our newest version. In Oracle / MSQL it was easy with a script run from SQL*Plus / Query Analyzer. But I am having problems doing the same in DB2. Our installations group uses CLP and I cannot seem to create a 'block' to loop through the existing...
