DSXchange

The main difference is that they are completely different products. Ill-advised marketing lumped them together under the same name. DataStage server edition began life as DataStage, a UniVerse-based application, vendors VMark, Ardent, Informix, Ascential, IBM. DataStage enterprise edition began life...

Search

Both of these questions have been answered (more than once) in the past.

Always interested to hear suggestions for tips pages, etc.

yields the date of the first of the month. That should get you going.

With cron I find it's always better to supply fully-qualified pathnames.

As to whether you need the "." command (or the source command), that's really a matter of personal preference, or whether or not "they" will allow you to have "x" permission on your scripts.

Welcome aboard. In my experience it's not possible to schedule anything from UNIX when it's stopped. Would you like to elaborate on what you mean? If it's the job that has been stopped (rather than UNIX), you will need to reset the job before it can run again. The easiest way to do this is to create...

Your job must not deliver the key column to the OCI stage. Then you only have the two non-key columns, so you require precisely two parameter markers in your INSERT statement.

Look outside of DataStage too. You have (apparently) a ten-way join happening in DB2. Is this being properly assisted by indexes? Are there some rows that would never be needed that could be eliminated by other WHERE constraints, also assisted by indexes? Make a little job that does nothing else tha...

THE day, of course. (The day he puts it there!)

Other material has been prepared, and more is being prepared. Since DSXchange lost its excellent webmaster (Walter), the remainder of the crew there have been floundering a bit. More than one attempt has been made to replace Walter, none successful yet. Please be patient. To whet your appetite, here...

Identify the first day of the month. Lots of ways to do this - for example look at the MONTH.FIRST Transform. Determine the day of the week of that day. Again, lots of ways to do this, but Mod(TheDate, 7) is probably the most efficient. 0 is Sunday, 6 is Saturday. Add the right number of days to the...

Give examples. The mantissa of 5768.01 should be 576801 or 5.76801, depending on the convention you are using, never 1 or 0.

Reading between the lines, it appears that you need to compare the original number with itself having had a Floor() function applied.

Welcome aboard. The easiest is to use a Copy stage or a Transformer stage with 24 outputs. Use a Copy stage if there are no columns to be added; use a Transformer stage if there are. You could bring all 24 links back together using a Funnel stage, or - if the time is a key column in the target table...

I wrote a job eons ago - to dump table definitions in various formats - that was adapted by Kim Duke into a function called KgdCreateDdlMetadata; information about it can be found here and the function itself can be downloaded from Kim's web site