Question

Update sql table values from sybase DB using Workflow

Workflow

Updated June 12, 2015

asked on June 8, 2015

Hello LF PPL

My customer has a problem while using WF to update sql table values from a Sybase DB.

we use query data to retrieve all columns to be updated, However while configuring query criteria we want the values of the same column rows to be retrieved and used as new values in the sql table.

I think we can't use this tool "query data" to retrieve the same column and it's rows.

Any suggestions ?

0 0

Answer

SELECTED ANSWER

replied on June 12, 2015

Am I right to suggest you want to compare one database table with another. If you find that there is a difference, you want to update one of the tables so that they both contain the same information? I believe you need a combination of Query Data and Insert Data activities:

Retrieve values of a row from both tables (2 x Query Data activity)
Use a Conditional Decision activity to see if there are any difference in the values retrieved from the tables.
If yes, then update the row with the right values. (Insert Data activity).

Workflow help files will be extremely useful if you need help configuring these activities.

1 0

Replies

replied on June 8, 2015

It sounds like you want to use the Update Data activity not Query Data.

0 0

replied on June 8, 2015

Update Data will be used to update my sql table ... But this step will be done after retrieving the new values from the third party system DB table.

The required process is retrieving all the values of all rows for each column and replace the values in the sql table.

0 0

replied on June 9, 2015 • Show version history

Can anyone help with the workflow design configuration??

0 0

You are not allowed to follow up in this post.

Question

Question

Update sql table values from sybase DB using Workflow

Answer

Replies

Sign in to reply to this post.