DSXchange

Some of us have a better work-life balance than you, and do other things on weekends. You have still not advise how you have programmed the stages. For example are you using a state file that you initialize from the database or are you using a database sequence? What expressions are you using in you...

OK, I'll be concrete. I have done three 8.0.1 to 8.1, and always done a clean install. This was driven by mistrust of the internal structures of 8.0.1 some of which, at least, have to responsible for some of the bugs. If you have the choice, prefer 8.1.2 as there are more desirable features.

My "solution" is to return to the forum (the new post shows as unread, but not duplicated). Sometimes I open the "unread" post, sometimes I ignore it.

You do understand that Windows XP is not a supported operating system for the server?

That said, after you have cleaned out all trace of DataStage, you might try installing the server components before the client components next time.

"Amplifying" is the term I'd use.

Ah. What happens while one sleeps!

There is no such thing as a hashed file in a parallel job. You would need server job componentry and this might defeat your goal of speed. Maybe writing to a sequential file would be faster, then invoking a server job to populate the hashed file. If you're feeling really technical, you could use an ...

I recall an email sent back by one of the first Ardent techo people to go into China - "don't worry about 2GB as a file size, guys, here 2GB is a single transaction!" The good news is that the next version of DataStage will have support for much larger XML file sizes, provided your hardwar...

Int32 can have up to 10 digits. Decimal(3,0) may only have a maximum of three digits. Somewhere, something is representing data as Int32. You have to find it.

No explanation - DataStage does as it pleases with column order, for various reasons ostensibly related to optimization. The same thing can - and often does - occur with Peek stage.

Andy's ED set of commands does the same as SETFILE.

My problem is almost always with posting.php which times out. I assume it's something to do with updating the underlying database.

The command to use in the UNIX shell scripts is dsjob - you can Search DSXchange for examples, or consult the manuals.

Code.

It's the only one with common domain.

... provided, of course, that you've created a VOC pointer to any pathed hashed file that you want to inspect.