DSXchange

Yes, you should be able to use the CFF for this, provided you know the data types. Did you try ASCII yet, do things look better when you do?

Well, ok... granted I wasn't expecting to find a Silver Platter answer out there, but was hoping there would be a technique that could be leveraged. And I'll be the first to admit that while I did search to see how many matches there were, I didn't dig too deeply into any of them. :wink: Sounds like...

No, that's not EBCDIC.

Really? An exact search for "between two dates" returns 50 matches, a number of which are for Parallel jobs. You sure there isn't something in there of a helpful nature?

So, at run time? You haven't specified it correctly in the stage if you can find it but the job can't.

uvregen will make any changes you made to the uvconfig file 'real'.

Maybe? Pass in the full pathname, or provide the path as a separate parameter and combine it with the filename in the Sequential stage property.

All this time and you never checked the status of the job the loop runs?

Sure, that or a lookup to determine the proper action. I much prefer explicitly controlling the action rather than letting the database figure it out and possibly burning two operations to do what should just be one. And it's not about primary keys, it's about unique key values, indexed or otherwise...

Please learn how to copy/paste properly so we don't continue to get crap like this in your posts: Ask a Question DataStage| The DataStage group is for the discussion of technical issues that arise during the installation or daily administration of IBM InfoSphere DataStage software. Home | Invite Pee...

Connect how/where? What exact version of DataStage? Is this your first attempt at DB2 connectivity or has it worked in the past and it no longer works now or for this particular connection?

All kinds of ways. As noted, both the Before and After Job areas support ExecSH as an action. There is the Execute Command stage in Sequence jobs. There is a DSExecute() function that can be used in BASIC routines or in hand-rolled job control code.

Again, your question has already been asked and answered here. Did you search as suggested?

That's the theory yes, as long as you are certain it is happening in that order... for anything of that nature, the second action is only triggered if the first action 'fails'. Sometimes, though, that 'failure' for an update can mean 'more than one row was updated' but that's not what is happening h...

I don't know squat about DB2 but yes, wondering how much of this could be put on DataStage's shoulders and how much was the database 'setup' itself regardless of the tool being used?

Well, here's hoping your dirty addresses are still getting cleaned, that you didn't have to sacrifice one for the other.