RES: Limit income stream
Posted: Wed Jan 07, 2004 12:42 pm
Sutton,
but how can I, in that Where clause panel, reference a value from another source (another DB)?
Tks,
Alex
-----Mensagem original-----
De: Sutton, Daniel A [mailto:daniel.a.sutton@boeing.com]
Enviada em: quarta-feira, 7 de janeiro de 2004 16:37
Para: datastage-users@oliver.com
Assunto: RE: Limit income stream
The output stage has a panel for the WHERE clause. I use DB2 or Oracle stages. Go to Output panel. Then go to SQL panel in v5 or BUILD in v7. Those are the two versions that I have experience with.
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: Alex Martins [mailto:Alex@proit.com.br]
Sent: Wednesday, January 07, 2004 1:16 PM
To: Datastage-Users (E-mail)
Subject: Limit income stream
Misters,
I need to limit a query (like adding a where clause) based on a value from another DB.
How can I do it?
Tks,
Alex
but how can I, in that Where clause panel, reference a value from another source (another DB)?
Tks,
Alex
-----Mensagem original-----
De: Sutton, Daniel A [mailto:daniel.a.sutton@boeing.com]
Enviada em: quarta-feira, 7 de janeiro de 2004 16:37
Para: datastage-users@oliver.com
Assunto: RE: Limit income stream
The output stage has a panel for the WHERE clause. I use DB2 or Oracle stages. Go to Output panel. Then go to SQL panel in v5 or BUILD in v7. Those are the two versions that I have experience with.
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: Alex Martins [mailto:Alex@proit.com.br]
Sent: Wednesday, January 07, 2004 1:16 PM
To: Datastage-Users (E-mail)
Subject: Limit income stream
Misters,
I need to limit a query (like adding a where clause) based on a value from another DB.
How can I do it?
Tks,
Alex