DSXchange

If i want to sort in an order like A, D,C,B Sure... can do! From inside the Sort stage, check the Property Help for the Sort Specifications field. You see mention of the ability to create a 'collating sequence map filename' which lists the custom sort order you'd like to use. Also check the online ...

Check here for thompsonp's response, see if that helps.

It would be a little more readable if it was written:


Same functionality, however.

You might want to explain that a wee bit more.

True... that *is* a good practice, but as you noted not likely to reclaim much disk space. Ken has noted the Prime Suspects - huge job logs and errant crap that people have 'accidentally' put in the project. Start with the logs. Use Kim's script to help you find the biggens.

If this is the case, check with the necessary permission of your user id in database connection. Can you able to run the job? Can you login to the dabase using user userid? What in the world would this have to do with not being able to open the stage in the Designer? So ecclesr, it's all about your...

Too bad they're on a Windows server. You could use a regular 'dir' command and find the last entry, or this and take the first: dir /b /o-n *.txt Bare format, Order by name reversed. Coding this using DSExecute makes the 'get the first entry' easy as the variable used to capture the screen output is...

Wordy Harry. It was within the great stony nostril of a statue of Landrick the Elfin Vicelord that Frodo's great uncle, Jasper Baggins, happened to stumble upon the enchanted Bag of Holding, not to be confused with the Hag of Bolding, who was quite fond of leeks, most especially in a savory Hobbit k...

Well, that doesn't make a whole lotta no sense. If it only happens on your pc ... and it doesn't matter what server project you connect to... then it's an issue with your pc. Try reinstalling the client software without uninstalling it first. Reboot. Try again, let us know. Worst case, reinstall Wi...

We tried to stop DataStage server engine. but the status remains same. Of course. It's just a status flag and since now it will never get back a 'completed' message, now it's really stuck showing 'Running'. I cleared the status & log files from director and refresh it. but still the status rema...

Reinstall your client software.

Ah... nothing like a CRC post to bring Michael out of the woodwork.

Not so much "the OCI" as Oracle itself. That's just the way it works.

We are loading a hashed file into an Oracle table using ORABLK stage. And we also have a shared container which is used for 'balancing' purposes. So... where exactly is this process going wrong? In the Shared Container? What exactly is in it? And you are spooling a hashed file directly into the ORA...

But it should still 'work' as in capture rejected rows. How are you defining the 'reject' link - check the option, via a constraint, both, what? And when you use those 'combo' update actions, never expect the first action to generate any rejects, that failure is what drives the firing of the second ...