DSXchange

Make a step by step approach to the use. Start with something like "ls >abc.txt" and continue step by step. Remember the User on Unix directly may be different to the one in DataStage (most time dsadm). Compare if it is both the same shell. Maybe you have to execute a sh before. By step-by...

as Ray already said is, that we need more information, what you finally want to reach. Rejects and Removing Dublicates is a strength of DataStage.

Only if we knew, what you finally want, we can give you a good solution.

Okay, than I will wait until he is once "on" again. He was off from the DS-Community (at that time Oliver was the meeting pot of the Community) between 11th September 2001 and November 2004. The old Central-European-DataStage-Soldiers will meet for a Whisky in Frankfurt next Tuesday, so I ...

hi nick,

try without "-ai"

Hello, it is a good feeling to be together with such a big community. One of the values is the contribution of all top-posters which spent a lot of time to answer and discuss questions. Thank you all. Who has new about top-3 Poster ArndW? His last post was 8th Dec. Did he have an accident with his b...

(1) Set the parameters in the profile of your different user and nourish them by operationsystemparameters, so you never have to edit anywhere within DataStage.

(2) Use Version management.

when reading a flat file with the Server Edition, best practice is reading first each field as Varchar-DataType and checking and transforming any field in the first transformer Stage.

Balaji is right. It is not easy to find the right size. As he said a good rule of thumb is to balance between both size when reading and writing. The one has to be same or factor of the other. 5-10 or 10-5 is okay, 10-12 or 12-10 is suboptimal. Same is true with commit size. If there would be an opt...

DataStage is no Tool like MS-Excel, which you can roll out to everybody who can calculate that 1+1 is 2. Don't give the product to anybody who hasn't had at least a 3-day-introduction into the product. Better is a one week training. Don't give the product to anybody who doesn't work with product at ...

Ray ment tabulator and you mean Worksheet tables. Thats what might happen with abriviation. Better you write "you" instead of "u". Here you are in a professional and international forum. If you don't write a good english you will often been misunderstood. You can use Excel with D...

Shane, you may profit (if the rows in tables in ORAOCI8a are few relative to Seq1 and Seq2) filling the content of ORAOCI8a into Hashfiles. I suppose that none of the tables in ORAOCI8a is filled in OORAOCI8b otherwise you should use transaction size 1 and no hash files. Maybe that the way you made ...

hi joseph,

before you do anything to the index you should perhaps invest into investigation and get more simple solutions. If it is an other reason you may do more harm to DataStage than you need to.

Generaly the increasing number of stream should be an advantage and not a dissadvantage. Give me more details on your streams.

Maybe that via interim sequential stage you can increase performance.

go to the server and use on the Command line the dsjob statement for to see if you get there job details.

write before the line:

echo 'Procedure Started.'

the following lines:

echo "USER=${1};"
echo "PASSWD=${2};"
echo "DSN=${3};"
echo "PARAM=${4};"
echo "SCHEMA=${5};"

for to see if all parameters are correclty set.