UNION?

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

UNION?

Post by admin »

TWlzdGVycywNCmlzIGl0IHBvc3NpYmxlIHRvIG1ha2UgYSBVTklPTiBiZXR3ZWVuIHRvIHN0cmVh
bXM/DQpUa3MsDQpBbGV4DQo=

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

UNION?

Post by admin »

DQpoaSwNCg0KY2FuIHlvdSBiZSBtb3JlIHNwZWVjaWZpYyA/DQp5b3UgY2FuIG1ha2UgYSBVTklP
TiB1c2luZyBhIHN0cmVhbSBhbmQgYSByZWZlcmVuY2UgbGluaw0KDQpyZWdhcmRzDQpSdWkgU29h
cmVzDQpTZW5pb3IgQ29uc3VsdGFudA0KLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4u
Li4NCk5vdmFiYXNlDQpSdWkuU29hcmVzQE5vdmFiYXNlLnB0DQpUbG0gOiArMzUxIDk2IDM0NzA4
NDANCg0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogQWxleCBNYXJ0aW5zIFtt
YWlsdG86QWxleEBwcm9pdC5jb20uYnJdDQpTZW50OiB0ZXLDp2EtZmVpcmEsIDE3IGRlIEZldmVy
ZWlybyBkZSAyMDA0IDE4OjIzDQpUbzogZGF0YXN0YWdlLXVzZXJzQG9saXZlci5jb20NClN1Ympl
Y3Q6IFVOSU9OPw0KDQoNCk1pc3RlcnMsDQppcyBpdCBwb3NzaWJsZSB0byBtYWtlIGEgVU5JT04g
YmV0d2VlbiB0byBzdHJlYW1zPw0KVGtzLA0KQWxleA0K

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

UNION?

Post by admin »

A UNION is the elimination of duplicates. Search the archives (www.dsxchange.com) for these terms. It is better, if possible, to form the UNION before the rows reach DataStage, because that was DataStage will have the smallest possible number of rows to process.
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

UNION?

Post by admin »

VmFzY28sDQpJIHRoaW5rIGEgcmVmZXJlbmNlIGxpbmsgd29uwrR0IHdvcmsuIEnCtG0gdGhpbmsg
b24gMiBzdHJlYW1zIHdpdGggMTAgbGluZXMgdHVybmluZyBpbnRvIGEgc3RyZWFtIHdpdGggMjAg
bGluZXMuDQpDb3JyZWN0IG1lIGlmIEkgYW0gd29ybmcsIGJ1dCByZWZlcmVuY2VzIGRvbsK0dCBh
ZGQgbGluZXMgdG8gdGhlIHN0cmVhbS4NCkF0ZW5jaW9zYW1lbnRlLA0KQWxleA0KDQoJLS0tLS1N
ZW5zYWdlbSBvcmlnaW5hbC0tLS0tIA0KCURlOiBWYXNjbyBMdWlzIENhcnZhbGhvIFttYWlsdG86
dmFzY28ubC5jYXJ2YWxob0B0dmNhYm8ucHRdIA0KCUVudmlhZGE6IHRlciAxNy8wMi8yMDA0IDE1
OjM5IA0KCVBhcmE6IERhdGFTdGFnZSBVc2VycyBEaXNjdXNzaW9uIExpc3QgDQoJQ2M6IA0KCUFz
c3VudG86IFJFOiBVTklPTj8NCgkNCgkNCg0KDQoJaGksDQoJDQoJY2FuIHlvdSBiZSBtb3JlIHNw
ZWVjaWZpYyA/DQoJeW91IGNhbiBtYWtlIGEgVU5JT04gdXNpbmcgYSBzdHJlYW0gYW5kIGEgcmVm
ZXJlbmNlIGxpbmsNCgkNCglyZWdhcmRzDQoJUnVpIFNvYXJlcw0KCVNlbmlvciBDb25zdWx0YW50
DQoJLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4NCglOb3ZhYmFzZQ0KCVJ1aS5T
b2FyZXNATm92YWJhc2UucHQNCglUbG0gOiArMzUxIDk2IDM0NzA4NDANCgkNCgkNCgktLS0tLU9y
aWdpbmFsIE1lc3NhZ2UtLS0tLQ0KCUZyb206IEFsZXggTWFydGlucyBbbWFpbHRvOkFsZXhAcHJv
aXQuY29tLmJyXQ0KCVNlbnQ6IHRlcsOnYS1mZWlyYSwgMTcgZGUgRmV2ZXJlaXJvIGRlIDIwMDQg
MTg6MjMNCglUbzogZGF0YXN0YWdlLXVzZXJzQG9saXZlci5jb20NCglTdWJqZWN0OiBVTklPTj8N
CgkNCgkNCglNaXN0ZXJzLA0KCWlzIGl0IHBvc3NpYmxlIHRvIG1ha2UgYSBVTklPTiBiZXR3ZWVu
IHRvIHN0cmVhbXM/DQoJVGtzLA0KCUFsZXgNCgkNCg0K

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

UNION?

Post by admin »

U29ycnkgUmF5LiAgSSBkaXNhZ3JlZS4gQSBVTklPTiBpcyB0aGUgY29uY2F0ZW5hdGlvbiBvZiB0
d28gdGFibGVzLCB0aGF0IGhhdmUgdGhlIHNhbWUgY29sdW1ucy4gIEl0IGluaGVyZW50bHkgaGFz
IG5vdGhpbmcgdG8gZG8gd2l0aCBkdXBsaWNhdGUgcm93cywgYWx0aG91Z2ggdGhpcyBwcm9jZXNz
IG1heSBjcmVhdGUgZHVwbGljYXRlIHdpdGhpbiB0aGUgcmVzdWx0YW50IHRhYmxlLg0KDQpTZWFy
Y2hpbmcgZHN4Y2hhbmdlIGlzIGEgZ29vZCBpZGVhLCBzaW5jZSB0aGVyZSBpcyBhIHNvbGlkIGV4
YW1wbGUgb2YgaG93IHRvIHVzZSBEUyBkZXNpZ25lciB0byBkbyB0aGlzLg0KDQpEYW5pZWwgQS4g
U3V0dG9uICBBc3NvY2lhdGUgVGVjaG5pY2FsIEZlbGxvdywgQm9laW5nIE5hdmlnYXRvcg0KSGll
cmFyY2hpY2FsIERhdGFiYXNlcywgRGF0YSBXYXJlaG91c2UsIGFuZCBNaWdyYXRpb24gQ29udHJv
bCBHcm91cA0KDQpUbyBiZSBpbiBhIGRpYWxvZ3VlLCB3ZSBtdXN0IGxpc3RlbiBmcm9tIHdoZXJl
IHRoZSBvdGhlciBwZXJzb24gc3BlYWtzLg0KT3RoZXJ3aXNlLCB3ZSBvbmx5IGhhdmUgdHdvIG1v
bm9sb2d1ZXMNCg0KQm9laW5nIFBoaWxhZGVscGhpYSBJUy9EYXRhIE1hbmFnZW1lbnQNCjYxMC01
OTEtNzEyNCAgICAgNjEwLTU5MS03NTI0KGZheCkgICAgODAwLTk0Ni00NjQ2IHB3ZCAxNDk5NTMz
KGJlZXBlcikNCg0KZW1haWw6ICAgICBkYW5pZWwuYS5zdXR0b25AYm9laW5nLmNvbQ0KDQpSZWd1
bGFyIE1haWwgQWRkcmVzczoNCkJvZWluZyANClBPIEJveCAxNjg1OCAgTVMtUDI5LTI5DQpQaGls
YWRlbHBoaWEJUEEJMTkxNDItMDg1OA0KDQoNCg0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0t
LQ0KRnJvbTogUmF5IFd1cmxvZCBbbWFpbHRvOnJheXdAbWluZGxlc3MuY29tXQ0KU2VudDogVHVl
c2RheSwgRmVicnVhcnkgMTcsIDIwMDQgMjo0MyBQTQ0KVG86IERhdGFTdGFnZSBVc2VycyBEaXNj
dXNzaW9uIExpc3QNClN1YmplY3Q6IFJFOiBVTklPTj8NCg0KDQpBIFVOSU9OIGlzIHRoZSBlbGlt
aW5hdGlvbiBvZiBkdXBsaWNhdGVzLiAgU2VhcmNoIHRoZSBhcmNoaXZlcyAod3d3LmRzeGNoYW5n
ZS5jb20pIGZvciB0aGVzZSB0ZXJtcy4gIEl0IGlzIGJldHRlciwgaWYgcG9zc2libGUsIHRvIGZv
cm0gdGhlIFVOSU9OIGJlZm9yZSB0aGUgcm93cyByZWFjaCBEYXRhU3RhZ2UsIGJlY2F1c2UgdGhh
dCB3YXMgRGF0YVN0YWdlIHdpbGwgaGF2ZSB0aGUgc21hbGxlc3QgcG9zc2libGUgbnVtYmVyIG9m
IHJvd3MgdG8gcHJvY2Vzcy4NCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fDQpkYXRhc3RhZ2UtdXNlcnMgbWFpbGluZyBsaXN0DQpkYXRhc3RhZ2UtdXNlcnNA
b2xpdmVyLmNvbQ0KaHR0cDovL3d3dy5vbGl2ZXIuY29tL21haWxtYW4vbGlzdGluZm8vZGF0YXN0
YWdlLXVzZXJzDQo=

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

UNION?

Post by admin »

U29ycnkgRGFuaWVsLA0KSSBhbG1vc3QgZGlzYWdyZWUuIFVuaW9uIGNhbiByZW1vdmUgZHVwbGlj
YXRlZCByb3dzIGluIHRoZSAyIHNldHM7IGp1c3QgVW5pb24gQWxsIGluY2x1ZGVzIHRoZW0uDQo6
KQ0KVGtzIGZvciB0aGUgdW5pb24gZXhhbXBsZSBpbmRpY2F0aW9uLg0KIA0KDQoJLS0tLS1NZW5z
YWdlbSBvcmlnaW5hbC0tLS0tIA0KCURlOiBTdXR0b24sIERhbmllbCBBIFttYWlsdG86ZGFuaWVs
LmEuc3V0dG9uQGJvZWluZy5jb21dIA0KCUVudmlhZGE6IHF1YSAxOC8wMi8yMDA0IDE5OjA2IA0K
CVBhcmE6IERhdGFTdGFnZSBVc2VycyBEaXNjdXNzaW9uIExpc3QgDQoJQ2M6IA0KCUFzc3VudG86
IFJFOiBVTklPTj8NCgkNCgkNCg0KCVNvcnJ5IFJheS4gIEkgZGlzYWdyZWUuIEEgVU5JT04gaXMg
dGhlIGNvbmNhdGVuYXRpb24gb2YgdHdvIHRhYmxlcywgdGhhdCBoYXZlIHRoZSBzYW1lIGNvbHVt
bnMuICBJdCBpbmhlcmVudGx5IGhhcyBub3RoaW5nIHRvIGRvIHdpdGggZHVwbGljYXRlIHJvd3Ms
IGFsdGhvdWdoIHRoaXMgcHJvY2VzcyBtYXkgY3JlYXRlIGR1cGxpY2F0ZSB3aXRoaW4gdGhlIHJl
c3VsdGFudCB0YWJsZS4NCgkNCglTZWFyY2hpbmcgZHN4Y2hhbmdlIGlzIGEgZ29vZCBpZGVhLCBz
aW5jZSB0aGVyZSBpcyBhIHNvbGlkIGV4YW1wbGUgb2YgaG93IHRvIHVzZSBEUyBkZXNpZ25lciB0
byBkbyB0aGlzLg0KCQ0KCURhbmllbCBBLiBTdXR0b24gIEFzc29jaWF0ZSBUZWNobmljYWwgRmVs
bG93LCBCb2VpbmcgTmF2aWdhdG9yDQoJSGllcmFyY2hpY2FsIERhdGFiYXNlcywgRGF0YSBXYXJl
aG91c2UsIGFuZCBNaWdyYXRpb24gQ29udHJvbCBHcm91cA0KCQ0KCVRvIGJlIGluIGEgZGlhbG9n
dWUsIHdlIG11c3QgbGlzdGVuIGZyb20gd2hlcmUgdGhlIG90aGVyIHBlcnNvbiBzcGVha3MuDQoJ
T3RoZXJ3aXNlLCB3ZSBvbmx5IGhhdmUgdHdvIG1vbm9sb2d1ZXMNCgkNCglCb2VpbmcgUGhpbGFk
ZWxwaGlhIElTL0RhdGEgTWFuYWdlbWVudA0KCTYxMC01OTEtNzEyNCAgICAgNjEwLTU5MS03NTI0
KGZheCkgICAgODAwLTk0Ni00NjQ2IHB3ZCAxNDk5NTMzKGJlZXBlcikNCgkNCgllbWFpbDogICAg
IGRhbmllbC5hLnN1dHRvbkBib2VpbmcuY29tDQoJDQoJUmVndWxhciBNYWlsIEFkZHJlc3M6DQoJ
Qm9laW5nDQoJUE8gQm94IDE2ODU4ICBNUy1QMjktMjkNCglQaGlsYWRlbHBoaWEgICAgUEEgICAg
ICAxOTE0Mi0wODU4DQoJDQoJDQoJDQoJDQoJLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCglG
cm9tOiBSYXkgV3VybG9kIFttYWlsdG86cmF5d0BtaW5kbGVzcy5jb21dDQoJU2VudDogVHVlc2Rh
eSwgRmVicnVhcnkgMTcsIDIwMDQgMjo0MyBQTQ0KCVRvOiBEYXRhU3RhZ2UgVXNlcnMgRGlzY3Vz
c2lvbiBMaXN0DQoJU3ViamVjdDogUkU6IFVOSU9OPw0KCQ0KCQ0KCUEgVU5JT04gaXMgdGhlIGVs
aW1pbmF0aW9uIG9mIGR1cGxpY2F0ZXMuICBTZWFyY2ggdGhlIGFyY2hpdmVzICh3d3cuZHN4Y2hh
bmdlLmNvbSkgZm9yIHRoZXNlIHRlcm1zLiAgSXQgaXMgYmV0dGVyLCBpZiBwb3NzaWJsZSwgdG8g
Zm9ybSB0aGUgVU5JT04gYmVmb3JlIHRoZSByb3dzIHJlYWNoIERhdGFTdGFnZSwgYmVjYXVzZSB0
aGF0IHdhcyBEYXRhU3RhZ2Ugd2lsbCBoYXZlIHRoZSBzbWFsbGVzdCBwb3NzaWJsZSBudW1iZXIg
b2Ygcm93cyB0byBwcm9jZXNzLg0KCV9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fDQoJZGF0YXN0YWdlLXVzZXJzIG1haWxpbmcgbGlzdA0KCWRhdGFzdGFnZS11
c2Vyc0BvbGl2ZXIuY29tDQoJaHR0cDovL3d3dy5vbGl2ZXIuY29tL21haWxtYW4vbGlzdGluZm8v
ZGF0YXN0YWdlLXVzZXJzDQoJDQoNCg==

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

UNION?

Post by admin »

select * from table_a
union all
select * from table_b

will give you all rows in table_a and table_b

select * from table_a
union
select * from table_b

will merge table_a and table_b and then do a distinct


Daniel, can you please state what it is you are trying
to accomplish, and give some indication as to the data
volumes in play on the two sources. High volumes will
be handled differently from small volumes, as they
often require a more elegant solution. Feel free to
post this on www.dsxchange.com if you want to share
with that community.

-Ken



--- Alex Martins wrote:
> Sorry Daniel,
> I almost disagree. Union can remove duplicated rows
> in the 2 sets; just Union All includes them.
> :)
> Tks for the union example indication.
>
>
> -----Mensagem original-----
> De: Sutton, Daniel A
> [mailto:daniel.a.sutton@boeing.com]
> Enviada: qua 18/02/2004 19:06
> Para: DataStage Users Discussion List
> Cc:
> Assunto: RE: UNION?
>
>
>
> Sorry Ray. I disagree. A UNION is the
> concatenation of two tables, that have the same
> columns. It inherently has nothing to do with
> duplicate rows, although this process may create
> duplicate within the resultant table.
>
> Searching dsxchange is a good idea, since there is
> a solid example of how to use DS designer to do
> this.
>
> Daniel A. Sutton Associate Technical Fellow,
> Boeing Navigator
> Hierarchical Databases, Data Warehouse, and
> Migration Control Group
>
> To be in a dialogue, we must listen from where the
> other person speaks.
> Otherwise, we only have two monologues
>
> Boeing Philadelphia IS/Data Management
> 610-591-7124 610-591-7524(fax) 800-946-4646
> pwd 1499533(beeper)
>
> email: daniel.a.sutton@boeing.com
>
> Regular Mail Address:
> Boeing
> PO Box 16858 MS-P29-29
> Philadelphia PA 19142-0858
>
>
>
>
> -----Original Message-----
> From: Ray Wurlod [mailto:rayw@mindless.com]
> Sent: Tuesday, February 17, 2004 2:43 PM
> To: DataStage Users Discussion List
> Subject: RE: UNION?
>
>
> A UNION is the elimination of duplicates. Search
> the archives (www.dsxchange.com) for these terms.
> It is better, if possible, to form the UNION before
> the rows reach DataStage, because that was DataStage
> will have the smallest possible number of rows to
> process.
> _______________________________________________
> 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
>


__________________________________
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Locked