It's programmer error.
The view that I was shown, from the test system, was as I thought it was.
The production system, however, had a different view.
The production view would, under certain conditions, return a smaller selection
set for the view than for the table.
Now, we are arguing why
with SQLServer and VSAM using ViaSQL; good ol' batch processing mentality at
work here :-)
-Original Message-
From: owner-vs...@lehigh.edu [mailto:owner-vs...@lehigh.edu] On Behalf Of
Tom Duerbusch
Sent: Tuesday, June 16, 2009 1:38 PM
To: VSE Discussion List
Subject: DB2 Problem
I don't believe
this question on the DB2 listserv. You might get an answer
that is more to your liking.
-Original Message-
From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf
Of Tom Duerbusch
Sent: Wednesday, June 17, 2009 1:27 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: DB2 Problem
Subject: Re: DB2 Problem
Thanks all.
Interesting that everyone seems to suggest writing code to get around this
problem.
I would have thought that there would have been a DB2 method, which I didn't
know about, that would, in the same LUW, with a locked DBSPACE, given me the
same record
On Wed, 17 Jun 2009 13:27:17 -0500, Tom Duerbusch duerbus...@stlouiscity
.com wrote:
Thanks all.
Interesting that everyone seems to suggest writing code to get around th
is problem.
I would have thought that there would have been a DB2 method, which I di
dn't know about, that
would, in the
I don't believe that this is a DB2 Server code problem, just how I'm coding it,
is a problem G.
I have a table, that a process adds records to it.
On an hourly basis, I kick off a job that copies all the records in that table,
inserts them into another table, and then deletes all records in
: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Tom Duerbusch
Sent: Tuesday, June 16, 2009 1:38 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: DB2 Problem
I don't believe that this is a DB2 Server code problem, just how I'm
coding it, is a problem G.
I have a table, that a process
(ASN.ERSHIST_X) is not the same table that you
specify in the DELETE (ASN.CDERS_HISTORY).
Nora
-Original Message-
From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Tom Duerbusch
Sent: Tuesday, June 16, 2009 1:38 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: DB2
Operating System [mailto:ib...@listserv.uark.edu] On
Behalf Of Tom Duerbusch
Sent: Tuesday, June 16, 2009 2:14 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: DB2 Problem
ERSHIST_X is a view of table CDERS_HISTORY.
Tom Duerbusch
THD Consulting
Graves Nora E nora.e.gra...@irs.gov 6/16/2009 1:08 PM
Do you have the REXX SQL option available to you?
Bill
-Original Message-
From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf
Of Tom Duerbusch
Sent: Tuesday, June 16, 2009 10:38 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: DB2 Problem
I don't believe
Subject: DB2 Problem
I don't believe that this is a DB2 Server code problem, just how I'm
coding it, is a problem G.
I have a table, that a process adds records to it.
On an hourly basis, I kick off a job that copies all the records in that
table, inserts them into another table, and then deletes all
Sent: Tuesday, June 16, 2009 10:38 AM
To: IBMVM@LISTSERV.UARK.EDU
Subject: DB2 Problem
I don't believe that this is a DB2 Server code problem, just how I'm coding it,
is a problem G.
I have a table, that a process adds records to it.
On an hourly basis, I kick off a job that copies all
rxsql?
Bill
-Original Message-
From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf
Of Tom Duerbusch
Sent: Tuesday, June 16, 2009 12:55 PM
To: IBMVM@LISTSERV.UARK.EDU
Subject: Re: DB2 Problem
Perhaps.
This is on VSE which doesn't have REXX SQL from IBM. However
On Tue, 16 Jun 2009 14:13:03 -0700, Bill Pettit bi...@ormutual.com wrot
e:
ARI0801I DBS Utility started: 06/16/09 10:29:35.
AUTOCOMMIT = OFF ERRORMODE = OFF
ISOLATION LEVEL = REPEATABLE READ
-- CONNECT SYSA IDENTIFIED BY ;
ARI8004I User SYSA connected to server
14 matches
Mail list logo