DSXchange

I don't know why your code didn' work, you should add a line
to see what the error text of your CLEAR.FILE command is.

If it is the case that the DS event is to be part of the IBM event.... we can imagine how many milliseconds will be spent on DataStage compared to teh other WebSphere products

Greg - let's assume that your daily rate is $400 and that a normal work day is 8 hours; that means that the annual fee of $50 represent an hour's work (taxes don't figure, since the forum costs are deductable). That means that you feel that membership here will not save you more than hour of worktim...

Seriously? I guess that "what happens in Vegas stays in Vegas" doesn't cut it anymore.

Why do you ask if this is true, I won't intentionally tell an untruth. Perhaps you should take a look at the "Could not load drsoci.so" part your error message and do a google search for that type of message, you will see that it is generated from UNIX and not from DataStage; it means the library co...

There are two ways that hashed file stages access the files - using an explicit path and using the (default) project directory. Hashed files that are referenced by absolute or relative UNIX/Windows paths can be copied from one host to another (being careful to do so when the files aren't in use and ...

gateleys - I understand gmorey's point of view and actions, but this new system needs some time to be understood correctly before it is condemned. Getting a qualified answer is certainly worth $50 - just compute your hourly wage and see how many minutes of your work that works out to. I think it wil...

You neglected to post that to see the forum and poll you need to (a) get a Yahoo! id, (b) read the Yahoo adverts and (c) sign up to see the forum contents. Why not post your poll here as well?

I don't think that database content or structure changes could trigger this error, it is a UNIX error on the DataStage server node.

Microsoft has published a registry API that can be used from Visual Basic and C/C++, but there is none for DataStage to read and interpret the file's contents. But you can always bind in an external program that you write in one of those languages - the easiest way is to create an external .exe prog...

Arun, you should talk with your UNIX admin and go through DBX using your uvsh image and the core file. This will let you do a stack and call trace and hopefully find out more about which part of your job is dying. Debugging a core file takes a bit of experience, a lot of patience and some luck but i...

... And you can delete a post as long as there is no reply to it, so could have deleted the duplicate post. It's a checkbox at the bottom when editing to 'Delete this post' when submitting the 'edit'. I couldn't find that checkbox, so I think I must have hit a "reply" instead of "edit" on the origi...

Try doing a ICONV({YourColumn},'MCP') to convert nonprintable (and sometimes non-displayed) characters in your strings to "." in order to see if you have illegal or unexpected values in there. The most common cause is embedded blanks, but you've checked that already.

The library looks like one for DRS - are you using a DRS stage in your job? Have your LIB settings changed in your environment? Can you find drsoci.so in the path and does your user still have UNIX permissions to it? Can you think of anything that changed in the system or in DS between the time that...

Craig,

That's odd, I just tested at 7.1 and I used the VOC file and was able to set the "rows per transaction" as well as the isolation level...