| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | What is most efficient way to compare a DB2 Timestamp field in COBOL on a
SELECT statement ?
WHERE EFF_TMST = '2007-10-16...
Richard Silvers
|
06-30-2009 08:34 PM
Serge Rielau  | 1 | 224 |
 | | I read the article here http://www.ibm.com/developerworks/db2/library/techarticle/0211yip/0211yip.html
But may be exists another way in db2 9.7 using...
noand24
|
06-30-2009 08:31 PM
Serge Rielau | 1 | 82 |
| | | Beauty and luxury traveling Site contain very much information about
airlines inclouds coutry wise
airlines companies informations and video see...
yaqub khan
|
06-29-2009 10:15 AM
yaqub khan | 0 | 82 |
| | | Hello,
According to the documentation, after running "DROP NOT NULL", a REORG
is required. This means, the "DROP NOT NULL" places the table status...
UDBDBA
|
06-29-2009 04:09 AM
Frederik | 3 | 83 |
| | | I want to join the group...
lyiash Ma
|
06-29-2009 02:03 AM
Kay Kanekowski | 3 | 97 |
| | | Shameless self promotion... :-)
www.ibm.com/software/data/db2/9/labchats.html#32
--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab
Serge Rielau
|
06-29-2009 01:46 AM
Serge Rielau | 4 | 81 |
| | | http://www.channeldb2.com/video/video/listForContributor?screenName=cc33n1i4zrsx
Enjoy
Serge
--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto...
Serge Rielau
|
06-26-2009 07:07 PM
Serge Rielau | 0 | 108 |
| | | Hi All,
This is my env:
DB2: 8.2
OS: AIX 6.4
Here are the series of steps executed:
1. login into the machine using instance id db2inst1 (This id...
satish mullapudi
|
06-26-2009 07:56 AM
Satish Mullapudi | 1 | 76 |
| | | Please, I need a course of tranning of db2 UDB in Latin America,
Someone know anything about it?
Thanks.
Jorge Magallanes
Gogue
|
06-25-2009 03:07 PM
Serge Rielau | 1 | 92 |
| | | Hi Folks,
I want to select 4 records selected for every value in col1 order by
desc of datecol.. For example,
I have table...
spider007
|
06-24-2009 02:35 AM
Spider | 3 | 78 |
| | | Hello,
I have installed DB2 on two servers (Centos and Debian) according to
article:
http://www.aulix.com/articles/install-db2-on-debian
It works...
sanyock
|
06-23-2009 04:46 AM
sanyock | 2 | 84 |
| | | One of my expectation for DB2 V9.7 was the subject issue.
I think that DB2 still does not support ISO SQL2003 Feature F281, LIKE
enhancements.
My...
Tonkuma
|
06-21-2009 11:52 AM
Tonkuma | 3 | 117 |
| | | Hello group,
we have the following SQL in our Cobolcode
EXEC SQL
SELECT
KNR
INTO :HV-KNR
FROM VST401R
WHERE KNR = :HV-KNR
michael.bierenfeld@web.de
|
06-19-2009 08:26 AM
Serge Rielau | 1 | 108 |
| | | Hi,
I am interested to use db2 governor. i am interested to see which
connections, applications run queries etc. for more than 2 hours but
do not...
db2admin
|
06-18-2009 02:32 PM
jagdip | 1 | 103 |
| | | Suppose there is a table that is partitioned by day on a date column, and
there is another index for the PK (that is unique across all partitions)...
JT
|
06-18-2009 10:35 AM
Serge Rielau | 1 | 188 |
| | | Hello,
Here's is the scenario:
Table: TEST1
Columns:
C1 Char (5) Not Null
C2 Char(8) Null
DB2-v789
|
06-17-2009 07:19 PM
jefftyzzer | 8 | 80 |
| | | Anyone know when 9.7 will be available on Passport Advantage?
Mark A
|
06-17-2009 10:49 AM
Serge Rielau | 1 | 95 |
| | | I have a large list of data consisting of an id number, an effective date,
and several fixed length strings. Each string consists of a list of...
Will Honea
|
06-16-2009 07:42 PM
Will Honea | 9 | 76 |
| | | Serge Rielau wrote:
<...>
It's not even announced yet on the 'labchats' page...
Without some more background on the exact subject (and what you are...
The Boss
|
06-16-2009 05:12 PM
Frank Swarbrick | 4 | 91 |
| | | I get that 0 designates success.
I also see the values 1,4, and 8 in my testing.
What are the return values that can be returned by the db2 command...
gimme_this_gimme_that@yahoo.com
|
06-16-2009 04:03 PM
gimme_this_gimme_that@yahoo.com | 2 | 98 |
| | | Despite some digging in the SQL Reference manual, I can not figure out
how to determine, for a given view (only known at run-time), the link
between...
Renaud Giot
|
06-16-2009 03:59 PM
Serge Rielau | 2 | 95 |
| | | Hi!
When I try to create a nickname on DB2 9.5,4 ESE that would point to Oracle
10g table I get:
SQL0901N The SQL statement failed because of a...
Gregor Kovač
|
06-16-2009 06:07 AM
Serge Rielau | 1 | 93 |
| | | We have migrated some db2 from v8 to v9.
Starting from v9, db2 has some background proess such as db2taskd.
When I list appliation and found the...
zgh1970
|
06-11-2009 02:49 PM
zgh1970 | 0 | 92 |
| | | I want to call a java UDF (or a stored procedure) from within an
Xquery which passes parameters to the UDF. Does DB2 support this and
is there any...
wendy.powley@gmail.com
|
06-11-2009 01:20 PM
Henrik Loeser | 1 | 140 |
| | | dba_fla (AT) yahoo (DOT) com wrote:
It's been many years since I used Delphi so my apologies if some of my
recollections are incorrect (I've tried...
Dave Hughes
|
06-11-2009 09:03 AM
Scav | 1 | 188 |
| | | Hi,
An user is connecting remotely from AS400 to AIX and trying to create
a package. He already has bindadd, implicit_schema and...
eliane
|
06-11-2009 08:55 AM
eliane | 0 | 100 |
| | | Hello,
I'm about to import some GIS data (x/y coordinates related to addresses)
into a DB2 v. 9.5 database.
The spatial extender has been installed...
Troels Arvin
|
06-10-2009 03:56 PM
Troels Arvin | 2 | 60 |
| | | I'm running a db2 script using this syntax:
db2 +c -td@ -vf runsql.db2
How do I modify the syntax so the script bails on error.
Note the...
gimme_this_gimme_that@yahoo.com
|
06-10-2009 02:27 PM
Lennart | 4 | 74 |
| | | I have a script that must *execute* without DB2 errors.
I need a construct that will allow me to check whether a table already
exists - and if it...
gimme_this_gimme_that@yahoo.com
|
06-10-2009 11:32 AM
gimme_this_gimme_that@yahoo.com | 2 | 80 |
| | | I'm running a DB2 9.5 Express C on Windows XP.
Sometimes, when using JDBC to connect to this box, I receive the...
Franco Lombardo
|
06-09-2009 03:31 PM
Ian | 1 | 96 |
| | | On Jun 4, 11:04*pm, Lennart <Erik.Lennart.Jons... (AT) gmail (DOT) com> wrote:
This is exactly what I was looking for, thanks Len.
Arun Srinivasan
|
06-08-2009 10:08 AM
Arun Srinivasan | 0 | 73 |
| | | Hi all,
I would like to learn/see all possible options / phrases that I can
use with an sql statement.
Below UPPER cased phrases are the examples...
mxb1c
|
06-04-2009 04:42 PM
jefftyzzer | 5 | 210 |
| | | On 4 Juni, 14:22, Serge Rielau <srie... (AT) ca (DOT) ibm.com> wrote:
Well, It is not critical, and I don't like the idea of mixing join
styles in...
Lennart
|
06-04-2009 08:59 AM
Lennart | 2 | 108 |
| | | Sumit wrote:
Try the Information Center:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp
Thanks,
Darin McBride
|
06-03-2009 08:04 AM
Darin McBride | 0 | 186 |
| | | Hi ,
Can some one let me know if we can restore a database backup taken on
64-bit instance on to a 32-bit instance. Please note that i am...
Gladiator
|
06-02-2009 08:52 AM
Darin McBride | 1 | 102 |
| | | Giants http://pearlcompany.ca/2009/06/its-definately-giants-seating-chart-for.html
- seating chart haven't seen this for a while
mike.swarski@gmail.com
|
06-01-2009 11:41 AM
mike.swarski@gmail.com | 0 | 69 |
| | | Hi!
I'm having problems to register a view on Replication Center 9.5. When
I try to register it, I receive the following error:
ASN1562E The...
Poma
|
05-29-2009 01:54 PM
Poma | 0 | 90 |
| | | Hello All;
I would not expect to need to do what I am asking about, but
developers and project leaders are asking for possibilities. I am
working...
cjshea@gov.pe.ca
|
05-28-2009 03:54 AM
bdh002 | 8 | 154 |
| | | Hello,
I'm running DB2 Express C on a Windows XP box.
In the application log I see lots of these messages:
ID: 4:
2009-05-24-01.01.27.926000 ...
Franco Lombardo
|
05-27-2009 02:29 AM
Franco Lombardo | 2 | 204 |
| | | I'm trying to find the syntax for SELECT FROM MERGE, but I can't see
anything. I need to get the number of rows inserted and updated. I'm
using DB2...
Ewa Bartosiewicz
|
05-26-2009 02:55 AM
Ewa Bartosiewicz | 0 | 96 |
| | | Hi all,
In an we need to retrieve/access other rows/
records within same table
The reference on the...
mxb1c
|
05-23-2009 12:54 AM
Lennart | 1 | 117 |
| | | I currently have the data in DB2 on ZOS. I am trying use a stored
procedure to perform a pagination logic as DB2 on Zos does not rownum
().
Please...
vj
|
05-22-2009 01:58 PM
jefftyzzer | 1 | 95 |
| | | I have a Cobol program with static SQL that references nicknames. The
precompile gives me the following warning:
SQL1179W The "PACKAGE" called...
Frank Swarbrick
|
05-22-2009 07:45 AM
Serge Rielau | 4 | 87 |
| | | From a remote control center I am unable to "discover" things on this
AIX server. Interactions with the DAS get the following response.
SQL22220N ...
Ray
|
05-22-2009 03:31 AM
Sivaswami Jeganathan | 4 | 169 |
| | | hello,
due to modify existing software
I have to write someexternel routines in C on sun machine,
I can succesfully combile and bind SO and BND...
Pan Piskorz
|
05-21-2009 12:04 PM
Ian | 3 | 133 |
| | | Hi,
In V9 of db2, tablespaces are created large by default and they can
hold more than 256 rows. I am wondering if we create all large
tablespaces...
db2admin
|
05-21-2009 07:05 AM
Serge Rielau | 2 | 98 |
| | | bculinp@prodbcuadmn01mgt:~/arun/year_of_service> db2 "select count(*)
from ccdb.year_of_service"
1
-----------
SQL0802N Arithmetic overflow or...
Arun Srinivasan
|
05-20-2009 05:02 AM
rahul | 2 | 116 |
| | | Is there a way to create a table that, for historical auditing
purposes, only allows records to be inserted into the table and does
not allow...
Mesan
|
05-18-2009 11:44 AM
Serge Rielau | 15 | 333 |
| | | Hi,
I load 100000 rows into table and then reorg, runstats to enable
compression. Then i load rest of the billion rows
Is there any other simpler...
db2admin
|
05-18-2009 10:47 AM
jagdip | 3 | 128 |
| | | Hi DBAs,
I have a very specific problem never faced. One of query is running
very slow and the reason is it is using one particular index. if...
sandeep.iitk@gmail.com
|
05-17-2009 10:58 PM
Lennart | 5 | 91 |
