DSXchange

No, he's saying to stop hijacking this thread and create one of your own instead.

Well, there you go, leap years and all handled. Time to mark the post as Resolved using the button at the top of the screen.

Not sure what you're asking re: the columns. Once you've got the Universe stage talking to the hashed file you built then it isn't treated any differently than any other sql against a 'normal' table would be. Mention the columns you need to mention. Mark the columns used in the where clause as key c...

I'm not sure I see the purpose either, just working within the requirements as posted. [shrug]

You are completely missing my point, never mind the fact that your solution requires a year which is (apparently) not available.

Doesn't that depend on your "Reject Mode" setting? From the docs: Reject Mode Allows you to specify behavior if a read record does not match the expected schema. Choose from Continue to continue operation and discard any rejected rows, Fail to cease reading if any rows are rejected, or Sav...

Can't say for sure, but believe I've read here that the 'online help' is pretty well porked in the early 8.x releases. Can someone confirm, please?

As noted, you can code something using the various DSGet* routines or use their scripting equivalents from the command line with 'dsjob'.

One at a time sure, but from a list of 12 distinct possibles since all that is being passed is the month.

For twelve values? You did notice there's no "inputYYYY", yes? Hence my question about February.

If that's literally all that I had to do, I'd build a hashed file with those 12 rows and do a lookup against it when needed. That or build a brain-dead routine with a case statement. What do you need to get back for "2"?

Export it again as a dsx this time. As XML you add an "extra" step to the import where it first has to convert the xml to dsx format and that is failing as your file is way too dang big. Storage != disk space, btw.

It already exists. I'm guessing the question really should have been "how do I use this Server function in a Parallel job". Yes?

shamail wrote:And I need this since I am trying to find out a way of accessing the details outside datastage clients.

What "details" would that be?