DSXchange

Why the hope? IsNotNull() is a perfectly valid function.

I for one am a little confused here... why are we mixing database terms like DB2 and stored procedure with CFF, copy book and 88 levels, which are COBOL related?

Keep in mind that site just publishes material ripped off from official sources and that is the old tutorial from the 7.5 Server release, hence no mention of any PX stages.

Oh my, another Wurlod Groaner.

Or that.

Non-significant zeroes are not part of a "decimal" format. If you want to preserve / add those, you'll need to target a string and use a function like FMT().

I would imagine it is because the job is still running, what happens if you call it in a routine after job? Also, what do you need this information for?

Wet little squishy organic files.

For something like that, as noted, I would contact your official support provider.

What makes you think there is only "one word" involved here?

While I agree that I don't see turning both 'on' as a good idea, it's obvious they've allowed for that because there are two separate variables that control it. If they wanted to ensure it was always one or the other, they would have used a single variable. One would certainly hope so, anyway. From ...

I'm sure there are resources and peer groups for Neteeza like this one for DataStage out there somewhere, those would be the proper place for questions of this nature. IMHO.

srikanth386 wrote:also my requirement is the out put dsx will be in readable format.

I'm curious what this means. Do you consider a dsx file to be a "readable format" or do you mean you are required to transform it in some manner to make it "readable"?

My DS enviroument sequence jobs are logged before and after the main job. Each sequence job call a parallel job to insert the execution time, etc (meta data) into a database. After the execution also. (I inherited the enviroument like this from the begining. ) I understand you inherited this but a ...

Universe is a database as well and when you get right down to it, all databases store data in 'files' of some kind.