DSXchange

Interesting, thanks. Was wondering what made you reply to a four year old post. Sure that's not just another of those infamous 8.0.1 bugs? If I can get my 8.1 client working, I'll see if I can test that out later this week.

For some reason, it thinks they're pdf files. Right-click on the link, 'Save target as' then after it's down rename to have a .dsx extension and you should be fine.

You could have built your 25 jobs days ago and be long done by now.

Except there's no file. :wink: I'd do something similar in a loop, but rather than WFF call a Server job that checks the table and passes back in USERSTATUS whether the condition was met or not. Add a 'sleep' Routine Activity so it doesn't just race around in the loop at high speed. Branch out of th...

Is a 'Sort Funnel' something new in 8?

No staging required. Codes are simple, you've got a ready made 'group id' in the company number, just add a 'D' or 'S' code and they'll sort back together into the proper order after the aggregator and funnel. Drop the code after that as it has outlived its usefulness at that point.

I've done this by assigning a 'group id' to each set of records and a code for 'detail' versus 'summary' then carrying that forward. Then after you've split and summed, you can use those codes to get everything in the proper order by sorting after you funnel everything back together. Lastly, you can...

Dang.

From what I've seen so far, think of 'scratch' just like you would think it should mean - temporary storage. And 'resource' more as persistent storage.

Oh... and as mentioned, there are ways to build a hashed file with X keys and read it back with less than X. You do that to get multiple records back from the lookup and you need to use a UV (or ODBC) stage pointing to the hashed file to do that. And you need a VOC record. And you need to build expl...

Been a long time since I've touched Sybase or that stage, so don't really know the answer or what's going on under the covers there. However, I will say that most (if not all) databases will store date/timestamp values in an 'internal' numeric format with all of the formatting - the 'external' versi...

OK, got it... and it was pretty much what I imagined you meant, just wanted to be sure. And all of my replies were geared with that in mind. Reading a hashed file as a source is different from reading one as a reference lookup. As noted, there's no joining or key matching going on in the former, thi...

Sorry, no... or at least not yet. I was just happy to get the 7 client working again. In actuallity none the 8.1 clients will even start for me and immediately fail with Java related issues. Not something I'm going to worry about today, maybe next week some time.

Hey, I'm curious. Are these Redbooks, if you order an actual honest-to-goodness printed version, in color like the pdfs are? No clue I could find, one way or the other, at the Vervante site. Sure, they show the cover in color but that doesn't mean the insides are, necessarily.

Anyone know?

[crosses fingers]