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
Limit income stream
Limit income stream
<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.
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.
Limit income stream
Alex you can use temporary Universe tables to stage data from 2 different
databases and then join them with your where clause.
Regards
Ejaz
-----Original Message-----
From: Alex Martins [mailto:Alex@proit.com.br]
Sent: Wednesday, January 07, 2004 1:42 PM
To: datastage-users@oliver.com
Subject: RES: Limit income stream
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
******************************************************************************
The information in this email is confidential and may be legally
privileged. Access to this email by anyone other than the
intended addressee is unauthorized. If you are not the intended
recipient of this message, any review, disclosure, copying,
distribution, retention, or any action taken or omitted to be taken
in reliance on it is prohibited and may be unlawful. If you are not
the intended recipient, please reply to or forward a copy of this
message to the sender and delete the message, any attachments,
and any copies thereof from your system.
******************************************************************************
databases and then join them with your where clause.
Regards
Ejaz
-----Original Message-----
From: Alex Martins [mailto:Alex@proit.com.br]
Sent: Wednesday, January 07, 2004 1:42 PM
To: datastage-users@oliver.com
Subject: RES: Limit income stream
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
******************************************************************************
The information in this email is confidential and may be legally
privileged. Access to this email by anyone other than the
intended addressee is unauthorized. If you are not the intended
recipient of this message, any review, disclosure, copying,
distribution, retention, or any action taken or omitted to be taken
in reliance on it is prohibited and may be unlawful. If you are not
the intended recipient, please reply to or forward a copy of this
message to the sender and delete the message, any attachments,
and any copies thereof from your system.
******************************************************************************
<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.
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.