DSXchange

try getting rid of the comments /*+ PARALLEL(a,4) */

Sometimes Ray isn't too gentle with simple questions. You should really read the Parallel Job Developer Guide. But in this as in many instances the answers are not particularly apparent. Try page 606 under date and time functions. Convert 6 hours 30 min to seconds and use TimestampFromSecondsSince f...

38,10 is not a valid decimal. 38.10 would be

38,10 is not a valid decimal. 38.10 would be

Interesting discussion - I have no knowledge of Blade but to answer the original question, it sounds like the advantages of Blade are the preconfig of Metadata Server and Tivoli. The usage of multiple CPUs by Server should be the same as any other multi- CPU box. You can run multiple DataStage jobs ...

OK - first I'll assume you are really using DYNAMIC arrays as suggested before and your code looks like the following. I am usiing [] square brackets because the less than sign and greater than sign don't post PARAMS = '' ; * this initializes the array variable ArgString = DSGetJobInfo(DSJ.ME, DSJ.P...

There is a client patch for this problem. We installed it about a month ago. I am no longer at the client and cannot give you the specifics but check with IBM support.

We have been getting this Unknown Name error message intermittently and thought it went away on a reboot of the client (that did work once) but now it seems to happen almost all the time and cannot fix. Does anyone know the patch number, so that when we report it we can get the right fix ASAP? We ar...

We have been getting this Unkown Name message intermittently and thought it went away on a reboot of the client (that did work once) but now it seems to happen almost all the time and cannot fix. Does anyone know the patch number, so that when we report it we can get the right fix ASAP? We are on Da...

:wink: I went back and double checked and then ran some tests. You are correct in that the user variables always get rerun on a restart. So if the variables are defined as static or coming from an external source, everything is OK. I got into trouble because one of the user variables was gotten from...

There is no checkbox for "Do not checkpoint run" in the User variables stage.

I am finding that if I restart a sequence, the user variables are not saved. Is this a bug or am I missing something? If the user variables are referenced after a restart (in which the user variable activity is not run again of course) they are NULL. This makes the sequence NOT RESTARTABLE. We are r...

:?: Like the old man in Moonstruck, "I am so confused". My IBM S.E. says he can't finid any such Word doc. It ain't official. I am having a heck of a time finding my way around this Workbench. I can't find any 'stitching' anywhere. I searched the whole Help text and found zip. If you have ...

I have just started evaluating Metadata Workbench for a client along with the rest of the suite. DataStage is already in use and that's it so far. It has been 8 months since the last post to this topic and there is still no user guide or reference other than the Help screens. Of all the tools in the...

I have read through the SCD stage documentation and it is not clear what those limitations are and just how I would identify if my design does or does not fit the design of the SCD. The first thing I notice is that the SCD stage seems to think that a given source stream provides an update/insert to ...