Validation

[admin]

I have a job that has an update action to Oracle of Clear table then insert
rows and is read committed. The job itself runs fine, however when there
is data populated in the table and I have to make changes to the job and
validate the job it removes all data from the Oracle table.

Any Ideas as to why this is happening??

Thanks
Lisa

---------------------------------------------------------
The sender of this electronic message intends that this e-mail be used exclusively by the individual or entity to which it is intended to be addressed. This message may contain information that is privileged and confidential and thereby exempt and protected from unauthorized disclosure under applicable law. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering the message to the intended recipient, be aware that any disclosure, dissemination, distribution or copying of this communication, or the use of its contents, is not authorized and is strictly prohibited. If you have received this communication in error and are not the intended recipient, please notify the sender immediately and permanently delete the original message from your e-mail system.

[admin]

When you validate a job the clear table command is executed.

Hendrik Kotze
Systems Engineer
Ascential Software South Africa
tel: +27 11 807-0313
fax: +27 11 807-2594
mobile: +27 83 326-6439


-----Original Message-----
From: lhamilto@ncshealth.com [mailto:lhamilto@ncshealth.com]
Sent: Monday, August 13, 2001 2:21 PM
To: datastage-users@oliver.com
Subject: Validation


I have a job that has an update action to Oracle of Clear table then insert
rows and is read committed. The job itself runs fine, however when there
is data populated in the table and I have to make changes to the job and
validate the job it removes all data from the Oracle table.

Any Ideas as to why this is happening??

Thanks
Lisa

---------------------------------------------------------
The sender of this electronic message intends that this e-mail be used exclusively by the individual or entity to which it is intended to be addressed. This message may contain information that is privileged and confidential and thereby exempt and protected from unauthorized disclosure under applicable law. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering the message to the intended recipient, be aware that any disclosure, dissemination, distribution or copying of this communication, or the use of its contents, is not authorized and is strictly prohibited. If you have received this communication in error and are not the intended recipient, please notify the sender immediately and permanently delete the original message from your e-mail system.

[admin]

The "clear table" rule.

-----Original Message-----
From: lhamilto@ncshealth.com [mailto:lhamilto@ncshealth.com]
Sent: Monday, 13 August 2001 20:21
To: datastage-users@oliver.com
Subject: Validation



I have a job that has an update action to Oracle of Clear table then insert
rows and is read committed. The job itself runs fine, however when there
is data populated in the table and I have to make changes to the job and
validate the job it removes all data from the Oracle table.

Any Ideas as to why this is happening??

Thanks
Lisa

---------------------------------------------------------
The sender of this electronic message intends that this e-mail be used exclusively by the individual or entity to which it is intended to be addressed. This message may contain information that is privileged and confidential and thereby exempt and protected from unauthorized disclosure under applicable law. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering the message to the intended recipient, be aware that any disclosure, dissemination, distribution or copying of this communication, or the use of its contents, is not authorized and is strictly prohibited. If you have received this communication in error and are not the intended recipient, please notify the sender immediately and permanently delete the original message from your e-mail system.