DSXchange

Are you running in sequential mode in 8.1 and two node parallel in 8.7?

What expressions do you use to generate your counter?

I'm not sure that would work. For example if Version 7 were missing, when processing Version 8 you'd be trying to compare against Version 7 when what you would want to be doing is comparing against Version 6. However (and I suspect this is what you were getting at) you could generate a completely ar...

bond88 wrote: how can I initiate/control from DataStage?,

Easiest is an Execute Command activity in a sequence to initiate a sqlplus command (script).

The arithmetic is just as simple if you are looking to compare the number of records that match with the total number of records processed. The counts can be determined with an Aggregator stage.

Once the table has been created you can use the Truncate table action.

And, of course, note that 8.5 FP3 (at least) is out there, so you're behind with your fix packs.

Change your date format string or your CENTURYPIVOT setting so that two digit years don't default to the twentieth century. Perhaps

If this is Oracle to Oracle you may find that doing the whole thing within Oracle using Oracle utilities is faster. You may still choose to initiate/control that from DataStage. If you prefer to use DataStage to design the approach, and you have Balanced Optimizer licensed, try using Balanced Optimi...

If you have an unbroken contiguous set of Version values use a Column Generator stage to generate (Version - 1), a Copy stage to split off a stream keyed by (Version - 1) as Version, and a Compare, Difference or Change Capture stage to identify the changes. Finally a Filter stage to exclude those wh...

Too many DBs in "=#PS_DB_CONN.DB_DB_PSWD#".

Well done on the sharp eyesight!

What, one that works on any instance of SQL Server running on UNIX?

I don't believe so.

Here's how I'd do it. Create Data Connection. Create associated Parameter Set. Load parameters in Parameter Set with environment variable references. The Add Environment Variable button should not be disabled; it's enabled on my site. Take that particular issue up with your official support provider.

Sounds like something is interfering with detection of the job exit status. I'd place a routine that logs the $JobStatus activity variable value for the job immediately after the Job activity, and temporarily disable "automatically handle activities that fail", to determine whether $JobSta...

Prince_Hyd wrote:I'm not a premium member so i'm not able to see your solution completely.

You wouldn't have missed much, so I've exposed it. Please consider getting yourself a premium membership; it's not expensive and well worth the cost, plus it helps to keep DSXchange alive.