Db2 Duplicate Warning

[admin]

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users




Message









DocumentEmail



@font-face {
font-family: Tahoma;
}
@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt =
90.0pt; mso-header-margin: 35.4pt; mso-footer-margin: 35.4pt; =
mso-paper-source: 0; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
H1 {
FONT-WEIGHT: bold; FONT-SIZE: 14pt; MARGIN: 12pt 0cm 3pt; TEXT-INDENT: =
0cm; FONT-FAMILY: Arial; mso-bidi-font-size: 16.0pt; mso-pagination: =
widow-orphan; mso-style-next: Normal; mso-outline-level: 1; tab-stops: =
list 18.0pt; mso-font-kerning: 16.0pt
}
H2 {
FONT-WEIGHT: bold; FONT-SIZE: 12pt; MARGIN: 12pt 0cm 3pt; TEXT-INDENT: =
0cm; FONT-STYLE: italic; FONT-FAMILY: Arial; mso-bidi-font-size: 14.0pt; =
mso-pagination: widow-orphan; mso-style-next: Normal; mso-outline-level: =
2; tab-stops: list 18.0pt
}
H3 {
FONT-WEIGHT: bold; FONT-SIZE: 12pt; MARGIN: 12pt 0cm 3pt; TEXT-INDENT: =
0cm; FONT-STYLE: italic; FONT-FAMILY: "Times New Roman"; =
mso-bidi-font-size: 13.0pt; mso-pagination: widow-orphan; =
mso-style-next: Normal; mso-outline-level: 3; tab-stops: list 18.0pt; =
mso-bidi-font-family: Arial; mso-bidi-font-style: normal
}
P.MsoMessageHeader {
BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; =
PADDING-LEFT: 0cm; FONT-SIZE: 12pt; BACKGROUND: #cccccc; PADDING-BOTTOM: =
0cm; MARGIN: 0cm 0cm 0pt 2cm; BORDER-LEFT: medium none; TEXT-INDENT: =
-2cm; PADDING-TOP: 0cm; BORDER-BOTTOM: medium none; FONT-FAMILY: Arial; =
mso-pagination: widow-orphan; mso-fareast-font-family: "Times New =
Roman"; mso-shading: windowtext; mso-pattern: gray-20 auto; =
mso-border-alt: solid windowtext .75pt; mso-padding-alt: 1.0pt 1.0pt =
1.0pt 1.0pt
}
LI.MsoMessageHeader {
BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; =
PADDING-LEFT: 0cm; FONT-SIZE: 12pt; BACKGROUND: #cccccc; PADDING-BOTTOM: =
0cm; MARGIN: 0cm 0cm 0pt 2cm; BORDER-LEFT: medium none; TEXT-INDENT: =
-2cm; PADDING-TOP: 0cm; BORDER-BOTTOM: medium none; FONT-FAMILY: Arial; =
mso-pagination: widow-orphan; mso-fareast-font-family: "Times New =
Roman"; mso-shading: windowtext; mso-pattern: gray-20 auto; =
mso-border-alt: solid windowtext .75pt; mso-padding-alt: 1.0pt 1.0pt =
1.0pt 1.0pt
}
DIV.MsoMessageHeader {
BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: medium none; =
PADDING-LEFT: 0cm; FONT-SIZE: 12pt; BACKGROUND: #cccccc; PADDING-BOTTOM: =
0cm; MARGIN: 0cm 0cm 0pt 2cm; BORDER-LEFT: medium none; TEXT-INDENT: =
-2cm; PADDING-TOP: 0cm; BORDER-BOTTOM: medium none; FONT-FAMILY: Arial; =
mso-pagination: widow-orphan; mso-fareast-font-family: "Times New =
Roman"; mso-shading: windowtext; mso-pattern: gray-20 auto; =
mso-border-alt: solid windowtext .75pt; mso-padding-alt: 1.0pt 1.0pt =
1.0pt 1.0pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
P.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
LI.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
DIV.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
P {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
SPAN.EmailStyle15 {
COLOR: navy; mso-bidi-font-family: Arial; mso-style-type: =
personal-reply; mso-ansi-font-size: 10.0pt; mso-ascii-font-family: =
Arial; mso-hansi-font-family: Arial
}
DIV.Section1 {
page: Section1
}
OL {
MARGIN-BOTTOM: 0cm
}
UL {
MARGIN-BOTTOM: 0cm
}



Hi=20
all,
Im=20
trying to understand why im getting the error below.   There =
is only=20
one key in the table im trying to load thru Db2_APi . I checked out =
the=20
serogate key and i know there are no duplicates but i kept getting this =
warning=20
below.
 

DB2_UDB_API_47,0: Warning: =
DB2_UDB_API_47:=20
[IBM][CLI Driver][DB2/SUN64] SQL0803N One or more values in the INSERT=20
statement, UPDATE statement, or foreign key update caused by a DELETE =
statement=20
are not valid because the primary key, unique constraint or unique index =

identified by "1" constrains table "BDW.BSACT" from having duplicate =
rows for=20
those columns. SQLSTATE=3D23505
 
I have tried all sorts of things but =
it wont=20
stop.   Does anyone knows what could be going=20
on?

-----Original Message-----From:=20
datastage-users-bounces@oliver.com=20
[mailto:datastage-users-bounces@oliver.com]On Behalf Of David=20
BarhamSent: Thursday, February 05, 2004 3:09 =
AMTo:=20
DataStage Users Discussion ListSubject: RE: DataStage: =
Target Table=20
Names

Well,=20
I’m not sure about the ORAOCI9 stage, but the ORAOCI8 stage logs =
all the SQL=20
statements in the job log. =20
Hopefully, the ORAOCI9 stage does as well.  It might be a bit messy to =
parse, but=20
that would be one way to get the table names.  While you are at it, stage =
start/end=20
times and row counts are there =
too.
 
 
-----Original=20
Message-----From:=20
datastage-users-bounces@oliver.com=20
[mailto:datastage-users-bounces@oliver.com]On Behalf Of Timothy =
WalshSent: Thursday, 5 February 2004 =
6:58=20
PMTo:=20
datastage-users@oliver.comSubject: DataStage: Target =
Table=20
Names
 
DataStage=20
World,
 
Here=20
are our details:
DataStage: =

v6.1
OS: AIX=20
5.2
Staging=20
Repository: Oracle v9.2  (We use ORAOCI9 =
Stages)
 
My team=20
wants to start collect some jobs details about our ETL jobs and store =
them in=20
an DataStage Audit Table within our persistent staging area (In=20
Oracle)
For a=20
job we want to collect the following details:
1. Job=20
Name (Done)
2. Job=20
Target Table Name(s) !!!!!!
3. Job=20
Start Time (Done)
4. Job=20
End Time (Done)
 
How,=20
within a job (not a controller) or a routine, could I capture a target =
oracle=20
table name(s).... so that we can pass this information to =
the audit=20
table.  We know how to capture this data from job logs via a job=20
controller, but we are trying to embed this functionality within =
individual=20
jobs.
 
Please=20
let me know if I'm crazy.... or if you all need more=20
details.
 
Cheers,
 
Tim=20
Walsh

[admin]

QmFiYXR1bmRlLA0KdGhlIHN0YXRlbWVudCBpc3N1ZWQgdmlvbGF0ZWQgc29tZSBjb25zdHJhaW50
Lg0KIA0KVG8ga25vdyB3aGljaCB3YXMsIHN1Ym1pdCwgZm9yIGV4YW1wbGU6DQpzZWxlY3QgaW5k
bmFtZSwgY29sbmFtZXMgZnJvbSBzeXNjYXQuaW5kZXhlcyB3aGVyZSB0YWJuYW1lPSdCRFcuQlNB
Q1QnIGFuZCBpaWQ9MSwgdGhlIG51bWJlciBpbiB0aGUgbWVzc2FnZS4NCkdvb2QgbHVjaywNCkFs
ZXgNCgktLS0tLU1lbnNhZ2VtIG9yaWdpbmFsLS0tLS0gDQoJRGU6IEJhYmF0dW5kZS5FYm9ob24g
W21haWx0bzpCYWJhdHVuZGUuRWJvaG9uQHRhcmdldC5jb21dIA0KCUVudmlhZGE6IHF1aSAwNS8w
Mi8yMDA0IDE3OjU5IA0KCVBhcmE6IERhdGFTdGFnZSBVc2VycyBEaXNjdXNzaW9uIExpc3QgDQoJ
Q2M6IA0KCUFzc3VudG86IERiMiBEdXBsaWNhdGUgV2FybmluZw0KCQ0KCQ0KCUhpIGFsbCwNCglJ
bSB0cnlpbmcgdG8gdW5kZXJzdGFuZCB3aHkgaW0gZ2V0dGluZyB0aGUgZXJyb3IgYmVsb3cuICAg
VGhlcmUgaXMgb25seSBvbmUga2V5IGluIHRoZSB0YWJsZSBpbSB0cnlpbmcgdG8gbG9hZCB0aHJ1
IERiMl9BUGkgLiBJIGNoZWNrZWQgb3V0IHRoZSBzZXJvZ2F0ZSBrZXkgYW5kIGkga25vdyB0aGVy
ZSBhcmUgbm8gZHVwbGljYXRlcyBidXQgaSBrZXB0IGdldHRpbmcgdGhpcyB3YXJuaW5nIGJlbG93
Lg0KCSANCglEQjJfVURCX0FQSV80NywwOiBXYXJuaW5nOiBEQjJfVURCX0FQSV80NzogW0lCTV1b
Q0xJIERyaXZlcl1bREIyL1NVTjY0XSBTUUwwODAzTiBPbmUgb3IgbW9yZSB2YWx1ZXMgaW4gdGhl
IElOU0VSVCBzdGF0ZW1lbnQsIFVQREFURSBzdGF0ZW1lbnQsIG9yIGZvcmVpZ24ga2V5IHVwZGF0
ZSBjYXVzZWQgYnkgYSBERUxFVEUgc3RhdGVtZW50IGFyZSBub3QgdmFsaWQgYmVjYXVzZSB0aGUg
cHJpbWFyeSBrZXksIHVuaXF1ZSBjb25zdHJhaW50IG9yIHVuaXF1ZSBpbmRleCBpZGVudGlmaWVk
IGJ5ICIxIiBjb25zdHJhaW5zIHRhYmxlICJCRFcuQlNBQ1QiIGZyb20gaGF2aW5nIGR1cGxpY2F0
ZSByb3dzIGZvciB0aG9zZSBjb2x1bW5zLiBTUUxTVEFURT0yMzUwNQ0KCSANCglJIGhhdmUgdHJp
ZWQgYWxsIHNvcnRzIG9mIHRoaW5ncyBidXQgaXQgd29udCBzdG9wLiAgIERvZXMgYW55b25lIGtu
b3dzIHdoYXQgY291bGQgYmUgZ29pbmcgb24/DQoJCS0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0t
DQoJCUZyb206IGRhdGFzdGFnZS11c2Vycy1ib3VuY2VzQG9saXZlci5jb20gW21haWx0bzpkYXRh
c3RhZ2UtdXNlcnMtYm91bmNlc0BvbGl2ZXIuY29tXU9uIEJlaGFsZiBPZiBEYXZpZCBCYXJoYW0N
CgkJU2VudDogVGh1cnNkYXksIEZlYnJ1YXJ5IDA1LCAyMDA0IDM6MDkgQU0NCgkJVG86IERhdGFT
dGFnZSBVc2VycyBEaXNjdXNzaW9uIExpc3QNCgkJU3ViamVjdDogUkU6IERhdGFTdGFnZTogVGFy
Z2V0IFRhYmxlIE5hbWVzDQoJCQ0KCQkNCgkJV2VsbCwgSeKAmW0gbm90IHN1cmUgYWJvdXQgdGhl
IE9SQU9DSTkgc3RhZ2UsIGJ1dCB0aGUgT1JBT0NJOCBzdGFnZSBsb2dzIGFsbCB0aGUgU1FMIHN0
YXRlbWVudHMgaW4gdGhlIGpvYiBsb2cuICBIb3BlZnVsbHksIHRoZSBPUkFPQ0k5IHN0YWdlIGRv
ZXMgYXMgd2VsbC4gIEl0IG1pZ2h0IGJlIGEgYml0IG1lc3N5IHRvIHBhcnNlLCBidXQgdGhhdCB3
b3VsZCBiZSBvbmUgd2F5IHRvIGdldCB0aGUgdGFibGUgbmFtZXMuICBXaGlsZSB5b3UgYXJlIGF0
IGl0LCBzdGFnZSBzdGFydC9lbmQgdGltZXMgYW5kIHJvdyBjb3VudHMgYXJlIHRoZXJlIHRvby4N
CgkJIA0KCQkgDQoJCS0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQoJCUZyb206IGRhdGFzdGFn
ZS11c2Vycy1ib3VuY2VzQG9saXZlci5jb20gW21haWx0bzpkYXRhc3RhZ2UtdXNlcnMtYm91bmNl
c0BvbGl2ZXIuY29tXU9uIEJlaGFsZiBPZiBUaW1vdGh5IFdhbHNoDQoJCVNlbnQ6IFRodXJzZGF5
LCA1IEZlYnJ1YXJ5IDIwMDQgNjo1OCBQTQ0KCQlUbzogZGF0YXN0YWdlLXVzZXJzQG9saXZlci5j
b20NCgkJU3ViamVjdDogRGF0YVN0YWdlOiBUYXJnZXQgVGFibGUgTmFtZXMNCgkJIA0KCQlEYXRh
U3RhZ2UgV29ybGQsDQoJCSANCgkJSGVyZSBhcmUgb3VyIGRldGFpbHM6DQoJCURhdGFTdGFnZTog
djYuMQ0KCQlPUzogQUlYIDUuMg0KCQlTdGFnaW5nIFJlcG9zaXRvcnk6IE9yYWNsZSB2OS4yICAo
V2UgdXNlIE9SQU9DSTkgU3RhZ2VzKQ0KCQkgDQoJCU15IHRlYW0gd2FudHMgdG8gc3RhcnQgY29s
bGVjdCBzb21lIGpvYnMgZGV0YWlscyBhYm91dCBvdXIgRVRMIGpvYnMgYW5kIHN0b3JlIHRoZW0g
aW4gYW4gRGF0YVN0YWdlIEF1ZGl0IFRhYmxlIHdpdGhpbiBvdXIgcGVyc2lzdGVudCBzdGFnaW5n
IGFyZWEgKEluIE9yYWNsZSkNCgkJRm9yIGEgam9iIHdlIHdhbnQgdG8gY29sbGVjdCB0aGUgZm9s
bG93aW5nIGRldGFpbHM6DQoJCTEuIEpvYiBOYW1lIChEb25lKQ0KCQkyLiBKb2IgVGFyZ2V0IFRh
YmxlIE5hbWUocykgISEhISEhDQoJCTMuIEpvYiBTdGFydCBUaW1lIChEb25lKQ0KCQk0LiBKb2Ig
RW5kIFRpbWUgKERvbmUpDQoJCSANCgkJSG93LCB3aXRoaW4gYSBqb2IgKG5vdCBhIGNvbnRyb2xs
ZXIpIG9yIGEgcm91dGluZSwgY291bGQgSSBjYXB0dXJlIGEgdGFyZ2V0IG9yYWNsZSB0YWJsZSBu
YW1lKHMpLi4uLiBzbyB0aGF0IHdlIGNhbiBwYXNzIHRoaXMgaW5mb3JtYXRpb24gdG8gdGhlIGF1
ZGl0IHRhYmxlLiAgV2Uga25vdyBob3cgdG8gY2FwdHVyZSB0aGlzIGRhdGEgZnJvbSBqb2IgbG9n
cyB2aWEgYSBqb2IgY29udHJvbGxlciwgYnV0IHdlIGFyZSB0cnlpbmcgdG8gZW1iZWQgdGhpcyBm
dW5jdGlvbmFsaXR5IHdpdGhpbiBpbmRpdmlkdWFsIGpvYnMuDQoJCSANCgkJUGxlYXNlIGxldCBt
ZSBrbm93IGlmIEknbSBjcmF6eS4uLi4gb3IgaWYgeW91IGFsbCBuZWVkIG1vcmUgZGV0YWlscy4N
CgkJIA0KCQlDaGVlcnMsDQoJCSANCgkJVGltIFdhbHNoDQo=

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

[admin]

Is there a possibility of the duplicates being in the recordset you are
trying to load ? .. you can find out if this is the case by running a
select on the source data.

Thanks,
Bibhu

DW Engg, Rewards
503 220 3891 (PDX)



"Doreen Muller"
To: "DataStage Users Discussion List"
Sent by: cc:
datastage-users-bounces Subject: Re: Db2 Duplicate Warning
@oliver.com


02/05/2004 12:17 PM
Please respond to
"DataStage Users
Discussion List"

|-------------------|
| [ ] Secure E-mail |
|-------------------|





Check to see if you have any unique indexes on the table.



----- Original Message -----
From: Babatunde.Ebohon
To: DataStage Users Discussion List
Sent: Thursday, February 05, 2004 2:59 PM
Subject: Db2 Duplicate Warning

Hi all,
Im trying to understand why im getting the error below. There is only
one key in the table im trying to load thru Db2_APi . I checked out the
serogate key and i know there are no duplicates but i kept getting this
warning below.

DB2_UDB_API_47,0: Warning: DB2_UDB_API_47: [IBM][CLI Driver][DB2/SUN64]
SQL0803N One or more values in the INSERT statement, UPDATE statement, or
foreign key update caused by a DELETE statement are not valid because the
primary key, unique constraint or unique index identified by "1"
constrains table "BDW.BSACT" from having duplicate rows for those columns.
SQLSTATE=23505

I have tried all sorts of things but it wont stop. Does anyone knows
what could be going on?







===========================================================================
IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely
for the entity or individual to whom it is addressed. If you are not the
intended recipient, you should delete this message and are hereby notified
that any disclosure, copying, or distribution of this message is strictly
prohibited. Nothing in this email, including any attachment, is intended
to be a legally binding signature.



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

[admin]

SXMgdGhlIHRhcmdldCB0YWJsZSBlbXB0eT8gSWYgeW91IGRlc2lyZSAob3IgY2FuKSwgeW91IGNh
biBjaG9vc2UgdG8gY2xlYXIgdGhlIHRhYmxlIGJlZm9yZSBpbnNlcnRpbmcuDQogDQoJLS0tLS1N
ZW5zYWdlbSBvcmlnaW5hbC0tLS0tIA0KCURlOiBCYWJhdHVuZGUuRWJvaG9uIFttYWlsdG86QmFi
YXR1bmRlLkVib2hvbkB0YXJnZXQuY29tXSANCglFbnZpYWRhOiBxdWkgMDUvMDIvMjAwNCAxODo1
MCANCglQYXJhOiBEYXRhU3RhZ2UgVXNlcnMgRGlzY3Vzc2lvbiBMaXN0IA0KCUNjOiANCglBc3N1
bnRvOiBSRTogRGIyIER1cGxpY2F0ZSBXYXJuaW5nDQoJDQoJDQoJSSBjaGVja2VkIG91dCB5b3Ug
cXVlcnkgYW5kIHRoZSBvbmx5IGNvbHVtbiBvbiB0aGUgcmVzdWx0IGlzIHRoZSBjb2x1bW4gdGhh
dCBob2xkcyB0aGUgZ2VuZXJhdGVkIHNlcm9nYXRlIGtleS4gICBpIGtub3cgZm9yIGEgZmFjdCB0
aGF0IHRoZSBrZXkgaXMgbm8gZHVwbGljYXRlIGJlY2F1c2UgaSBldmVuIHNvcnRlZCBhbmQgcmVt
b3ZlIHRoZSBkdXBsaWNhdGVzLg0KCSANCglubyBvdGhlciBpbmRleGVzIGVpdGhlci4NCgkJLS0t
LS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCgkJRnJvbTogQWxleCBNYXJ0aW5zIFttYWlsdG86ZGF0
YXN0YWdlLXVzZXJzLWJvdW5jZXNAb2xpdmVyLmNvbV1PbiBCZWhhbGYgT2YgQWxleCBNYXJ0aW5z
DQoJCVNlbnQ6IFRodXJzZGF5LCBGZWJydWFyeSAwNSwgMjAwNCAyOjE1IFBNDQoJCVRvOiBEYXRh
U3RhZ2UgVXNlcnMgRGlzY3Vzc2lvbiBMaXN0DQoJCVN1YmplY3Q6IFJFUzogRGIyIER1cGxpY2F0
ZSBXYXJuaW5nDQoJCQ0KCQkNCgkJQmFiYXR1bmRlLA0KCQl0aGUgc3RhdGVtZW50IGlzc3VlZCB2
aW9sYXRlZCBzb21lIGNvbnN0cmFpbnQuDQoJCSANCgkJVG8ga25vdyB3aGljaCB3YXMsIHN1Ym1p
dCwgZm9yIGV4YW1wbGU6DQoJCXNlbGVjdCBpbmRuYW1lLCBjb2xuYW1lcyBmcm9tIHN5c2NhdC5p
bmRleGVzIHdoZXJlIHRhYm5hbWU9J0JEVy5CU0FDVCcgYW5kIGlpZD0xLCB0aGUgbnVtYmVyIGlu
IHRoZSBtZXNzYWdlLg0KCQlHb29kIGx1Y2ssDQoJCUFsZXgNCgkJCS0tLS0tTWVuc2FnZW0gb3Jp
Z2luYWwtLS0tLSANCgkJCURlOiBCYWJhdHVuZGUuRWJvaG9uIFttYWlsdG86QmFiYXR1bmRlLkVi
b2hvbkB0YXJnZXQuY29tXSANCgkJCUVudmlhZGE6IHF1aSAwNS8wMi8yMDA0IDE3OjU5IA0KCQkJ
UGFyYTogRGF0YVN0YWdlIFVzZXJzIERpc2N1c3Npb24gTGlzdCANCgkJCUNjOiANCgkJCUFzc3Vu
dG86IERiMiBEdXBsaWNhdGUgV2FybmluZw0KCQkJDQoJCQkNCgkJCUhpIGFsbCwNCgkJCUltIHRy
eWluZyB0byB1bmRlcnN0YW5kIHdoeSBpbSBnZXR0aW5nIHRoZSBlcnJvciBiZWxvdy4gICBUaGVy
ZSBpcyBvbmx5IG9uZSBrZXkgaW4gdGhlIHRhYmxlIGltIHRyeWluZyB0byBsb2FkIHRocnUgRGIy
X0FQaSAuIEkgY2hlY2tlZCBvdXQgdGhlIHNlcm9nYXRlIGtleSBhbmQgaSBrbm93IHRoZXJlIGFy
ZSBubyBkdXBsaWNhdGVzIGJ1dCBpIGtlcHQgZ2V0dGluZyB0aGlzIHdhcm5pbmcgYmVsb3cuDQoJ
CQkgDQoJCQlEQjJfVURCX0FQSV80NywwOiBXYXJuaW5nOiBEQjJfVURCX0FQSV80NzogW0lCTV1b
Q0xJIERyaXZlcl1bREIyL1NVTjY0XSBTUUwwODAzTiBPbmUgb3IgbW9yZSB2YWx1ZXMgaW4gdGhl
IElOU0VSVCBzdGF0ZW1lbnQsIFVQREFURSBzdGF0ZW1lbnQsIG9yIGZvcmVpZ24ga2V5IHVwZGF0
ZSBjYXVzZWQgYnkgYSBERUxFVEUgc3RhdGVtZW50IGFyZSBub3QgdmFsaWQgYmVjYXVzZSB0aGUg
cHJpbWFyeSBrZXksIHVuaXF1ZSBjb25zdHJhaW50IG9yIHVuaXF1ZSBpbmRleCBpZGVudGlmaWVk
IGJ5ICIxIiBjb25zdHJhaW5zIHRhYmxlICJCRFcuQlNBQ1QiIGZyb20gaGF2aW5nIGR1cGxpY2F0
ZSByb3dzIGZvciB0aG9zZSBjb2x1bW5zLiBTUUxTVEFURT0yMzUwNQ0KCQkJIA0KCQkJSSBoYXZl
IHRyaWVkIGFsbCBzb3J0cyBvZiB0aGluZ3MgYnV0IGl0IHdvbnQgc3RvcC4gICBEb2VzIGFueW9u
ZSBrbm93cyB3aGF0IGNvdWxkIGJlIGdvaW5nIG9uPw0KCQkJCSANCg==

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

[admin]

It appears that the data set(rows) you are inserting contains duplicates.
Try running the source query outside the datastage job and see if there are
any duplicates.

Thanks,
Madhu
DW Engineering
(503) 220-4740




Babatunde.Ebohon

t.com> cc:
Sent by: Subject: Db2 Duplicate Warning
datastage-users-bounces
@oliver.com


02/05/2004 11:59 AM
Please respond to
"DataStage Users
Discussion List"

|-------------------|
| [ ] Secure E-mail |
|-------------------|





Hi all,
Im trying to understand why im getting the error below. There is only one
key in the table im trying to load thru Db2_APi . I checked out the
serogate key and i know there are no duplicates but i kept getting this
warning below.

DB2_UDB_API_47,0: Warning: DB2_UDB_API_47: [IBM][CLI Driver][DB2/SUN64]
SQL0803N One or more values in the INSERT statement, UPDATE statement, or
foreign key update caused by a DELETE statement are not valid because the
primary key, unique constraint or unique index identified by "1" constrains
table "BDW.BSACT" from having duplicate rows for those columns.
SQLSTATE=23505

I have tried all sorts of things but it wont stop. Does anyone knows what
could be going on?


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of David Barham
Sent: Thursday, February 05, 2004 3:09 AM
To: DataStage Users Discussion List
Subject: RE: DataStage: Target Table Names

Well, I'm not sure about the ORAOCI9 stage, but the ORAOCI8 stage
logs all the SQL statements in the job log. Hopefully, the ORAOCI9
stage does as well. It might be a bit messy to parse, but that would
be one way to get the table names. While you are at it, stage
start/end times and row counts are there too.


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of Timothy
Walsh
Sent: Thursday, 5 February 2004 6:58 PM
To: datastage-users@oliver.com
Subject: DataStage: Target Table Names

DataStage World,

Here are our details:
DataStage: v6.1
OS: AIX 5.2
Staging Repository: Oracle v9.2 (We use ORAOCI9 Stages)

My team wants to start collect some jobs details about our ETL
jobs and store them in an DataStage Audit Table within our
persistent staging area (In Oracle)
For a job we want to collect the following details:
1. Job Name (Done)
2. Job Target Table Name(s) !!!!!!
3. Job Start Time (Done)
4. Job End Time (Done)

How, within a job (not a controller) or a routine, could I
capture a target oracle table name(s).... so that we can pass
this information to the audit table. We know how to capture
this data from job logs via a job controller, but we are trying
to embed this functionality within individual jobs.

Please let me know if I'm crazy.... or if you all need more
details.

Cheers,

Tim Walsh_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users




===========================================================================
IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely
for the entity or individual to whom it is addressed. If you are not the
intended recipient, you should delete this message and are hereby notified
that any disclosure, copying, or distribution of this message is strictly
prohibited. Nothing in this email, including any attachment, is intended
to be a legally binding signature.



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

[admin]

I have tried that too but i found no duplicates. none. This may sound funny but its the truth.

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
mxkanak@regence.com
Sent: Thursday, February 05, 2004 3:11 PM
To: DataStage Users Discussion List
Cc: DataStage Users Discussion List; datastage-users-bounces@oliver.com
Subject: Re: Db2 Duplicate Warning



It appears that the data set(rows) you are inserting contains duplicates.
Try running the source query outside the datastage job and see if there are
any duplicates.

Thanks,
Madhu
DW Engineering
(503) 220-4740




Babatunde.Ebohon

t.com> cc:
Sent by: Subject: Db2 Duplicate Warning
datastage-users-bounces
@oliver.com


02/05/2004 11:59 AM
Please respond to
"DataStage Users
Discussion List"

|-------------------|
| [ ] Secure E-mail |
|-------------------|





Hi all,
Im trying to understand why im getting the error below. There is only one
key in the table im trying to load thru Db2_APi . I checked out the
serogate key and i know there are no duplicates but i kept getting this
warning below.

DB2_UDB_API_47,0: Warning: DB2_UDB_API_47: [IBM][CLI Driver][DB2/SUN64]
SQL0803N One or more values in the INSERT statement, UPDATE statement, or
foreign key update caused by a DELETE statement are not valid because the
primary key, unique constraint or unique index identified by "1" constrains
table "BDW.BSACT" from having duplicate rows for those columns.
SQLSTATE=23505

I have tried all sorts of things but it wont stop. Does anyone knows what
could be going on?


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of David Barham
Sent: Thursday, February 05, 2004 3:09 AM
To: DataStage Users Discussion List
Subject: RE: DataStage: Target Table Names

Well, I'm not sure about the ORAOCI9 stage, but the ORAOCI8 stage
logs all the SQL statements in the job log. Hopefully, the ORAOCI9
stage does as well. It might be a bit messy to parse, but that would
be one way to get the table names. While you are at it, stage
start/end times and row counts are there too.


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of Timothy
Walsh
Sent: Thursday, 5 February 2004 6:58 PM
To: datastage-users@oliver.com
Subject: DataStage: Target Table Names

DataStage World,

Here are our details:
DataStage: v6.1
OS: AIX 5.2
Staging Repository: Oracle v9.2 (We use ORAOCI9 Stages)

My team wants to start collect some jobs details about our ETL
jobs and store them in an DataStage Audit Table within our
persistent staging area (In Oracle)
For a job we want to collect the following details:
1. Job Name (Done)
2. Job Target Table Name(s) !!!!!!
3. Job Start Time (Done)
4. Job End Time (Done)

How, within a job (not a controller) or a routine, could I
capture a target oracle table name(s).... so that we can pass
this information to the audit table. We know how to capture
this data from job logs via a job controller, but we are trying
to embed this functionality within individual jobs.

Please let me know if I'm crazy.... or if you all need more
details.

Cheers,

Tim Walsh_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users




===========================================================================
IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely
for the entity or individual to whom it is addressed. If you are not the
intended recipient, you should delete this message and are hereby notified
that any disclosure, copying, or distribution of this message is strictly
prohibited. Nothing in this email, including any attachment, is intended
to be a legally binding signature.



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

[admin]

What is your statement like ? Just Insert or Update/Insert ?

Thanks,
Madhu
DW Engineering
(503) 220-4740




Babatunde.Ebohon

t.com> cc: datastage-users-bounces@oliver.com
Sent by: Subject: RE: Db2 Duplicate Warning
datastage-users-bounces
@oliver.com


02/05/2004 01:13 PM
Please respond to
"DataStage Users
Discussion List"

|-------------------|
| [ ] Secure E-mail |
|-------------------|





I have tried that too but i found no duplicates. none. This may sound
funny but its the truth.

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
mxkanak@regence.com
Sent: Thursday, February 05, 2004 3:11 PM
To: DataStage Users Discussion List
Cc: DataStage Users Discussion List; datastage-users-bounces@oliver.com
Subject: Re: Db2 Duplicate Warning



It appears that the data set(rows) you are inserting contains duplicates.
Try running the source query outside the datastage job and see if there are
any duplicates.

Thanks,
Madhu
DW Engineering
(503) 220-4740




Babatunde.Ebohon


t.com> cc:

Sent by: Subject: Db2
Duplicate Warning
datastage-users-bounces

@oliver.com



02/05/2004 11:59 AM

Please respond to

"DataStage Users

Discussion List"


|-------------------|

| [ ] Secure E-mail |

|-------------------|






Hi all,
Im trying to understand why im getting the error below. There is only one
key in the table im trying to load thru Db2_APi . I checked out the
serogate key and i know there are no duplicates but i kept getting this
warning below.

DB2_UDB_API_47,0: Warning: DB2_UDB_API_47: [IBM][CLI Driver][DB2/SUN64]
SQL0803N One or more values in the INSERT statement, UPDATE statement, or
foreign key update caused by a DELETE statement are not valid because the
primary key, unique constraint or unique index identified by "1" constrains
table "BDW.BSACT" from having duplicate rows for those columns.
SQLSTATE=23505

I have tried all sorts of things but it wont stop. Does anyone knows what
could be going on?


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of David Barham
Sent: Thursday, February 05, 2004 3:09 AM
To: DataStage Users Discussion List
Subject: RE: DataStage: Target Table Names

Well, I'm not sure about the ORAOCI9 stage, but the ORAOCI8 stage
logs all the SQL statements in the job log. Hopefully, the ORAOCI9
stage does as well. It might be a bit messy to parse, but that would
be one way to get the table names. While you are at it, stage
start/end times and row counts are there too.


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of Timothy
Walsh
Sent: Thursday, 5 February 2004 6:58 PM
To: datastage-users@oliver.com
Subject: DataStage: Target Table Names

DataStage World,

Here are our details:
DataStage: v6.1
OS: AIX 5.2
Staging Repository: Oracle v9.2 (We use ORAOCI9 Stages)

My team wants to start collect some jobs details about our ETL
jobs and store them in an DataStage Audit Table within our
persistent staging area (In Oracle)
For a job we want to collect the following details:
1. Job Name (Done)
2. Job Target Table Name(s) !!!!!!
3. Job Start Time (Done)
4. Job End Time (Done)

How, within a job (not a controller) or a routine, could I
capture a target oracle table name(s).... so that we can pass
this information to the audit table. We know how to capture
this data from job logs via a job controller, but we are trying
to embed this functionality within individual jobs.

Please let me know if I'm crazy.... or if you all need more
details.

Cheers,

Tim Walsh_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users




===========================================================================
IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely
for the entity or individual to whom it is addressed. If you are not the
intended recipient, you should delete this message and are hereby notified
that any disclosure, copying, or distribution of this message is strictly
prohibited. Nothing in this email, including any attachment, is intended
to be a legally binding signature.



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users





===========================================================================
IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely
for the entity or individual to whom it is addressed. If you are not the
intended recipient, you should delete this message and are hereby notified
that any disclosure, copying, or distribution of this message is strictly
prohibited. Nothing in this email, including any attachment, is intended
to be a legally binding signature.



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

[admin]

Here is my statement

INSERT INTO bdw.bsact (BSACT_I,BSACT_TYPE_I,APPL_DATA_SRC_I,BSACT_ALTN_KEY_T,CRTE_TS,UPDT_TS,ETL_PRCS_C) VALUES (?,?,?,?,?,?,?);

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
mxkanak@regence.com
Sent: Thursday, February 05, 2004 3:21 PM
To: DataStage Users Discussion List
Cc: DataStage Users Discussion List; datastage-users-bounces@oliver.com
Subject: RE: Db2 Duplicate Warning



What is your statement like ? Just Insert or Update/Insert ?

Thanks,
Madhu
DW Engineering
(503) 220-4740




Babatunde.Ebohon

t.com> cc: datastage-users-bounces@oliver.com
Sent by: Subject: RE: Db2 Duplicate Warning
datastage-users-bounces
@oliver.com


02/05/2004 01:13 PM
Please respond to
"DataStage Users
Discussion List"

|-------------------|
| [ ] Secure E-mail |
|-------------------|





I have tried that too but i found no duplicates. none. This may sound
funny but its the truth.

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
mxkanak@regence.com
Sent: Thursday, February 05, 2004 3:11 PM
To: DataStage Users Discussion List
Cc: DataStage Users Discussion List; datastage-users-bounces@oliver.com
Subject: Re: Db2 Duplicate Warning



It appears that the data set(rows) you are inserting contains duplicates.
Try running the source query outside the datastage job and see if there are
any duplicates.

Thanks,
Madhu
DW Engineering
(503) 220-4740




Babatunde.Ebohon


t.com> cc:

Sent by: Subject: Db2
Duplicate Warning
datastage-users-bounces

@oliver.com



02/05/2004 11:59 AM

Please respond to

"DataStage Users

Discussion List"


|-------------------|

| [ ] Secure E-mail |

|-------------------|






Hi all,
Im trying to understand why im getting the error below. There is only one
key in the table im trying to load thru Db2_APi . I checked out the
serogate key and i know there are no duplicates but i kept getting this
warning below.

DB2_UDB_API_47,0: Warning: DB2_UDB_API_47: [IBM][CLI Driver][DB2/SUN64]
SQL0803N One or more values in the INSERT statement, UPDATE statement, or
foreign key update caused by a DELETE statement are not valid because the
primary key, unique constraint or unique index identified by "1" constrains
table "BDW.BSACT" from having duplicate rows for those columns.
SQLSTATE=23505

I have tried all sorts of things but it wont stop. Does anyone knows what
could be going on?


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of David Barham
Sent: Thursday, February 05, 2004 3:09 AM
To: DataStage Users Discussion List
Subject: RE: DataStage: Target Table Names

Well, I'm not sure about the ORAOCI9 stage, but the ORAOCI8 stage
logs all the SQL statements in the job log. Hopefully, the ORAOCI9
stage does as well. It might be a bit messy to parse, but that would
be one way to get the table names. While you are at it, stage
start/end times and row counts are there too.


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of Timothy
Walsh
Sent: Thursday, 5 February 2004 6:58 PM
To: datastage-users@oliver.com
Subject: DataStage: Target Table Names

DataStage World,

Here are our details:
DataStage: v6.1
OS: AIX 5.2
Staging Repository: Oracle v9.2 (We use ORAOCI9 Stages)

My team wants to start collect some jobs details about our ETL
jobs and store them in an DataStage Audit Table within our
persistent staging area (In Oracle)
For a job we want to collect the following details:
1. Job Name (Done)
2. Job Target Table Name(s) !!!!!!
3. Job Start Time (Done)
4. Job End Time (Done)

How, within a job (not a controller) or a routine, could I
capture a target oracle table name(s).... so that we can pass
this information to the audit table. We know how to capture
this data from job logs via a job controller, but we are trying
to embed this functionality within individual jobs.

Please let me know if I'm crazy.... or if you all need more
details.

Cheers,

Tim Walsh_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users




===========================================================================
IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely
for the entity or individual to whom it is addressed. If you are not the
intended recipient, you should delete this message and are hereby notified
that any disclosure, copying, or distribution of this message is strictly
prohibited. Nothing in this email, including any attachment, is intended
to be a legally binding signature.



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users





===========================================================================
IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely
for the entity or individual to whom it is addressed. If you are not the
intended recipient, you should delete this message and are hereby notified
that any disclosure, copying, or distribution of this message is strictly
prohibited. Nothing in this email, including any attachment, is intended
to be a legally binding signature.



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

[admin]

Is this job running in a splitter/combiner? If so does the combiner go
directly into the DB2 stage? If so try putting a transformer between
the splitter and the db2 stage.


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com] On Behalf Of
Babatunde.Ebohon
Sent: Thursday, February 05, 2004 1:23 PM
To: DataStage Users Discussion List
Subject: RE: Db2 Duplicate Warning


Here is my statement

INSERT INTO bdw.bsact
(BSACT_I,BSACT_TYPE_I,APPL_DATA_SRC_I,BSACT_ALTN_KEY_T,CRTE_TS,UPDT_TS,E
TL_PRCS_C) VALUES (?,?,?,?,?,?,?);

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
mxkanak@regence.com
Sent: Thursday, February 05, 2004 3:21 PM
To: DataStage Users Discussion List
Cc: DataStage Users Discussion List; datastage-users-bounces@oliver.com
Subject: RE: Db2 Duplicate Warning



What is your statement like ? Just Insert or Update/Insert ?

Thanks,
Madhu
DW Engineering
(503) 220-4740





Babatunde.Ebohon


t.com> cc:
datastage-users-bounces@oliver.com

Sent by: Subject: RE: Db2
Duplicate Warning
datastage-users-bounces

@oliver.com





02/05/2004 01:13 PM

Please respond to

"DataStage Users

Discussion List"



|-------------------|

| [ ] Secure E-mail |

|-------------------|







I have tried that too but i found no duplicates. none. This may sound
funny but its the truth.

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
mxkanak@regence.com
Sent: Thursday, February 05, 2004 3:11 PM
To: DataStage Users Discussion List
Cc: DataStage Users Discussion List; datastage-users-bounces@oliver.com
Subject: Re: Db2 Duplicate Warning



It appears that the data set(rows) you are inserting contains
duplicates.
Try running the source query outside the datastage job and see if there
are
any duplicates.

Thanks,
Madhu
DW Engineering
(503) 220-4740




Babatunde.Ebohon


t.com> cc:

Sent by: Subject: Db2
Duplicate Warning
datastage-users-bounces

@oliver.com



02/05/2004 11:59 AM

Please respond to

"DataStage Users

Discussion List"


|-------------------|

| [ ] Secure E-mail |

|-------------------|






Hi all,
Im trying to understand why im getting the error below. There is only
one
key in the table im trying to load thru Db2_APi . I checked out the
serogate key and i know there are no duplicates but i kept getting this
warning below.

DB2_UDB_API_47,0: Warning: DB2_UDB_API_47: [IBM][CLI Driver][DB2/SUN64]
SQL0803N One or more values in the INSERT statement, UPDATE statement,
or
foreign key update caused by a DELETE statement are not valid because
the
primary key, unique constraint or unique index identified by "1"
constrains
table "BDW.BSACT" from having duplicate rows for those columns.
SQLSTATE=23505

I have tried all sorts of things but it wont stop. Does anyone knows
what
could be going on?


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of David
Barham
Sent: Thursday, February 05, 2004 3:09 AM
To: DataStage Users Discussion List
Subject: RE: DataStage: Target Table Names

Well, I'm not sure about the ORAOCI9 stage, but the ORAOCI8 stage
logs all the SQL statements in the job log. Hopefully, the
ORAOCI9
stage does as well. It might be a bit messy to parse, but that
would
be one way to get the table names. While you are at it, stage
start/end times and row counts are there too.


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
Timothy
Walsh
Sent: Thursday, 5 February 2004 6:58 PM
To: datastage-users@oliver.com
Subject: DataStage: Target Table Names

DataStage World,

Here are our details:
DataStage: v6.1
OS: AIX 5.2
Staging Repository: Oracle v9.2 (We use ORAOCI9 Stages)

My team wants to start collect some jobs details about our
ETL
jobs and store them in an DataStage Audit Table within our
persistent staging area (In Oracle)
For a job we want to collect the following details:
1. Job Name (Done)
2. Job Target Table Name(s) !!!!!!
3. Job Start Time (Done)
4. Job End Time (Done)

How, within a job (not a controller) or a routine, could I
capture a target oracle table name(s).... so that we can
pass
this information to the audit table. We know how to capture
this data from job logs via a job controller, but we are
trying
to embed this functionality within individual jobs.

Please let me know if I'm crazy.... or if you all need more
details.

Cheers,

Tim Walsh_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users




========================================================================
===
IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended
solely
for the entity or individual to whom it is addressed. If you are not
the
intended recipient, you should delete this message and are hereby
notified
that any disclosure, copying, or distribution of this message is
strictly
prohibited. Nothing in this email, including any attachment, is
intended
to be a legally binding signature.



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users





========================================================================
===
IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended
solely
for the entity or individual to whom it is addressed. If you are not
the
intended recipient, you should delete this message and are hereby
notified
that any disclosure, copying, or distribution of this message is
strictly
prohibited. Nothing in this email, including any attachment, is
intended
to be a legally binding signature.



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

[admin]

Do you have Inter-Process row buffering turned on by any chance in the job?
Just ran into a situation with a job today that writes to Oracle but it may
apply: buffering on, it reported a single false Duplicate Key violation,
turn it off and all records loaded fine.

-craig

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com] On Behalf Of Shawn Ramsey
Sent: Thursday, February 05, 2004 3:28 PM
To: DataStage Users Discussion List
Subject: RE: Db2 Duplicate Warning


Is this job running in a splitter/combiner? If so does the combiner go
directly into the DB2 stage? If so try putting a transformer between
the splitter and the db2 stage.


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com] On Behalf Of
Babatunde.Ebohon
Sent: Thursday, February 05, 2004 1:23 PM
To: DataStage Users Discussion List
Subject: RE: Db2 Duplicate Warning


Here is my statement

INSERT INTO bdw.bsact
(BSACT_I,BSACT_TYPE_I,APPL_DATA_SRC_I,BSACT_ALTN_KEY_T,CRTE_TS,UPDT_TS,E
TL_PRCS_C) VALUES (?,?,?,?,?,?,?);

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
mxkanak@regence.com
Sent: Thursday, February 05, 2004 3:21 PM
To: DataStage Users Discussion List
Cc: DataStage Users Discussion List; datastage-users-bounces@oliver.com
Subject: RE: Db2 Duplicate Warning



What is your statement like ? Just Insert or Update/Insert ?

Thanks,
Madhu
DW Engineering
(503) 220-4740





Babatunde.Ebohon


t.com> cc:
datastage-users-bounces@oliver.com

Sent by: Subject: RE: Db2
Duplicate Warning
datastage-users-bounces

@oliver.com





02/05/2004 01:13 PM

Please respond to

"DataStage Users

Discussion List"



|-------------------|

| [ ] Secure E-mail |

|-------------------|







I have tried that too but i found no duplicates. none. This may sound
funny but its the truth.

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
mxkanak@regence.com
Sent: Thursday, February 05, 2004 3:11 PM
To: DataStage Users Discussion List
Cc: DataStage Users Discussion List; datastage-users-bounces@oliver.com
Subject: Re: Db2 Duplicate Warning



It appears that the data set(rows) you are inserting contains
duplicates.
Try running the source query outside the datastage job and see if there
are
any duplicates.

Thanks,
Madhu
DW Engineering
(503) 220-4740




Babatunde.Ebohon


t.com> cc:

Sent by: Subject: Db2
Duplicate Warning
datastage-users-bounces

@oliver.com



02/05/2004 11:59 AM

Please respond to

"DataStage Users

Discussion List"


|-------------------|

| [ ] Secure E-mail |

|-------------------|






Hi all,
Im trying to understand why im getting the error below. There is only
one
key in the table im trying to load thru Db2_APi . I checked out the
serogate key and i know there are no duplicates but i kept getting this
warning below.

DB2_UDB_API_47,0: Warning: DB2_UDB_API_47: [IBM][CLI Driver][DB2/SUN64]
SQL0803N One or more values in the INSERT statement, UPDATE statement,
or
foreign key update caused by a DELETE statement are not valid because
the
primary key, unique constraint or unique index identified by "1"
constrains
table "BDW.BSACT" from having duplicate rows for those columns.
SQLSTATE=23505

I have tried all sorts of things but it wont stop. Does anyone knows
what
could be going on?




_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

[admin]

Do you feed with this query all fields of your table or does the table
contain additional fields? Maybe that those fields have to be unique or not
null.

-----Original Message-----
From: Babatunde.Ebohon [mailto:Babatunde.Ebohon@target.com]
Sent: Thursday, February 05, 2004 10:23 PM
To: DataStage Users Discussion List
Subject: RE: Db2 Duplicate Warning


Here is my statement

INSERT INTO bdw.bsact
(BSACT_I,BSACT_TYPE_I,APPL_DATA_SRC_I,BSACT_ALTN_KEY_T,CRTE_TS,UPDT_TS,ETL_P
RCS_C) VALUES (?,?,?,?,?,?,?);

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
mxkanak@regence.com
Sent: Thursday, February 05, 2004 3:21 PM
To: DataStage Users Discussion List
Cc: DataStage Users Discussion List; datastage-users-bounces@oliver.com
Subject: RE: Db2 Duplicate Warning



What is your statement like ? Just Insert or Update/Insert ?

Thanks,
Madhu
DW Engineering
(503) 220-4740








I have tried that too but i found no duplicates. none. This may sound
funny but its the truth.

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
mxkanak@regence.com
Sent: Thursday, February 05, 2004 3:11 PM
To: DataStage Users Discussion List
Cc: DataStage Users Discussion List; datastage-users-bounces@oliver.com
Subject: Re: Db2 Duplicate Warning



It appears that the data set(rows) you are inserting contains duplicates.
Try running the source query outside the datastage job and see if there are
any duplicates.

Thanks,
Madhu
DW Engineering
(503) 220-4740



Hi all,
Im trying to understand why im getting the error below. There is only one
key in the table im trying to load thru Db2_APi . I checked out the
serogate key and i know there are no duplicates but i kept getting this
warning below.

DB2_UDB_API_47,0: Warning: DB2_UDB_API_47: [IBM][CLI Driver][DB2/SUN64]
SQL0803N One or more values in the INSERT statement, UPDATE statement, or
foreign key update caused by a DELETE statement are not valid because the
primary key, unique constraint or unique index identified by "1" constrains
table "BDW.BSACT" from having duplicate rows for those columns.
SQLSTATE=23505

I have tried all sorts of things but it wont stop. Does anyone knows what
could be going on?


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of David Barham
Sent: Thursday, February 05, 2004 3:09 AM
To: DataStage Users Discussion List
Subject: RE: DataStage: Target Table Names

Well, I'm not sure about the ORAOCI9 stage, but the ORAOCI8 stage
logs all the SQL statements in the job log. Hopefully, the ORAOCI9
stage does as well. It might be a bit messy to parse, but that would
be one way to get the table names. While you are at it, stage
start/end times and row counts are there too.


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of Timothy
Walsh
Sent: Thursday, 5 February 2004 6:58 PM
To: datastage-users@oliver.com
Subject: DataStage: Target Table Names

DataStage World,

Here are our details:
DataStage: v6.1
OS: AIX 5.2
Staging Repository: Oracle v9.2 (We use ORAOCI9 Stages)

My team wants to start collect some jobs details about our ETL
jobs and store them in an DataStage Audit Table within our
persistent staging area (In Oracle)
For a job we want to collect the following details:
1. Job Name (Done)
2. Job Target Table Name(s) !!!!!!
3. Job Start Time (Done)
4. Job End Time (Done)

How, within a job (not a controller) or a routine, could I
capture a target oracle table name(s).... so that we can pass
this information to the audit table. We know how to capture
this data from job logs via a job controller, but we are trying
to embed this functionality within individual jobs.

Please let me know if I'm crazy.... or if you all need more
details.

Cheers,

Tim Walsh_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users





_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

[admin]

Where do i turn it off?

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of Craig Hulett
Sent: Thursday, February 05, 2004 8:18 PM
To: 'DataStage Users Discussion List'
Subject: RE: Db2 Duplicate Warning


Do you have Inter-Process row buffering turned on by any chance in the job?
Just ran into a situation with a job today that writes to Oracle but it may
apply: buffering on, it reported a single false Duplicate Key violation,
turn it off and all records loaded fine.

-craig

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com] On Behalf Of Shawn Ramsey
Sent: Thursday, February 05, 2004 3:28 PM
To: DataStage Users Discussion List
Subject: RE: Db2 Duplicate Warning


Is this job running in a splitter/combiner? If so does the combiner go
directly into the DB2 stage? If so try putting a transformer between
the splitter and the db2 stage.


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com] On Behalf Of
Babatunde.Ebohon
Sent: Thursday, February 05, 2004 1:23 PM
To: DataStage Users Discussion List
Subject: RE: Db2 Duplicate Warning


Here is my statement

INSERT INTO bdw.bsact
(BSACT_I,BSACT_TYPE_I,APPL_DATA_SRC_I,BSACT_ALTN_KEY_T,CRTE_TS,UPDT_TS,E
TL_PRCS_C) VALUES (?,?,?,?,?,?,?);

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
mxkanak@regence.com
Sent: Thursday, February 05, 2004 3:21 PM
To: DataStage Users Discussion List
Cc: DataStage Users Discussion List; datastage-users-bounces@oliver.com
Subject: RE: Db2 Duplicate Warning



What is your statement like ? Just Insert or Update/Insert ?

Thanks,
Madhu
DW Engineering
(503) 220-4740





Babatunde.Ebohon


t.com> cc:
datastage-users-bounces@oliver.com

Sent by: Subject: RE: Db2
Duplicate Warning
datastage-users-bounces

@oliver.com





02/05/2004 01:13 PM

Please respond to

"DataStage Users

Discussion List"



|-------------------|

| [ ] Secure E-mail |

|-------------------|







I have tried that too but i found no duplicates. none. This may sound
funny but its the truth.

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
mxkanak@regence.com
Sent: Thursday, February 05, 2004 3:11 PM
To: DataStage Users Discussion List
Cc: DataStage Users Discussion List; datastage-users-bounces@oliver.com
Subject: Re: Db2 Duplicate Warning



It appears that the data set(rows) you are inserting contains
duplicates.
Try running the source query outside the datastage job and see if there
are
any duplicates.

Thanks,
Madhu
DW Engineering
(503) 220-4740




Babatunde.Ebohon


t.com> cc:

Sent by: Subject: Db2
Duplicate Warning
datastage-users-bounces

@oliver.com



02/05/2004 11:59 AM

Please respond to

"DataStage Users

Discussion List"


|-------------------|

| [ ] Secure E-mail |

|-------------------|






Hi all,
Im trying to understand why im getting the error below. There is only
one
key in the table im trying to load thru Db2_APi . I checked out the
serogate key and i know there are no duplicates but i kept getting this
warning below.

DB2_UDB_API_47,0: Warning: DB2_UDB_API_47: [IBM][CLI Driver][DB2/SUN64]
SQL0803N One or more values in the INSERT statement, UPDATE statement,
or
foreign key update caused by a DELETE statement are not valid because
the
primary key, unique constraint or unique index identified by "1"
constrains
table "BDW.BSACT" from having duplicate rows for those columns.
SQLSTATE=23505

I have tried all sorts of things but it wont stop. Does anyone knows
what
could be going on?




_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

[admin]

I fed it all the required coluns on the table.

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
wolfgang.huerter@gerling.de
Sent: Friday, February 06, 2004 5:11 AM
To: datastage-users@oliver.com
Subject: RE: Db2 Duplicate Warning



Do you feed with this query all fields of your table or does the table
contain additional fields? Maybe that those fields have to be unique or not
null.

-----Original Message-----
From: Babatunde.Ebohon [mailto:Babatunde.Ebohon@target.com]
Sent: Thursday, February 05, 2004 10:23 PM
To: DataStage Users Discussion List
Subject: RE: Db2 Duplicate Warning


Here is my statement

INSERT INTO bdw.bsact
(BSACT_I,BSACT_TYPE_I,APPL_DATA_SRC_I,BSACT_ALTN_KEY_T,CRTE_TS,UPDT_TS,ETL_P
RCS_C) VALUES (?,?,?,?,?,?,?);

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
mxkanak@regence.com
Sent: Thursday, February 05, 2004 3:21 PM
To: DataStage Users Discussion List
Cc: DataStage Users Discussion List; datastage-users-bounces@oliver.com
Subject: RE: Db2 Duplicate Warning



What is your statement like ? Just Insert or Update/Insert ?

Thanks,
Madhu
DW Engineering
(503) 220-4740








I have tried that too but i found no duplicates. none. This may sound
funny but its the truth.

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of
mxkanak@regence.com
Sent: Thursday, February 05, 2004 3:11 PM
To: DataStage Users Discussion List
Cc: DataStage Users Discussion List; datastage-users-bounces@oliver.com
Subject: Re: Db2 Duplicate Warning



It appears that the data set(rows) you are inserting contains duplicates.
Try running the source query outside the datastage job and see if there are
any duplicates.

Thanks,
Madhu
DW Engineering
(503) 220-4740



Hi all,
Im trying to understand why im getting the error below. There is only one
key in the table im trying to load thru Db2_APi . I checked out the
serogate key and i know there are no duplicates but i kept getting this
warning below.

DB2_UDB_API_47,0: Warning: DB2_UDB_API_47: [IBM][CLI Driver][DB2/SUN64]
SQL0803N One or more values in the INSERT statement, UPDATE statement, or
foreign key update caused by a DELETE statement are not valid because the
primary key, unique constraint or unique index identified by "1" constrains
table "BDW.BSACT" from having duplicate rows for those columns.
SQLSTATE=23505

I have tried all sorts of things but it wont stop. Does anyone knows what
could be going on?


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of David Barham
Sent: Thursday, February 05, 2004 3:09 AM
To: DataStage Users Discussion List
Subject: RE: DataStage: Target Table Names

Well, I'm not sure about the ORAOCI9 stage, but the ORAOCI8 stage
logs all the SQL statements in the job log. Hopefully, the ORAOCI9
stage does as well. It might be a bit messy to parse, but that would
be one way to get the table names. While you are at it, stage
start/end times and row counts are there too.


-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of Timothy
Walsh
Sent: Thursday, 5 February 2004 6:58 PM
To: datastage-users@oliver.com
Subject: DataStage: Target Table Names

DataStage World,

Here are our details:
DataStage: v6.1
OS: AIX 5.2
Staging Repository: Oracle v9.2 (We use ORAOCI9 Stages)

My team wants to start collect some jobs details about our ETL
jobs and store them in an DataStage Audit Table within our
persistent staging area (In Oracle)
For a job we want to collect the following details:
1. Job Name (Done)
2. Job Target Table Name(s) !!!!!!
3. Job Start Time (Done)
4. Job End Time (Done)

How, within a job (not a controller) or a routine, could I
capture a target oracle table name(s).... so that we can pass
this information to the audit table. We know how to capture
this data from job logs via a job controller, but we are trying
to embed this functionality within individual jobs.

Please let me know if I'm crazy.... or if you all need more
details.

Cheers,

Tim Walsh_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users





_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

[admin]

At the individual job level - it's part of the Properties. The last tab
should be 'Performance', look for it there. It can also be turned on at the
Project level and the job may simply say 'Use Project Defaults'. Check the
Properties of your project via the Manager.

-craig

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com] On Behalf Of Babatunde.Ebohon
Sent: Friday, February 06, 2004 8:00 AM
To: DataStage Users Discussion List
Subject: RE: Db2 Duplicate Warning


Where do i turn it off?

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com]On Behalf Of Craig Hulett
Sent: Thursday, February 05, 2004 8:18 PM
To: 'DataStage Users Discussion List'
Subject: RE: Db2 Duplicate Warning


Do you have Inter-Process row buffering turned on by any chance in the job?
Just ran into a situation with a job today that writes to Oracle but it may
apply: buffering on, it reported a single false Duplicate Key violation,
turn it off and all records loaded fine.

-craig



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users