DSXchange

It's not really about large versus small, it's more about what you intend to use this for. Sequential files take less physical space for the same amount of data and are 'portable' across applications. Datasets are specific to DataStage and mirror the in-memory footprint of the data inside the job. U...

Database? As in which one are we discussing here?

Database? How many records do you need to update?

I'm going to take a wild-assed guess that this isn't a TX question. Moved.

You get ^M characters on UNIX when you create a DOS output file.

Split the field, convert the second 'half' to a number and then sort on those two new fields.

:!: It is very poor netiquette to 'steal' other people's work and post it in its entirety, even worse to do it with no reference as to the source / original author. Luckily, it was easy to recognize a blog post from our friend Vincent. Next time, simply post the URL. To see the contents, click here:...

Already had this 'conversation'... once again I've had to change it for you.

Append will create the file if it doesn't exist. But that will also mean it will append to the previous run's file rather than replace it so you'll need an extra step. Before you get into your loop, ensure the file generated by the previous processing run has been deleted.

Hmmm... not sure about the 'risky' part but I guess that might depend on the PeopleSoft people who are providing you guidance. We didn't have an "packs" installed, our PeopleSoft targets were just plain old Oracle tables and I don't recall having any issues populating them just like any ot...

... and (belatedly) off we go to General land.

The latter. Unless, perhaps, your official support provider can provide the details?

Why are you using a trigger column? Do you understand what that does?

Searching for your errors here would show that you need to "source" your dsenv file first. I also changed your subject to be more descriptive, everything is about "DataStage" here.

Picky, picky, picky.