Hi,
I want to execute a delete statement, for example: delete * from tab;
How and where may i execute that in DataStage?
Thanks in advance,
NSP
Delete Statement
Or, if i want to make a alter table instruction? Where can i execute that?
-----Original Message-----
From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
Sent: segunda-feira, 23 de Julho de 2001 16:03
To: datastage-users@oliver.com
Subject: Delete Statement
Hi,
I want to execute a delete statement, for example: delete * from tab;
How and where may i execute that in DataStage?
Thanks in advance,
NSP
-----Original Message-----
From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
Sent: segunda-feira, 23 de Julho de 2001 16:03
To: datastage-users@oliver.com
Subject: Delete Statement
Hi,
I want to execute a delete statement, for example: delete * from tab;
How and where may i execute that in DataStage?
Thanks in advance,
NSP
some of the stages have post and pre sql boxes, you can execute sql before or after the stage starts or finishes.
it depends on what you want to do, and to which database.
Andrew Webb
Principal Presales Consultant
Ascential Software
Changing the Way the World Looks At Information www.ascentialsoftware.com
Mobile : +44 (0)777 5762347
Direct : +44 (0)20 8818 0717
Switchboard : +44 (0)20 8818 0700
Fax: +44 (0)20 8818 0701
Email: andrew.webb@ascentialsoftware.com
This message is intended for the sole use of the intended recipient and may contain information that is confidential and privileged and/or attorneys work product. Any review or distribution by any other person is prohibited. If you are not the intended recipient, please immediately contact the sender and delete all copies
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: 23 July 2001 4:14 PM
> To: datastage-users@oliver.com
> Subject: RE: Delete Statement
>
>
>
> Or, if i want to make a alter table instruction? Where can i
> execute that?
>
>
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: segunda-feira, 23 de Julho de 2001 16:03
> To: datastage-users@oliver.com
> Subject: Delete Statement
>
>
> Hi,
>
> I want to execute a delete statement, for example: delete * from tab;
>
> How and where may i execute that in DataStage?
>
> Thanks in advance,
>
>
> NSP
>
>
it depends on what you want to do, and to which database.
Andrew Webb
Principal Presales Consultant
Ascential Software
Changing the Way the World Looks At Information www.ascentialsoftware.com
Mobile : +44 (0)777 5762347
Direct : +44 (0)20 8818 0717
Switchboard : +44 (0)20 8818 0700
Fax: +44 (0)20 8818 0701
Email: andrew.webb@ascentialsoftware.com
This message is intended for the sole use of the intended recipient and may contain information that is confidential and privileged and/or attorneys work product. Any review or distribution by any other person is prohibited. If you are not the intended recipient, please immediately contact the sender and delete all copies
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: 23 July 2001 4:14 PM
> To: datastage-users@oliver.com
> Subject: RE: Delete Statement
>
>
>
> Or, if i want to make a alter table instruction? Where can i
> execute that?
>
>
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: segunda-feira, 23 de Julho de 2001 16:03
> To: datastage-users@oliver.com
> Subject: Delete Statement
>
>
> Hi,
>
> I want to execute a delete statement, for example: delete * from tab;
>
> How and where may i execute that in DataStage?
>
> Thanks in advance,
>
>
> NSP
>
>
Andrew, my situation is something like this:
I have a process that writes to an oracle table by the ORAOCI8. After this, i want to execute a exchange partition, but i have no post sql box in stage to execute the statement.
Do you have any suggestions?
Thanks!
NSP
-----Original Message-----
From: Andrew Webb [mailto:Andrew.Webb@ascentialsoftware.com]
Sent: segunda-feira, 23 de Julho de 2001 16:19
To: datastage-users@oliver.com
Subject: RE: Delete Statement
some of the stages have post and pre sql boxes, you can execute sql before or after the stage starts or finishes.
it depends on what you want to do, and to which database.
Andrew Webb
Principal Presales Consultant
Ascential Software
Changing the Way the World Looks At Information www.ascentialsoftware.com
Mobile : +44 (0)777 5762347
Direct : +44 (0)20 8818 0717
Switchboard : +44 (0)20 8818 0700
Fax: +44 (0)20 8818 0701
Email: andrew.webb@ascentialsoftware.com
This message is intended for the sole use of the intended recipient and may contain information that is confidential and privileged and/or attorneys work product. Any review or distribution by any other person is prohibited. If you are not the intended recipient, please immediately contact the sender and delete all copies
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: 23 July 2001 4:14 PM
> To: datastage-users@oliver.com
> Subject: RE: Delete Statement
>
>
>
> Or, if i want to make a alter table instruction? Where can i execute
> that?
>
>
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: segunda-feira, 23 de Julho de 2001 16:03
> To: datastage-users@oliver.com
> Subject: Delete Statement
>
>
> Hi,
>
> I want to execute a delete statement, for example: delete * from tab;
>
> How and where may i execute that in DataStage?
>
> Thanks in advance,
>
>
> NSP
>
>
I have a process that writes to an oracle table by the ORAOCI8. After this, i want to execute a exchange partition, but i have no post sql box in stage to execute the statement.
Do you have any suggestions?
Thanks!
NSP
-----Original Message-----
From: Andrew Webb [mailto:Andrew.Webb@ascentialsoftware.com]
Sent: segunda-feira, 23 de Julho de 2001 16:19
To: datastage-users@oliver.com
Subject: RE: Delete Statement
some of the stages have post and pre sql boxes, you can execute sql before or after the stage starts or finishes.
it depends on what you want to do, and to which database.
Andrew Webb
Principal Presales Consultant
Ascential Software
Changing the Way the World Looks At Information www.ascentialsoftware.com
Mobile : +44 (0)777 5762347
Direct : +44 (0)20 8818 0717
Switchboard : +44 (0)20 8818 0700
Fax: +44 (0)20 8818 0701
Email: andrew.webb@ascentialsoftware.com
This message is intended for the sole use of the intended recipient and may contain information that is confidential and privileged and/or attorneys work product. Any review or distribution by any other person is prohibited. If you are not the intended recipient, please immediately contact the sender and delete all copies
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: 23 July 2001 4:14 PM
> To: datastage-users@oliver.com
> Subject: RE: Delete Statement
>
>
>
> Or, if i want to make a alter table instruction? Where can i execute
> that?
>
>
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: segunda-feira, 23 de Julho de 2001 16:03
> To: datastage-users@oliver.com
> Subject: Delete Statement
>
>
> Hi,
>
> I want to execute a delete statement, for example: delete * from tab;
>
> How and where may i execute that in DataStage?
>
> Thanks in advance,
>
>
> NSP
>
>
Absolutely do this outside the datastage job. You must separate the job from this kind of work, it makes development incredibly complex when testing, because it keeps doing the partition exchange. Use batch jobs to control and orchestrate job execution, you can then put SQL, unix scripts, whatever, between job executions.
-Ken
nuno.pimenta@tmn.pt on 23-Jul-2001 11:40
Please respond to datastage-users@oliver.com
To: datastage-users
cc:
Subject: RE: Delete Statement
Andrew, my situation is something like this:
I have a process that writes to an oracle table by the ORAOCI8. After this, i want to execute a exchange partition, but i have no post sql box in stage to execute the statement.
Do you have any suggestions?
Thanks!
NSP
-----Original Message-----
From: Andrew Webb [mailto:Andrew.Webb@ascentialsoftware.com]
Sent: segunda-feira, 23 de Julho de 2001 16:19
To: datastage-users@oliver.com
Subject: RE: Delete Statement
some of the stages have post and pre sql boxes, you can execute sql before or after the stage starts or finishes.
it depends on what you want to do, and to which database.
Andrew Webb
Principal Presales Consultant
Ascential Software
Changing the Way the World Looks At Information www.ascentialsoftware.com
Mobile : +44 (0)777 5762347
Direct : +44 (0)20 8818 0717
Switchboard : +44 (0)20 8818 0700
Fax: +44 (0)20 8818 0701
Email: andrew.webb@ascentialsoftware.com
This message is intended for the sole use of the intended recipient and may contain information that is confidential and privileged and/or attorneys work product. Any review or distribution by any other person is prohibited. If you are not the intended recipient, please immediately contact the sender and delete all copies
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: 23 July 2001 4:14 PM
> To: datastage-users@oliver.com
> Subject: RE: Delete Statement
>
>
>
> Or, if i want to make a alter table instruction? Where can i execute
> that?
>
>
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: segunda-feira, 23 de Julho de 2001 16:03
> To: datastage-users@oliver.com
> Subject: Delete Statement
>
>
> Hi,
>
> I want to execute a delete statement, for example: delete * from tab;
>
> How and where may i execute that in DataStage?
>
> Thanks in advance,
>
>
> NSP
>
>
-Ken
nuno.pimenta@tmn.pt on 23-Jul-2001 11:40
Please respond to datastage-users@oliver.com
To: datastage-users
cc:
Subject: RE: Delete Statement
Andrew, my situation is something like this:
I have a process that writes to an oracle table by the ORAOCI8. After this, i want to execute a exchange partition, but i have no post sql box in stage to execute the statement.
Do you have any suggestions?
Thanks!
NSP
-----Original Message-----
From: Andrew Webb [mailto:Andrew.Webb@ascentialsoftware.com]
Sent: segunda-feira, 23 de Julho de 2001 16:19
To: datastage-users@oliver.com
Subject: RE: Delete Statement
some of the stages have post and pre sql boxes, you can execute sql before or after the stage starts or finishes.
it depends on what you want to do, and to which database.
Andrew Webb
Principal Presales Consultant
Ascential Software
Changing the Way the World Looks At Information www.ascentialsoftware.com
Mobile : +44 (0)777 5762347
Direct : +44 (0)20 8818 0717
Switchboard : +44 (0)20 8818 0700
Fax: +44 (0)20 8818 0701
Email: andrew.webb@ascentialsoftware.com
This message is intended for the sole use of the intended recipient and may contain information that is confidential and privileged and/or attorneys work product. Any review or distribution by any other person is prohibited. If you are not the intended recipient, please immediately contact the sender and delete all copies
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: 23 July 2001 4:14 PM
> To: datastage-users@oliver.com
> Subject: RE: Delete Statement
>
>
>
> Or, if i want to make a alter table instruction? Where can i execute
> that?
>
>
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: segunda-feira, 23 de Julho de 2001 16:03
> To: datastage-users@oliver.com
> Subject: Delete Statement
>
>
> Hi,
>
> I want to execute a delete statement, for example: delete * from tab;
>
> How and where may i execute that in DataStage?
>
> Thanks in advance,
>
>
> NSP
>
>
The Oracle OCI8 plugin in DS 4.2 has an After SQL tab. I agree, though, about the sequence-of-events processing. If you have a SQL failure, do you still want to do the exchange?
From HELP: "Before. This tab contains the SQL statements executed before the stage processes job data rows."
-----Original Message-----
From: Ken_2_Bland@sbphrd.com [mailto:Ken_2_Bland@sbphrd.com]
Sent: Monday, July 23, 2001 12:16 PM
To: datastage-users@oliver.com
Subject: RE: Delete Statement
Absolutely do this outside the datastage job. You must separate the job from this kind of work, it makes development incredibly complex when testing, because it keeps doing the partition exchange. Use batch jobs to control and orchestrate job execution, you can then put SQL, unix scripts, whatever, between job executions.
-Ken
nuno.pimenta@tmn.pt on 23-Jul-2001 11:40
Please respond to datastage-users@oliver.com
To: datastage-users
cc:
Subject: RE: Delete Statement
Andrew, my situation is something like this:
I have a process that writes to an oracle table by the ORAOCI8. After this, i want to execute a exchange partition, but i have no post sql box in stage to execute the statement.
Do you have any suggestions?
Thanks!
NSP
-----Original Message-----
From: Andrew Webb [mailto:Andrew.Webb@ascentialsoftware.com]
Sent: segunda-feira, 23 de Julho de 2001 16:19
To: datastage-users@oliver.com
Subject: RE: Delete Statement
some of the stages have post and pre sql boxes, you can execute sql before or after the stage starts or finishes.
it depends on what you want to do, and to which database.
Andrew Webb
Principal Presales Consultant
Ascential Software
Changing the Way the World Looks At Information www.ascentialsoftware.com
Mobile : +44 (0)777 5762347
Direct : +44 (0)20 8818 0717
Switchboard : +44 (0)20 8818 0700
Fax: +44 (0)20 8818 0701
Email: andrew.webb@ascentialsoftware.com
This message is intended for the sole use of the intended recipient and may contain information that is confidential and privileged and/or attorneys work product. Any review or distribution by any other person is prohibited. If you are not the intended recipient, please immediately contact the sender and delete all copies
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: 23 July 2001 4:14 PM
> To: datastage-users@oliver.com
> Subject: RE: Delete Statement
>
>
>
> Or, if i want to make a alter table instruction? Where can i execute
> that?
>
>
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: segunda-feira, 23 de Julho de 2001 16:03
> To: datastage-users@oliver.com
> Subject: Delete Statement
>
>
> Hi,
>
> I want to execute a delete statement, for example: delete * from tab;
>
> How and where may i execute that in DataStage?
>
> Thanks in advance,
>
>
> NSP
>
>
From HELP: "Before. This tab contains the SQL statements executed before the stage processes job data rows."
-----Original Message-----
From: Ken_2_Bland@sbphrd.com [mailto:Ken_2_Bland@sbphrd.com]
Sent: Monday, July 23, 2001 12:16 PM
To: datastage-users@oliver.com
Subject: RE: Delete Statement
Absolutely do this outside the datastage job. You must separate the job from this kind of work, it makes development incredibly complex when testing, because it keeps doing the partition exchange. Use batch jobs to control and orchestrate job execution, you can then put SQL, unix scripts, whatever, between job executions.
-Ken
nuno.pimenta@tmn.pt on 23-Jul-2001 11:40
Please respond to datastage-users@oliver.com
To: datastage-users
cc:
Subject: RE: Delete Statement
Andrew, my situation is something like this:
I have a process that writes to an oracle table by the ORAOCI8. After this, i want to execute a exchange partition, but i have no post sql box in stage to execute the statement.
Do you have any suggestions?
Thanks!
NSP
-----Original Message-----
From: Andrew Webb [mailto:Andrew.Webb@ascentialsoftware.com]
Sent: segunda-feira, 23 de Julho de 2001 16:19
To: datastage-users@oliver.com
Subject: RE: Delete Statement
some of the stages have post and pre sql boxes, you can execute sql before or after the stage starts or finishes.
it depends on what you want to do, and to which database.
Andrew Webb
Principal Presales Consultant
Ascential Software
Changing the Way the World Looks At Information www.ascentialsoftware.com
Mobile : +44 (0)777 5762347
Direct : +44 (0)20 8818 0717
Switchboard : +44 (0)20 8818 0700
Fax: +44 (0)20 8818 0701
Email: andrew.webb@ascentialsoftware.com
This message is intended for the sole use of the intended recipient and may contain information that is confidential and privileged and/or attorneys work product. Any review or distribution by any other person is prohibited. If you are not the intended recipient, please immediately contact the sender and delete all copies
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: 23 July 2001 4:14 PM
> To: datastage-users@oliver.com
> Subject: RE: Delete Statement
>
>
>
> Or, if i want to make a alter table instruction? Where can i execute
> that?
>
>
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: segunda-feira, 23 de Julho de 2001 16:03
> To: datastage-users@oliver.com
> Subject: Delete Statement
>
>
> Hi,
>
> I want to execute a delete statement, for example: delete * from tab;
>
> How and where may i execute that in DataStage?
>
> Thanks in advance,
>
>
> NSP
>
>
Ok, im convenced, the script will be the best choice.
Thanks all!
-NSP
-----Original Message-----
From: lamont.lockwood@ascentialsoftware.com
[mailto:lamont.lockwood@ascentialsoftware.com]
Sent: segunda-feira, 23 de Julho de 2001 18:58
To: datastage-users@oliver.com
Subject: RE: Delete Statement
The Oracle OCI8 plugin in DS 4.2 has an After SQL tab. I agree, though, about the sequence-of-events processing. If you have a SQL failure, do you still want to do the exchange?
From HELP: "Before. This tab contains the SQL statements executed before the stage processes job data rows."
-----Original Message-----
From: Ken_2_Bland@sbphrd.com [mailto:Ken_2_Bland@sbphrd.com]
Sent: Monday, July 23, 2001 12:16 PM
To: datastage-users@oliver.com
Subject: RE: Delete Statement
Absolutely do this outside the datastage job. You must separate the job from this kind of work, it makes development incredibly complex when testing, because it keeps doing the partition exchange. Use batch jobs to control and orchestrate job execution, you can then put SQL, unix scripts, whatever, between job executions.
-Ken
nuno.pimenta@tmn.pt on 23-Jul-2001 11:40
Please respond to datastage-users@oliver.com
To: datastage-users
cc:
Subject: RE: Delete Statement
Andrew, my situation is something like this:
I have a process that writes to an oracle table by the ORAOCI8. After this, i want to execute a exchange partition, but i have no post sql box in stage to execute the statement.
Do you have any suggestions?
Thanks!
NSP
-----Original Message-----
From: Andrew Webb [mailto:Andrew.Webb@ascentialsoftware.com]
Sent: segunda-feira, 23 de Julho de 2001 16:19
To: datastage-users@oliver.com
Subject: RE: Delete Statement
some of the stages have post and pre sql boxes, you can execute sql before or after the stage starts or finishes.
it depends on what you want to do, and to which database.
Andrew Webb
Principal Presales Consultant
Ascential Software
Changing the Way the World Looks At Information www.ascentialsoftware.com
Mobile : +44 (0)777 5762347
Direct : +44 (0)20 8818 0717
Switchboard : +44 (0)20 8818 0700
Fax: +44 (0)20 8818 0701
Email: andrew.webb@ascentialsoftware.com
This message is intended for the sole use of the intended recipient and may contain information that is confidential and privileged and/or attorneys work product. Any review or distribution by any other person is prohibited. If you are not the intended recipient, please immediately contact the sender and delete all copies
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: 23 July 2001 4:14 PM
> To: datastage-users@oliver.com
> Subject: RE: Delete Statement
>
>
>
> Or, if i want to make a alter table instruction? Where can i execute
> that?
>
>
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: segunda-feira, 23 de Julho de 2001 16:03
> To: datastage-users@oliver.com
> Subject: Delete Statement
>
>
> Hi,
>
> I want to execute a delete statement, for example: delete * from tab;
>
> How and where may i execute that in DataStage?
>
> Thanks in advance,
>
>
> NSP
>
>
Thanks all!
-NSP
-----Original Message-----
From: lamont.lockwood@ascentialsoftware.com
[mailto:lamont.lockwood@ascentialsoftware.com]
Sent: segunda-feira, 23 de Julho de 2001 18:58
To: datastage-users@oliver.com
Subject: RE: Delete Statement
The Oracle OCI8 plugin in DS 4.2 has an After SQL tab. I agree, though, about the sequence-of-events processing. If you have a SQL failure, do you still want to do the exchange?
From HELP: "Before. This tab contains the SQL statements executed before the stage processes job data rows."
-----Original Message-----
From: Ken_2_Bland@sbphrd.com [mailto:Ken_2_Bland@sbphrd.com]
Sent: Monday, July 23, 2001 12:16 PM
To: datastage-users@oliver.com
Subject: RE: Delete Statement
Absolutely do this outside the datastage job. You must separate the job from this kind of work, it makes development incredibly complex when testing, because it keeps doing the partition exchange. Use batch jobs to control and orchestrate job execution, you can then put SQL, unix scripts, whatever, between job executions.
-Ken
nuno.pimenta@tmn.pt on 23-Jul-2001 11:40
Please respond to datastage-users@oliver.com
To: datastage-users
cc:
Subject: RE: Delete Statement
Andrew, my situation is something like this:
I have a process that writes to an oracle table by the ORAOCI8. After this, i want to execute a exchange partition, but i have no post sql box in stage to execute the statement.
Do you have any suggestions?
Thanks!
NSP
-----Original Message-----
From: Andrew Webb [mailto:Andrew.Webb@ascentialsoftware.com]
Sent: segunda-feira, 23 de Julho de 2001 16:19
To: datastage-users@oliver.com
Subject: RE: Delete Statement
some of the stages have post and pre sql boxes, you can execute sql before or after the stage starts or finishes.
it depends on what you want to do, and to which database.
Andrew Webb
Principal Presales Consultant
Ascential Software
Changing the Way the World Looks At Information www.ascentialsoftware.com
Mobile : +44 (0)777 5762347
Direct : +44 (0)20 8818 0717
Switchboard : +44 (0)20 8818 0700
Fax: +44 (0)20 8818 0701
Email: andrew.webb@ascentialsoftware.com
This message is intended for the sole use of the intended recipient and may contain information that is confidential and privileged and/or attorneys work product. Any review or distribution by any other person is prohibited. If you are not the intended recipient, please immediately contact the sender and delete all copies
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: 23 July 2001 4:14 PM
> To: datastage-users@oliver.com
> Subject: RE: Delete Statement
>
>
>
> Or, if i want to make a alter table instruction? Where can i execute
> that?
>
>
> -----Original Message-----
> From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt]
> Sent: segunda-feira, 23 de Julho de 2001 16:03
> To: datastage-users@oliver.com
> Subject: Delete Statement
>
>
> Hi,
>
> I want to execute a delete statement, for example: delete * from tab;
>
> How and where may i execute that in DataStage?
>
> Thanks in advance,
>
>
> NSP
>
>