DSXchange

nagarjuna wrote:I think these features are introduced in 8.5 version .Make sure that you are looking in 8.5 datastage version .

Hmm, for datastage version below 8.5, 7.5.2 specifically, how to do the environment variables exporting/importing?

Thanks for your replies, everyone.

Yes, I'm using DS8.5.

As to the ID, I'm not using dsadm per se, but the ID I used is the DS/QS administrator. This should be good enough, should it?

Thanks

Thanks for your replies, everyone.

Yes, I'm using DS8.5.

As to the ID, I'm not using dsadm per se, but the ID I used is the DS/QS administrator. This should be good enough, should it?

Thanks

I believe single quote will work for special characters like '$', etc.

@asorrell, Thanks a billion for such a useful post!
I was about to dig myself.
Thanks for the tremendous time-saving I can have.

Hi, My mind is blocked. I remember that I've seen the Exporting/Importing environment variables command icon before but I can't find them now. Here is the details. I'm following Exporting environment variables http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=/com.ibm.swg.im.iis...

Thanks, chulett & eph .

how do we get the column name which failed validation.

- capture to sequential file.
- in the property of the sequential file, tick the output field name option.

posting off the top of my head, actual wording might be different.

The default extension of the archive file is .isx.

Is the .isx archive file still text based or now binary?

thx

Is there any smart way to achieve this in single transformer?

Do you have to use transformer?

Pivot is exactly designed for such task. Check out
viewtopic.php?t=142442

oh, yep, thanks.

thanks everyone for the replies.

I'll amend my best practice, adding the following:

- Hash partitioning is required to have the same has key for all streams that require matched key values
(e.g. Join, Merge, etc)

You would need to create a custom routine to go get whatever error messages you wanted from the logs of the jobs the sequence ran. That's kind of expensive. No wonder in our place, no matter how many jobs you can run in parallel, when put into a job sequence, we don't let then run in parallel but s...

- Yes, you are allowed to include a constraint expression when you mark it as an 'Otherwise' link. - Yes, you are allowed to have more than one 'Otherwise' link. I.e., both answers are yes, but it is actually impossible. -- At the end of the day, no matter how many 'Otherwise' links you've ticked. t...

Hi, Sometimes DataStage jobs may have warnings. Most common ones are the default type conversions. Some places don't allow any warnings in jobs. E.g., no default type conversions allowed, have to convert explicitly. I just want to have a feeling how warnings are treated in different places. Please r...

I can't help answering any of your questions but I got one more.

How often do you use Job Parameters such as #DSHostName#, #DSProjectName#, #DSJobName#,

Can these default Job Parameters be used to initiate other user defined Job Parameters? If yes, how?

Thanks