Forum: IBM DB2

Hi there, The agent private memory depends upon various parameters, which are mostly deallocated when agent has terminated his job. However, I...

We have a User define Function that is invoked by many of our (100+) triggers. The UDF needs to change, but you can't drop it decause of the...

Hello , I am using DB2 7.2 Personal Edition on Windows NT Workstation 4.0. I need to write stored procedures for DB2. I have installed Application...

Hi All; I've been trying to put togther the current "best" architecture for a client who wants to replicate iSeries (latest version) data to DB2...

Hello, i am using DB2 SQL PRECOMPILER VERSION 7 REL. 1.0 on z/OS and i am getting an error whenever i try to precompile the following cobol...

The following is the program run from Microsoft ASP. SQL = "Select last_logon_ip, last_logon_time from db2admin.users where login_name='test'" ...

Hello, I am currently trying to execute SQL via JDBC to a DB2 database. I am trying to find a specific record(s) that match a specific date and...

Hi, Did you get your problem resolved? I also encountered the same problem about the subsequent recordsets having the same characteristics...

hi all, got a small problem here Running db/2 8.1 fp3 on a linux system. Tried to create a database called radius which seemed to work from the...

I am trying to create a DB under UDB 7.2 for OS/2 using a time-proven homemade REXX procedure. But all I get is a disk error SQL0980C. CREATE...

Hi all I am trying to access a database created on a linux system running db/2 8.1 fp3 from a windows gui running the same fp of 8.1 the db was...

I want to know that how to create a new user in DB2 database and set the password for it. Also, after set how to change the password. --...

Dear All, I porting my MS SQL stucture and those UDF to db2 v8.1. I using the IBM Migation tools to do it, all the stucture are migrate success...

Erik, Did you ever get to the bottom of your archArray problem ? The reason I ask is that we have an identical problem on one of our systems....

Hi ...I am using DB2 V7 on Z/os . I have a COPY utility using the LISTDEF AND TEMPLATE feature. There is a CHANGELIMIT(1)in the COPY statement. I...

Hi list, I've been working on Oracle and SQL for years, and we'll start support DB2 in the next few months, and I need to get DB2 installed in...

Hi, This seems like a very fundamental requirement to me, so I guess others have come up against it. We would like some triggers to behave in...

I wanted to install FP3 workgroup ed. on win2000 professional SP 4. I get the message "unable to access windows installer service" (translated from...

I have a table test.sub_chnl_ref which has the following structure: chnl_id | chnl_desc | sub_chnl_id | sub_chnl_desc |...

Hi all, I've been testing some code in Junits test in Netbeans against a DB2 8.1.2 DB Fixpak 3 server (Linux). Because each test is descrete the...