DSXchange

:oops: Sorry. I confused myself. trobinson can see everything in the quote. Interestingly, he can't see any other Posters who post Premium content. Can you Premium Posters toggle Premium content on/off? Ray, is this what happenend with the quote? I am throbinson and never deleted the original trobin...

Chulett you're too quick. I replied with the wrong Member id (THROBINSON is a Premium Member and has been since 1969. Lee and I used to cheat on COBOL exams in the 3th grade).

Give me a sec to get it right.

If Ray will reply with a long enough reply I will test this since I am not a premium member.

I would probably go with transaction grouping but another possible method would be to capture the REJECTEDCODE/REJECT of each preceding link and coding a utility job abort if any of the 15 particular ODBC stage links returns something other than success.

The MQStage is capability of keeping the job alive and listening for messages by itself 24X7 if required. No Sequence looping mechanism required.

Is that right? Perhaps we don't have the EE plug-in. I was unable to get the MQStage on the EE canvas. Is there a special EE plug-in for MQseries that is separate from the Server version?

I don't believe MQSeries is available to an EE job, only Server. In a Server job your design will work.

It appears you can do the e-mail notification in at least three places; 1. Wrap your DataStage in a Sequence and do the e-mail from the Sequence. 2. Wrap the DataStage job in a UNIX script and do the e-mail notification from the UNIX script. 3. Call the DataStage job from Autosys and have Autosys ma...

This looks like a good general explanation:
http://openqm.com/HTMLobj-79/Dynamic_Files.pdf

I work in UNIX and darn glad of it, so I ain't no Windows Guroo with fancy pants MS certifications but isn't there a way to have a master Excel spreadsheet with pre-defined worksheets that point to other *.csvs?. In other words, the Master .xls has n number of tabs which are merely references to the...

If you don't give a path then the Hashed file will be stored in the Project subdirectory on the Server.

If UNIX then

cd `cat /.dshome`
cd ../Projects/<Projectname>

I hesitate to mention this as I don't think it is a good idea but if you really, really didn't want to alter the guts of the DataStage jobs you could overlay the Oracle tables with views that did the NULL handling and anything else that makes the Oracle source behave differently then a SQL Server so...

By empty, I assume you mean NULL.

One cannot concatenate fields that contain NULL. "Nothing" concatenated to something is not possible. The result is "nothing". You could test for NULL and then concatenate a true empty string. That is '' (tick tick).

No problem. It is a pain. I assume you have a Column Generator in your job? From the columns tab, highlight the field that is cycling. Using your mouse , double click the number to the right of the column name. This should bring up the Edit Column MetaData window. The bottom middle box should be pro...

Instead of cycle select random from the Column Metadata window. Set the limit to 10000. It starts at 0 I believe.