I am trying to write an update job that reads from one table (odbc) and updates another table (odbc).
I am linking the keys and column that must be updated (in the transformer stage), and it seems to work ok, accept that I get a warning message for every input record that does not link to a matching output record ("0 rows
affected")
SQLExecute failed.
SQL statement:UPDATE PHDMPRODUCT SET PRICE = ?
where COMPNO = ? and CLIENTNO = ? and COMPPROD = ? 0 Rows affected.
How can I get rid of these warning messages ?
Maybe I should mention that I dont want to disable all warnings. This is just a simple update and only records with matches must be updated (without warning me about the other records).
Dirk Moolman
Database Administrator
Reach Technologies
South Africa
www.thefuelgroup.co.za
"No pessimist ever discovered the secret of the stars, or sailed to an uncharted land, or opened a new doorway for the human spirit." -Helen Keller
==========================================================
This message contains information intended for the perusal, and/or use (if so stated), by the stated addressee(s) only. The information is confidential and privileged. If you are not an intended recipient, do not peruse, use, disseminate, distribute, copy or in any manner rely upon the information contained in this message (directly or indirectly). The sender and/or the entity represented by the sender shall not be held accountable in the event that this prohibition is disregarded. If you receive this message in error, notify the sender immediately by e-mail, fax or telephone representations contained in this message, whether express or implied, are those of the sender only, unless that sender expressly states them to be the views or representations of an entity or person, who shall be named by the sender and who the sender shall state to represent. No liability shall otherwise attach to any other entity or person. ==========================================================
Update existing rows / warnings
I think I have a solution - I will try it now.
I will use the target table as a lookup as well when reading the source table, so that I can create a constraint that will only process matching records. This should work.
Dirk
-----Original Message-----
From: Dirk Moolman [mailto:dirkm@reach.co.za]
Sent: Monday, October 29, 2001 3:06 PM
To: Datastage List
Subject: Update existing rows / warnings
I am trying to write an update job that reads from one table (odbc) and updates another table (odbc).
I am linking the keys and column that must be updated (in the transformer stage), and it seems to work ok, accept that I get a warning message for every input record that does not link to a matching output record ("0 rows
affected")
SQLExecute failed.
SQL statement:UPDATE PHDMPRODUCT SET PRICE = ?
where COMPNO = ? and CLIENTNO = ? and COMPPROD = ? 0 Rows affected.
How can I get rid of these warning messages ?
Maybe I should mention that I dont want to disable all warnings. This is just a simple update and only records with matches must be updated (without warning me about the other records).
Dirk Moolman
Database Administrator
Reach Technologies
South Africa
www.thefuelgroup.co.za
"No pessimist ever discovered the secret of the stars, or sailed to an uncharted land, or opened a new doorway for the human spirit." -Helen Keller
==========================================================
This message contains information intended for the perusal, and/or use (if so stated), by the stated addressee(s) only. The information is confidential and privileged. If you are not an intended recipient, do not peruse, use, disseminate, distribute, copy or in any manner rely upon the information contained in this message (directly or indirectly). The sender and/or the entity represented by the sender shall not be held accountable in the event that this prohibition is disregarded. If you receive this message in error, notify the sender immediately by e-mail, fax or telephone representations contained in this message, whether express or implied, are those of the sender only, unless that sender expressly states them to be the views or representations of an entity or person, who shall be named by the sender and who the sender shall state to represent. No liability shall otherwise attach to any other entity or person. ==========================================================
I will use the target table as a lookup as well when reading the source table, so that I can create a constraint that will only process matching records. This should work.
Dirk
-----Original Message-----
From: Dirk Moolman [mailto:dirkm@reach.co.za]
Sent: Monday, October 29, 2001 3:06 PM
To: Datastage List
Subject: Update existing rows / warnings
I am trying to write an update job that reads from one table (odbc) and updates another table (odbc).
I am linking the keys and column that must be updated (in the transformer stage), and it seems to work ok, accept that I get a warning message for every input record that does not link to a matching output record ("0 rows
affected")
SQLExecute failed.
SQL statement:UPDATE PHDMPRODUCT SET PRICE = ?
where COMPNO = ? and CLIENTNO = ? and COMPPROD = ? 0 Rows affected.
How can I get rid of these warning messages ?
Maybe I should mention that I dont want to disable all warnings. This is just a simple update and only records with matches must be updated (without warning me about the other records).
Dirk Moolman
Database Administrator
Reach Technologies
South Africa
www.thefuelgroup.co.za
"No pessimist ever discovered the secret of the stars, or sailed to an uncharted land, or opened a new doorway for the human spirit." -Helen Keller
==========================================================
This message contains information intended for the perusal, and/or use (if so stated), by the stated addressee(s) only. The information is confidential and privileged. If you are not an intended recipient, do not peruse, use, disseminate, distribute, copy or in any manner rely upon the information contained in this message (directly or indirectly). The sender and/or the entity represented by the sender shall not be held accountable in the event that this prohibition is disregarded. If you receive this message in error, notify the sender immediately by e-mail, fax or telephone representations contained in this message, whether express or implied, are those of the sender only, unless that sender expressly states them to be the views or representations of an entity or person, who shall be named by the sender and who the sender shall state to represent. No liability shall otherwise attach to any other entity or person. ==========================================================