DSXchange

In case anyone's interested, each hour (or minute) of video requires about 100 hours (or minutes) of preparation and planning. These presentations are thought out, scripted and planned. It takes time and, again, is mainly volunteered time. The premium membership helps to cover some of the actual cos...

DSguru2B wrote:So Texas rules huh?
How many showed up, aproximately ???

Everyone who booked showed up but one had to withdraw early due to the unexpectedly early birth of his child. This news came in at 2:30am on the first day of class.

Is the "bad" PC running Windows XP sp2 and, if so, is the DataStage patch for sp2 installed there?

What exact version of DataStage are you using? Unless it is 7.5x2 you can not expect any success at all. Even that version is not officially supported on Windows XP as the server. Do you have the DataStage patch needed for XP service pack 2?

Surely you require an "official" answer from the vendor (IBM)? I doubt that MetaStage out of the box can capture duplicate records or number of rows inserted/updated (it can do link row counts, but this is not necessarily the same thing). Job log information is not captured by MetaStage - it continu...

1. How long is the entries in the DS_AUDIT table retained? How is the retention period configured? Entries in DS_AUDIT are retained for ever unless manually purged. There is no utility provided in DataStage for purging DS_AUDIT. 2. How do I get the DDL/Schema for the DS_AUDIT table? How do I get th...

Can you do the same measurements using ByteLen() rather than Len()?

Comparing the two (ByteLen and Len) will allow you to detect rows where there an apparent problem. Resolving it won't be quite so easy.

Awaiting your ByteLen() values.

In future, demand at least 12 hours notice of all unplanned outages.

Hashed files have case-sensitive names. If you've created it in the account, or if you have a VOC pointer to it, you can use the predefined DSN "localuv" to access it in BCI functions. Even more efficient, since a self-referential connection has already been established, is to use system variables @...

Yes, you can use DSExecute() with "DOS" as the shell argument, and echo the value of the environment variable. Trim any @FM characters from the output. For example: Call DSExecute("DOS", "echo %MYENVVAR%", Output, Code) If Code = 0 Then MyEnvVarValue = Trim(Output, @F...

There is no "Native Informix" or "Informix API" stage as far as I am aware. Do you mean the "Informix Enterprise" stage? Have you performed any comparative measurements? If so, what were your results, and did you balance for effects of cache, etc.?

Add 31 days to the date (DateFromDaysSince() function). Extract the month and year components of that date (MonthFromDate() and YearFromDate() functions). Assemble the date of the first of that month (by using 1 as the day number with the derived year and month), assembled as a string. Subtract 1 fr...

Without using a partitioned table, you are limited to the speed at which Oracle can deliver rows. For SELECT, the Oracle Enterprise stage can only operate in sequential mode, so that is and will remain your principal bottleneck. Round robin and random are the best algorithms for even distribution of...

Apart from some minor technical hitches (Texas Fried Server) it went well. All who attended went away with lots to think about, and pleased that they had attended. I never put Vegemite on steak, though I always carry some. Vegemite it best had on bread (plain or toasted, maybe with cheese and/or tom...

Welcome aboard. :D

The full structure of the Repository tables is (deliberately, by the vendor) not documented.