DSXchange

Check Craigs reply here. He has a link to IBM's eservice site. You can get the patch from there.

Make your target length 9. I think the decimal field will contain the decimal point (trailing dot). Confirm that by passing a few records to the peek stage.

Replace the dot(.) in the column name with an underscore and see if the error goes away. Also, I believe the output requires an extra column which tells you what column changed. Look into the DS help for the stage.

If you dont have any precision defined that you need to give the second parameter as "suppress_zero", I believe. Refer here

That could only mean that your populating in one environment and looking at another? Or infact your updating instead of inserting a non-empty table.

Sure. You will find posts for your guidance. Have you tried searching. Did you go through Parallel developer's guide. That will be of most help.

Try handle_null().

Thats the very reason I wanted to give my 2 cents on transformer. But it all sprung from a misunderstanding.
Cheers.

O ok. For some reason I thought the transformer was under attack, yet again.

In the transformer, if the 2nd paramter is not a constant, performance is very poor! The performance has been drastically improved in all 7.x versions. Hence you cannot claim that transformer is "very poor" in performance, unless your using a version lower than 7.x. It still cannot beat modify stag...

Work tables meaning staging temp tables. If your working with files then load them into two different tables. If your source is a file and the lookup is a table then load your source into a temp table. Bottom point, both your source and lookup data should be in tables. The reason for that is you can...

Welcome Aboard
Please be advised that most of the common topics have been discussed in detail. Utilize the searchfacility extensively.
You need to identify your inhouse enterprise scheduler. Get in touch with them. They will help you set this up.

That means your metadata is not identical in both (while building and while reading) the hashed file. Its off by a column. Another method would be to load the files to work tables and pass a sql join and grab the columns that you want. P.S: If you call a hashed file , a hash file, you will be smacke...

Did you try it yourself. Look the awk code ganesh sent. $2 != "" tells you that if the second column is not empty. You can put an 'OR' condition and check for space in there.

Also, Ken has a "Unix Survivor Guide" on his home page. Go to www.kennethbland.com