Rating Thread / Thread Starter	Last Post	Replies	Views
Grant global select/insert/update/delete to all users I hope this isn't to simple of a question, but google/deja/DB2 doc have not given me an answer yet. In Oracle, we have the ability to grant select... Nate Jones via DBMonster.com	04-05-2005 07:09 AM Serge Rielau	6	75
Recursion not allowed for common table expressions error I am tring to execute the following SQL statements through the Iseries Navigator for DB2/V8.2, But i come up with an error saying recursion is not... Endif	04-04-2005 07:53 PM Endif	0	67
Recursion not allowed for common table expressions error I am tring to execute the following SQL statements through the Iseries Navigator for DB2/V8.2, But i come up with an error saying recursion is not... Endif	04-04-2005 07:52 PM Endif	0	63
DIA9999E with error code -32 I have a problem where DB2 is returning error 'DIA9999E An internal error occurred. Report the following error code : "error code -32"'. This is... RichG	04-04-2005 04:00 PM RichG	0	80
DB2 Qualified Table Name Problem with ODBC.NET Hello, I have written a utility in C# using ODBC.NET. It can fetch information from a ODBC supported database table and copy it to the other... Ali	04-04-2005 01:08 PM Ali	0	72
UDF functions interdependency. All: We have SQL User defined functions, which are calling other SQL User Defined functions. The database is residing on Windows 2000 box. When we... db2sysc@yahoo.com	04-04-2005 01:07 PM Serge Rielau	1	72
Column order of an Index Does the column order in an index matter? Currently i have an index with the columns in the following order: Type, Product_oid. If i create a new... cmitchell	04-04-2005 11:54 AM Serge Rielau	1	75
Version 7 Compatibility Please tell me if IBM DB2 Universal Database Version 7 can run on Windows Server 2003 (even if this configuration is not supported by... Hemo_jr	04-03-2005 03:19 AM Mark Yudkin	2	66
sqlj Command Doesn't Work ( 1 2 ) I am having an odd problem: the sqlj command on my system doesn't work. I am running DB2 (LUW) V8 (FP8) on WinXP. I haven't done an sqlj program... Rhino	04-02-2005 11:51 PM Rhino	12	179
DB2 UDB Enterprise Edition V7.1 License Question Hello: I have a question regarding my copy of DB2 Enterprise Edition 7.1 My business acquires used software fairly often. And we came across a copy... banyanhost@gmail.com	04-02-2005 08:03 PM Mark A	5	52
fixpak install but only on one instance Hi, I wish to install fixpak 11 on 8.1, On the machine we have 3 instances, but I only want to upgrade to fixpak 11 on one instance for the time... Peter Sands	04-02-2005 10:55 AM Darin McBride	2	70
Who knows the answer? I've got 3 tables table1 containing the field A en field B en C A en C always have a value, C sometimes C only has to be checked against table 4... Ron	04-02-2005 09:11 AM Philip Sherman	1	82
showing actual values in sql statement event monitor I've followed the instructions... brandon	04-01-2005 03:34 PM Erik Hendrix	2	94
More HADR thoughts Folks - Again, a three-peat: RH AS3, UDB 8.1.7 on one pair of x-series, 8.1.8 on 2 i86 test boxes... We were just about to put all we had into... bwmiller16@yahoo.com	04-01-2005 01:50 PM Jean-Marc Blaise	4	85
ignorant DB2 dilletante question: what's the syntax for a procedure... Hi all. Sorry for the basic question... What's the syntax for creating a procedure which simply returns a cursor for "select * from foo"? I am... Joe Weinstein	04-01-2005 10:32 AM Joe Weinstein	7	51
Tools db process foiling backups Running db2 8.1.1 on AIX 5.1 Recently created a Tools catalog and db on a test database server. Since then a shell script that runs the offline... datapro01@yahoo.com	04-01-2005 08:51 AM datapro01@yahoo.com	0	83
db2look in V8.2 All: I tried to run db2look on V8.2 DB for getting ALL the DLLS for the database. When I look into the output file, the SQL procedures code is... db2sysc@yahoo.com	04-01-2005 08:45 AM Hildo Biersma	8	117
Question on the design advisor Running DB2 8.1.1 on AIX 5.1 When I run the design advisor on selected sql I am getting 'recommendations' for indexes which already exist. I don't... datapro01@yahoo.com	04-01-2005 08:28 AM datapro01@yahoo.com	4	78
SQL22201N - I am unable to Proceed further All: This is becoming a big problem for us. Whenever we are using control center it asks for the userid/passwd and when we provide the... db2sysc@yahoo.com	03-31-2005 01:52 PM Rob Wilson	5	94
chnage use identity column to sequence I have a table with a column as identity. I don't know how can migrate a identity column to a normal column using sequence. Thnaks -- Message posted... edurne murgiondo via DBMonster.com	03-31-2005 10:35 AM Sean McKeough	2	47
Creating a database and filling data using scripts I have all the scrips to create a database. I have a few questions: 1- I am creating a batch file that it will call many lines like: db2 -td@ -f... serge	03-31-2005 09:37 AM Mark A	3	58
V8.2 SQL stored procedures implementation ( 1 2 ) Since V8.2 does not require a C compiler to build SQL stored procedures, I am just wonderring how they are now implemented internaly as opposed to C... efiryago@gmail.com	03-31-2005 01:52 AM Knut Stolze	16	131
SELECT outer join Hi, I appreciate if anyone can help me out, please. I have two tables; TableA and TableB. When the user enters the account, I match it against... tpthai@pepco.com	03-30-2005 06:19 PM Art S. Kagel	2	91
DB2 V7.1 DRDA environment TCPIP and DIST address space CPU usage high Hi,any one know ,in DRDA enviroment DB27.1 running in ZOS/E,I find when apllication program access DB2 through DB2connect ,in mainframe two... tony zheng via DBMonster.com	03-30-2005 06:10 PM cwahlmeier@data-tronics.com	1	63
UDB Migration from LUW - Mainframe DB2 Hi. We have UDB 8.2 on Windows and we want it to be migrated to V8 of DB2 on Mainframe. 1. Can a SQL FUNCTION contains SELECT statements in RETURN... db2sysc@yahoo.com	03-30-2005 04:42 PM Serge Rielau	3	82
Strange error in UDF I am trying to write a trigger/UDF combination that closely follows the example given in the following DeveloperWorks... Rhino	03-30-2005 03:28 PM Rhino	2	100
Concept Question re UDTs in UDFs I am trying to figure out if a UDF can accept a UDT (User-defined Distinct Type, not structured type) as one of its parameters. I'm running DB2... Rhino	03-30-2005 02:07 PM Serge Rielau	3	75
Who to Import PostGRESQL 7.2.2 database into Db2 7.2 Hi team Is there any easy way to Import PostGRESQL 7.2 which is on the Linux mechine to a DB2 UDB 7.2 on WIndows. What Options do i... Ugrasena via DBMonster.com	03-30-2005 12:30 PM Marco Rotondi	1	67
Error on data type Number(X, Y) with DB2 Connect v 7.01 Hi I'm using the ODBC driver DB2 Connect v 7.01.00.41. on Windows2000 to read from Hummingbird Genio on a IBM DB2 Database. I remark some errors on... Jacques	03-30-2005 07:34 AM Jacques	0	81
Need help missing log file I am migrating from AIX to Linux DB2 7.2 During cleanup I deleted an active log file. I am on log1540 and it says log 1541 is missing. It is. I do... Willard Farwark	03-30-2005 06:13 AM Fred Nurk	2	76
ODBC error Hello, When I try connect to AS400 Databases via Operation Navigator I get this message error: Token CALL was not valid. Valid tokens:... test	03-30-2005 06:11 AM test	0	117
Remote DB2 administration Hi guys, I had many troubles of finding a company who provides Remote Database Administration. I reviewed quite a lot of services and finally got... naufal@gmail.com	03-30-2005 02:17 AM Jurgen Haan	2	77
Can I pass a parameter from a stored procedure to a table function that is joining on other tables? I am trying to create a stored procedure that accepts 3 parameters. Using these parameters I am joining on 2 tables and a UDF that accepts these 3... jlficken@gmail.com	03-29-2005 04:49 PM Karl Hanson	2	95
ADO.NET Isolation Level I have been researching ADO.NET in order to train our programming staff. I am curious if someone would know what the default isolation level is with... cwahlmeier@data-tronics.com	03-29-2005 04:01 PM amurchis	1	86
DB2 & AIX or OpenPower 64-bit Platforms ? Hi, We are investigating the possible platform options for going to 64-bit ? Can anybody offer any links &or Judgements on the relative merits of... Paul Reddin	03-29-2005 03:49 PM kenfar	1	91
C# and db2app.dll Hi all, I try to execute the "sqledrpd" - Api. I found it in the db2app.dll renamed to sqledrpd_api, but my application crashes. Here's... Andy Meyer	03-29-2005 03:26 PM amurchis	1	130
sql help select a.component_id,a.coverage_prefix,a.coverage_code,md.prefix, md.se_id,md.se_rule, pd.ctr,pd.cov_pct,pd.cop_pct from db2inst1.bt a,db2inst1.msd... hikums@gmail.com	03-29-2005 01:39 PM hikums@gmail.com	0	147
Putting Auto Commit Off on the Server Hi team i am using DB2 7.2 on Windows2000. We have lot many SQL Procedure Calls, is there any way i can Turn off the Auto Commit on that Database,... Ugrasena via DBMonster.com	03-29-2005 01:05 PM Serge Rielau	7	106
Compile problems I have a stored procedure that is over 1000 + lines of code. When i try to compile I get the following error: ABC.TEST123: 1285: SQL0104N An... serge	03-29-2005 12:09 PM N. Shamsundar	9	128
IMPORT with REPLACE piveleges needed Can anyone confirm that the privelges needed to do an IMPORT with REPLACE have changed from 7.x to 8.x in DB2 UDB? I am finding the following... stabbert	03-29-2005 10:27 AM stabbert	2	89
No experiences with UDB 8.2 on Linux Suse We are going to have UDB-DB on Linux, with a 20 GB database, and have no experiences on this platform Which is the optimal - file system for the... global	03-29-2005 07:04 AM Jurgen Haan	1	84
QADBXREF authority - aliases creation Hi all, I have an issue with QSYS\QADBXREF file - it keeps aliases on tables. I take care of an application that works on many places (servers)... Krzysiek	03-29-2005 03:22 AM Krzysiek	0	85
SQL0104N on insert of consecutive NULLs I have a developer getting a SQL0104N on an insert statement. He is inserting a list of values into a table and instead of putting 'NULL' into the... Mark McNary via DBMonster.com	03-29-2005 01:00 AM Knut Stolze	2	102
7.2 client slower when connecting to 8.2 Hi I have 2 servers SERVER_A win 2000 UDB 7.2 db PRICE 14GB SERVER_B win 2003 UDB 8.2 db PRICE_V8 14GB(Restored from backup of PRICE on... Alex	03-28-2005 03:55 PM Serge Rielau	2	73
what is rowcount from UPDATE called in db2 cobol pgm? In a batch db2 cobol pgm, Do you know what the variable is called that holds the number of rows back from an sql operation such as a SELECT... mike tom via DBMonster.com	03-28-2005 02:04 PM Serge Rielau	3	110
functional dependencies from column correlation (querying here and c.d.t didn't turn up anything, so......) let's say you've got an existing table in an existing db. said table has a unique index... BobTheDatabaseBoy	03-28-2005 08:53 AM kenfar	7	87
MS SQL Profiler equivalent in DB2 8.2? What is the MS SQL Profiler equivalent in DB2 8.2? Thank you serge	03-28-2005 06:37 AM Data Goob	3	86
Keeping DDL's in sync Hi All: We're rolling out 3 DB2 (8.2 on LUW) platforms for branch offices, each of these are going to have the same schema. These are all going to... BarryS	03-27-2005 03:09 PM Bob [IBM]	7	86
Which tool to use when creating/compiling procedures? Is it good enough to use IBM DB2 8.2 SQL Development Center to create and compile procedures? Or a tool like Embarcadero's Rapid SQL is better? If... serge	03-27-2005 08:27 AM peteh	3	92
How to automate creating a database, tables, index, procedures...? What is the best way to run one command and have a database be created and sql scripts run on it to create the tables, indexes,... serge	03-26-2005 11:47 AM Larry	5	136

Page 151 of 238

151

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off