DSXchange

2GB is much bigger than 300MB. 2GB is special, as it's the largest address that can be accessed using a signed 32-bit pointer.

You tell us.

The error message contains everything you need to know.

Check on the server machine to determine whether or not the .o file exists. If it does, which environment variable governs shared library search path?

Welcome aboard! :D Do you just want the file names, or the contents of those files? If the former, simply execute the command - perhaps as a before-stage subroutine ExecSH - then use a Sequential File stage to read from the file myfile.txt. If the latter, and you really are in a parallel job, use th...

Read the chapter on Custom Stages in the Parallel Job Developer's Guide.

As far as I am aware, CASE is only possible in the SELECT clause of a SELECT statement. I am unaware of it's being legal in an UPDATE statement.

Can you execute such a statement legally in TOAD or sqlplus ?

The same job was running previously without problems.

What has changed? "Nothing" is not the correct answer.

That is a very limited solution, Ramesh. I suspect the OP showed us sample data, not the entire set.

In your design you already have the required result in the stage variables - why do you add a hashed file stage ?

Aha! That requirement was not in the original post. How about a DataStage job that moves the contents of the hashed file (or UV table) RT_LOGnnn into a text file? You could then build a job sequence that runs your main sequence than that server job. Presumably the job number of the main job sequence...

In Director choose Print from the Project menu. Then, in the common print dialog, check the Print to File check box. You will get another dialog asking you to specify the file into which the (text) report will be written.

This is what's known as a "vertical pivot". Search the forum. It's been discussed more than once. There are several techniques, depending on various factors.

Start the job monitor. It's stopped for some reason.

Impossible to say. Presumably there will be no loss of rows through the Transformer stage, so my guess most of the time would be "no difference". Another possiblity, of course, is to invoke the UNIX sort command in an after-job subroutine, perhaps ExecSH. In rhat case, you don't need any form of sor...

You need to truncate the data explicitly, for example Left(InLink.Col1,2) I suspect what you're seeing results from C string handling; in C a string is an array of characters, and all array indexes are zero based. So you're seeing Col1[0], Col1[1] and Col1[2]. But that's just a guess. Do it ...

It's not a need, it's a preference, because you can allocate more memory to the sorting operation when using a Sort stage. As far as I can recall, memory per partition is limited to 20MB on an input link sort, but is configurable as a property when using the Sort stage. The more that can be done in ...

It's your idea Kumar_S - you run with it. Prove to us, or otherwise, your hypothesis that a Lookup File Set can be updated in real time; that is, that the import operation that maps it into a virtual Data Set is sensitive to changes in the underlying Lookup File Set. The alternative possibility is t...