DB2
in [SQL]
|
perl dbi built on DB2 8.2 does not run on 9.1 Our perl DBI is built on DB2 8.2. It runs fine on 8.2 However it does not run on 9.1. After the connect to the database, at the first SQL it gives this error "sql0818n A timestamp conflict occurred sqlstate 51003" Are we suppose to rebuild perl DBI for db2 in ver 9.1 ... 25 Jul 2008 15:34
Newbie question - this is highly unusal This is highly unusual. I do this only out of desperation. I am DB2 DBA on unix and recent had to take on Oracle admin as well. This question is really about Oracle export/import. Why I post here ( please allow me once ) because I posted at the other Google Oracle main group and it's surprising under-attended, ve... 25 Jul 2008 04:17
Purging task output Helpful folks, I have tasks defined in Task Center, on UDB V8.2 on Windows, that accumulate output at a rapid rate, and manually deleting them via the Journal is an arduous task. So to speak. Is it safe to simply run a job that deletes directly from this table using appropriate criteria? Would that take care o... 24 Jul 2008 18:03
DB2 UDB for z/OS V8 Sample Programs needed Hi, I am looking for the DSNTEP2 sample applications in DSN810.SDSNSAMP referred to in the DB2 UDB for z/OS Version 8 Application Programming and SQL Guide (SC18-7415) (see link below for manual). My company have not installed these manuals into the same naming convention I suspect and I cant find the sample ... 24 Jul 2008 06:43
calling SP from UDF Hello All. I developed a Stored Procedure for generic paging from any table. It is working fine: --#SET TERMINATOR ! CREATE PROCEDURE TAB_SEL_ANYPAGE(TNAME CHAR(20),PREDICATE VARCHAR(1000), N INTEGER,PAGE_NO INTEGER) LANGUAGE SQL READS SQL DATA RESULT SETS 1 S1 : BEGIN DECLARE SQL_CURS1 CHAR(200) ; ... 26 Jul 2008 08:55
How to get 'message text' portion of error from SP Jeff, You can also have ur exit handler capture the message_text instead and pass that out as an output parameter.. DECLARE EXIT HANDLER FOR SQLEXCEPTION get diagnostics exception 1 V_OUTPUT = message_text; -SA On Jun 20, 5:14 pm, Ian <ianb...(a)mobileaudio.com> wrote: jdokos wrote: On Jun 19, 9:19 ... 23 Jul 2008 17:25
Paging steadily increasing over time Background UDB 8.2, EEE, Lots of users, runing on AIX with an Switch 2, running QP, running datastage PX Here is the behavior we observe. Over time the paging on the AIX box steadily increases, very rarely there is a slight decrease. Even after a long period (1 hour+) of relative inactivity it doesn't go down. ... 29 Jul 2008 15:44
MQT on a nickname I need to create an MQT on a nickname, the requirement is that I need to transfer data from source to target when required (this is because the nickname is slow - i can't implement required indices on the source table - tooo large). So when I tried create table table1 as (select * from nickname) data initially de... 28 Jul 2008 15:08
PL/1 DB2 V8 Table Declaration for a CLOB Hi, I am writing a PL/1 program which will be reading a DB2 Table which has a column defined as a CLOB. Therefore, I should use DCLGEN to obtain accurate SQL DECLARE TABLE statements. However I do not have authority, at this company, to use DCLGEN and am trying to learn more about CLOBs, so trying to bypass any... 23 Jul 2008 11:14
PureXML Does PureXML use bufferpools for all the data stored? I am assuming that PureXML is faster than XML Extender at shredding data, but is not faster than relational (without LOB's) in cases where there are no XML documents (other than people trying to force a schema into an XML document). ... 23 Jul 2008 23:35 |