DSXchange

It is very much better practice to question why you might need to go anywhere near this size. Only populate that hashed file (note, not "hash" file) with those columns that are absolutely necessary, and only populate the hashed file with those rows that are absolutely necessary. If I may indulge in ...

You are joining on the constant value 'X'.

WebSphere Application Server. Not web application server.

You might like to remove abc.dat from your project directory on the server.

Hi. I have cleared the Upstream partitioning, as mentioned in my query. As regards the main input, is there a specific protocol to be followed while setting the partitioning for input links when using Lookup Stage? As in Entire for reference and (say) Hash for input? There are two possible protocol...

Column references in subrecords use a dot notation. Read the manual more carefully.

No.

Look in the Red Brick Warehouse Messages and Codes Reference Guide to determine the meaning of code 10274. RBO10274E Column column number: error attempting data conversion. Cause: The value you were trying to retrieve is inappropriate for the datatype into which you wanted to store it. For example, ...

Why not use a design that has two Oracle stages; one to select the filter values and the other to use those values (transmitted through the job as column values) to do whatever they need to do?

Why are you running a DataStage job that calls a UNIX script to run other DataStage jobs? This is hopelessly inefficient, and introduces unnecessary potential causes of error. You should prefer to use a job sequence. Or, if you must call other jobs from one job, prefer the UtilityRunJob() routine th...

I don't believe so. That really depends, however, on what you're using to display the data. The newline character might occur - even legitimately - in any field in the data.

You may find it easier to restart the DataStage services, which will also work, even though it's overkill.

Does smit update the KEON records of user IDs and passwords, or do you have to manage user IDs and passwords twice?

Wolfgang, you need to get in touch with Walter (the webmaster) because of the problem with not being able to set the status to Resolved.

As to the rest of the answer, think back prior to version 3.0 - I know you were there!

Forbid the use of Monitor. This also locks jobs.

Does anyone open job properties in Manager? Lock! Ban their use of the Manager client for this purpose also.