DSXchange

Pivot stage.

The 'huge waste of time' comment was strictly for exporting as XML and then re-importing, as the first thing it needs to do is convert the XML back to DSX format before it can do the actual import. Hence the comment. Yes, I've used XMLSpy. There was no assumption of an issue there, but more of a sp...

No worries... I've got nowhere to go as we're basically snowed in again. Keep in mind the fact that you'd only need to pass any values that you need to override, that is ones that you can't use the default value for. I've found that generally means that most of them can be 'ignored' at the command l...

No. The only parameters you can pass in are for the job you are attempting to run. So all parameters must be defined in the Sequence job and the Sequence job is responsible for passing whatever parameters of those are appropriate to each individual job it runs.

Asked and Answered.

Ok, my mistake... I generally don't bother with exporting anything as XML as it's typically a huge waste of time on the import side. Curious why you would be doing this but that's probably a question for another day. A couple of other points on my ranked as 'oh so unhelpful' post. First off, why bot...

I use write medhod UPSERT with upsert mode Update and Insert,but performance is very bad.When i use Insert and Update mode,performance is very very good but data is doubled if the data is already loaded before. You need unique indexes of some sort, PK or otherwise, to make anything like this work. ...

velagapudi_k wrote:The problem with this is If one job fails and the other 3 are running fine,the 3 jobs will be forced to abort by TERMINATOR.

So either don't use a Terminator stage (did something make you think you 'needed' it?) or enable the option in it to 'Abort without sending STOP requests'.

That support requires the use of the STP or Stored Procedure stage. I'd suggest you use that rather than ODBC if you are on a 7.5.x version of DataStage.

Oy... and never you mind about my petard, you shiftless wombat.

Curious if you know that syntax works for multiple parameter value pairs? I've always done it this way in my scriptage which I know works:


AFAIK, each pair must be proceeded with -param for it to be recognized properly.

Not sure what you mean by generating DTD information 'at the same time'. There's no export option for that. Are you using XML Spy to generate the DTD? Can't say that I've ever actually tried that. You do know there is a DSExportSchema.xsd file in the DataStage directory on your pc, yes? No DTD gener...

I know that Conventional Wisdom says you'll be fine as long as no-one is connected to the specific project you need to reindex. However, I've typically found that it probably isn't going to work until you get everyone out. And even then you're best off bouncing the DataStage server first to clear up...

Ok, can't help you with the DB2 stage but perhaps someone else can. Keep in mind that if the 'minimum possible time' involves tweaking those 500 jobs then include that effort in your estimation of the 'minimum'. Sometimes you gotta do what you gotta do, even if it doesn't 'go well' with the team. As...

Repeating your problem without answering any of the questions posed so far gets us no closer to solving your problem. Have you looked at the file more closely? Via a hex editor perhaps? Are there 'blank' lines or other anomalies at the end after your last data record? I would certainly think so as ...