How can i get a list of the current users connections made to access a DB2 data base? Is there any tables or resources avaiable to get this information in the form of a list of this users? Thanks a lot.

can anyone tell me where to get the db2cc guide?thanks

Do you have some SQL you want to improve, but you're not sure how? Erin Gannon Editorial Assistant

I need to know the version where I can find federated databases.

anyone know where I can get resources/samples on db2 triggers? What about workflow management with triggers?

Does DB2 have something like Oracle's CREATE DATABASE LINK?

During the week of October 29, we will be performing some site maintenanceon several areas of dev-archive, including discussion groups. A brief period ofdowntime may be unavoidable. If downtime occurs we will bring the groupsback online as quickly as possible. Thank you in advance for your patience....

Hopefully this is the right place to ask this question.I want to return a result set that has nothing to do with tables.In other DBMS's I can run the following select clause:select 'a','b'and get the following result set1 2-- --a bIs there a way to do something similar in...

I've got an existing vb app that will be accessing data on our frame in adb2 6.1 database. It does so via a data object in mts. The data object usesan odbc connection(The oledb provider is not an option because we are atmdac 2.1 sp2 and can't upgrade right now). The app server is running n...

I am very new to DB2 and will soon be writing some DB2 PL/SQL.The purpose of the PL/SQL will be to propagate data from one DB2 databaseto many others DB2 databases. In Oracle, you can create a "Link" which allowsyou to connect to other databases and perform data manipluation.Does DB2 have anything...

Oh Kay...I have a table on DB2 with 2 fields ID and Name. ID field in an Identityfield. When I add a new record to the Table (via ADO) I need to be ableto get the ID of the record I just added. The code below is and exampleof how I can do it in SQL Server. UDB returns 0 for the lID? Can anyone...

Is it possible to control individual records being cached in memory or staying on disk? Or is that a table-wide setting only? Thanks! - Jeramie Hicks

I've run into another problem with VB -> ADO -> UDB. Okay I open a recordset,selecting into it, and do a movelast (My program is restarting, so it looksat where the existing file ends, and compares it with the input file).MasterTB.Open "SELECT Symbol,Exchange,OEX100,ScanDate,ScanFlag,Opt...

Well I deserve a BIG kick in the ..., Although I guess maybe a better errormessage somewhere might have helped, but I feel pretty stupid.I forgot the IN keyword in the beginning of the stored proc.Thanks again, sometimes it just takes a little discussion.KlK, MCSE"kevin knudson" <klk@knudsons.com...

Thanks For Your Help. George.

hi all, May I ask query here how to get the concurrent user login information from DB2? Is there anyone exprerienced on this? Thank you, regards elvis

I'm new to DB2 and am having trouble calling stored procedures. When everI call one, I get the following error:NO PROCEDURE BY THE NAME XXX HAVING COMPATIBLE ARGUMENTS WAS FOUND.The XXX is what ever stored procedure I am trying to run. I've checked thatthe SP name and parameters are vali...

Hi! I Want To Know How Can I Use A Stored Procedure In VB6 (With ADO). I Don't Know How Can I Use The Parameters From The Stored Procedure. Any Advise? Thanks

hi all, May I ask query here how to get the concurrent user login information from DB2? Thank you, regards elvis

Well as I work through converting my SQL DB to UDB I continue to have StoredProcedure conversion problems. Several worked fine once I got the storedprocedure builder working.The next procedure, the core on in the system that Inserts all of the maindata, with a long list of parameters / fields (40)....

Hi, I wonder where can I find information of migration from Oracle RDBMS, Triggers, Stored Prcedures, PL/SQL, Forms ... To IBM's DB/2, Java Regards, Tal Rosenberger

We have several customers that are moving their data from SQL Server (a lot)and Oracle (a few) to DB2 systems. Some of these databases are in the multi-millionsof rows in size. The issue: SQL Server and Oracle allow the databases tobe installed as case in-sensitive, DB2 does *NOT*. IBM's sol...

HI all -I am using a visual basic application to manipulate data in anIBM DB2 FOR WINDOWS V 7.2 database using ADO 2.6. I am able to manipulatecolumns with all datatypes except CLOB/BLOB datatypes. I am using VB's getchunk/appendchunkfunctions. I get the error "Invalid Conversion".Has anyone...

What is the connectstring for connecting my VB object to db2. I cannot find this any where. Right now I am using odbc but need to switch to OLE DB.

Hi,I need to call a DB2 (version 6.2) stored proc on Mainframe from an AIX clientusing DB2 Connect. The client is a C++ application. I dont quite knowa)what libraries etc are required to compile and link my applicationb)what is the sequence of calls I need to make to call the stored procedurei.e fro...

I'm trying to access a DB2 database version 7 via Microsoft's Jet DB Engineusing DAO in a VC++ 6.0 program that's running in Windows 2000. The programwas able to open the database but when it tried to create a recordset, itis returning a message that says: The Microsoft Jet database e...

Hi,I'm a student in TLC engineering in Italy, 25 years old, and i'd like tolearn to use DB2! I'm new to DB2 and new or so to the database world! (Icreated some little database with Access...)! Please, can you tell where Ican init! There is free resource on the web that I ot look at: r...

Hi everyone, I hope someone can help me with my question. I have an applicationthat is written in Visual Basic and SQL Server. Recently we have been tryingto convert this App to DB2 UDB. The problem I am facing right now involvesthe DATETIME Value.Here is my SQL Statement:INSERT INTO EVENTTABLE V...

Hi, Is there any software or what is a preferable software to convert DB2 datatypes to SQL Server datatypes. THanks. Mark

Hi,I work with Visual C++6.0 SP5 under Windows 2000 SP2I have theis following problem to compile my project in visual c++6.0I want to connect to a db2 data source. If i attemp to compile my project,the following error message is display :------------------------f:\progra~1\sqllib\include\sqlext.h(16...

Does anyone have a sql script to generate a list of table & index sizes in UDB? thanks.

Hello, I'm using DB2 on Linux (RedHat 7.1) and I wish to connect to the database from a Java program. In Windows, I know to go to the control panel and define a DSN. How do I do this in Linux? Thanks, Jason Williams jwilliams@wc-group.com

Hi,I'm using DB2 v7.1 running on Win NT. I was able to use the Command Centerfrom the program popup menu. However, lately, the Command Center did notload although I had click on the Command Center menu item.Any ideas as how I can get this one back?Thanks,Tuan PhamP.S.: When I tried to double-cl...

is there anything comparable to the index tuning wizard of SQL Server in DB/2? Let me ask another way, is there any automated way for the db/2 database to analyze the type of commands that are being executed on the database and to create a list of suggested indexes? Wally

Iam trying to write SQL Stored Procs in UDB V7 Could someone tell me the steps to create and run a Stored Proc? TIA Ayub.

I am working on a PC application that is connecting to DB2 OS/390 using DB2Connect. When I installed the DB2 Connect client piece along with my appon a user machine, 3 different Sybase applications no longer work. Theyare getting connection errors. Anyone else ever run into this? Any lightyou ca...

We are currently assessing DB2 UDB and how it compares to Oracle specificallyon an IBM RS/6000 platform running AIX. Our application server is going tobe IBM's WebSphere and we'll be using JSP's to query the database. Just wonderingif anybody has experience with WebSphere on Oracle or...

I see on the ibm.com/db2 site that db2 7.2 has been released. i have download the personal developer edition. when i unzip the files, all the files are dated 4/22. Is that the correct date for the released copy of db2 7.2 for Windows? Wally

Is there a way through ADO parameters, a DLL, or 3rd party software to allow a user to change their password for DB2? Any help would be greatly appreciated THanks, Tim Burke

Hi,Following query was running sucessfully on AIX, WAS 3.02, DB2 6.1 butwhen we apply DB2 fixpack 6.1.6, it is showing a strange behaviour.The secound column (cat_tree.cat_id) is returning me the Hexadecimalvalue instead of a string. I checked that value by reading using aHexaEditor and it is showin...

First of all, I know absolutely nothing about db2. I am trying to find out if db2 has something like SQL Server DTS packages that could run an external application at a certain time. Thanks for any information.

Hi, I am new to DB2 and I want to know whether in DB2 it's possible to get active user connections thro' a SQL query. I'll appreciate any help!

Cusotmer is looking to add services and has decided DB2 will be the database.They have recently asked whether they should run it on their mainframe environmentor RS/6000 boxes. There is no preference for one or the other as both aresupported today. One comment was that DB2 is a processing hog on t...

Anybody have any experience with this?

I need to access to multiple databases (in the same instance), but I don't know dow do it. select a.*, b.* from db1.table1 a, db2.table2 b where .... db1 & db2 are in the same server and in the same instance. Regards. M. Ruiz

Hello all,I have been trying to compile a stored proc in db2 with no success for awhile now (i won't say how long, 'cause it is embarassing). I have done everythingby the book, but I can't get it to work. I use the MS VC++ 6.0 compiler.I keep getting the 42904 error (compiler path not...

I'm new to DB2 and need to invoke a stored procedure from an external process. Can I call the SP via a command-line interface (a la SQL Server), or do I need to do it through a SQL CALL command using the DB2 client? Kamal

Is it possible to use VB6 to load a DB2 table from a flat file via a db2 utility? Any code samples would be appreciated. My environment is Windows NT, DB2 7.1, VB6. Thanks in advance for any help. James

I can't insert file xml in db2 please tell me the method insert it. i use jsp. if there is source code about it please send to me. thank you very much

How I can use a data link data type if the file is in hard disk ?