DSXchange

If it's a production project, then the job may have been made read-only when promoting the job using Version Control.

Or someone in the past has discovered how to toggle the READONLY flag.

Get yourself a copy of The Data Warehouse Lifecycle Toolkit by Ralph Kimball and others (published by Wiley). Chapters 4 through 7 will be of particular use in answering this question. It's a full exposition of the requirements and techniques of dimensional modelling.

Was this "contact at Ascential" a technical person? You don't have to change anything in the UNIX kernel to change ulimit.

... provided, of course, that your DSHOME environment variable has been set!

You may be able to use the form if your DataStage installation was not an -itag installation.

Reset the job in Director. Is there any message "from previous run..." logged? Set a pointer to the hashed file using SETFILE. Then you can execute queries against the hashed file, such as counting its records or running some of the analysis/tuning commands such as ANALYZE.FILE against it. It's like...

Definitely the most frequent error in DataStage is between the keyboard and the chair.

EXCEPTION_RUN.sh tries to invoke seq_ntwx_email_script_ph2.sh but can not find it. This is because the directory that contains seq_ntwx_email_script_ph2.sh is not mentioned in the command search list (the PATH environment variable) for the user ID under which the DataStage job was run. Either correc...

The figure of 40310 suggested that your SDKSequences file was holding 40310 sequence names and values. That's why I asked you to count it. By default, SDKSequences can contain only 512 bytes of data (separation 1). I prefer separation 4 which is closer to the page size used to transfer data between ...

I'm not aware of any way to enable stage tracing when run from a job sequence. As a workaround, copy the generated job control routine from the job sequence into a server job, edit that code so that the tracemode is set (get the values from the Director log of the job itself) and execute that.

Is there not an optional "Decimal Type" property where you can set precision and scale?

I recall reading something about this in the manual. Don't have access to DataStage this week, but I'd hazard the guess that it's the Parallel Job Developer's Guide , and the chapter on the Oracle Enterprise stage. The same problem can arise with DB2. Both "#" and "$" can be troublesome to DataStage...

beaulie01 wrote:Ray,

So if I understand well, there is nothing I can do? It's because I want to reduce the volume of my XML output file.

Thanks! :D

Your volume won't change (apart from a few line terminators) - you have exactly the same amount of XML in both formats.

The Partition Table property allows you to specify a table that provides the partitioning algorithm. If you are selecting from a partitioned table, you can use the same table name as the Partition Table property as the table name from which you are selecting. You can always click on Help to learn mo...

"ASCII" or binary transfer? Take DataStage out of the picture - do an FTP without DataStage to determine whether your FTP mechanism is the culprit. ... Hi Ray, Thanks for your information and early reply tto this problem. I tried doing that it still didnt worked the moment it is going to some other...

Can't you simply use the Business Manager role to allow this?