Where condition in custom schema of data-deploy

Hi,
Environment Details:
TS 5.5.2
Solaris 8
DataDeploy 5.6.0

We have Implemented data-deploy with custom schema.
While modifying dcr and deployment, data-deploy creating update statement and putting all the row in WHERE clause (default behavior).
I want to define only one column (Primary Key) in WHERE clause.
I am attaching DataDeploy configuration file.

Saumil
BTWholesale | CMS
Mahindra British Telecom

Find more posts tagged with

Comments

Michael

Hi Saumil

Not entirely sure what you mean here. Perhaps you could post your log file and show us what you are talking about.

And perhaps also explain why the current behaviour is a problem...

Cheers
Michael

saumil

Hi,
can anyone please help me.
how to change configuration so only 'Primary Key' comes up as part of WHERE clause in update statement.

Regards,

abhi2005

Hi,
can anyone please help me.
how to change configuration so only 'Primary Key' comes up as part of WHERE clause in update statement.

Regards,

Saumil,
I have gone thru your config file. Well, if you want the default behaviour to happen, you might want to check the columns in your db schema and the way you have defined it in your config file. it might happen that there is "definition" error in the way it has been defined in the config file. try comparing both.
Thanks,
Abhi