DSXchange

An A-correlative is a BASIC specific creature, it's very hard to explain. Every hash file has a "dictionary", or a description of all of the data attributes (columns) within the file. Each attribute (column) can be described using different techniques. So, when you say "LIST.DICT hashfilename" you a...

Steve is the man, checkout his picture at http://www.kennethbland.com His Bag of Tricks is voluminous, his DSX cutter is top notch. He has a complete PVCS integration suite setup. He has point-and-click control, the weakest link in the chain being the command line import/export with DataStage becaus...

The DataStage Server Unix Survival Guide I wrote is about an 8 page document that points out all of the touch points the Server product has in the unix environment. I wasn't trying to show proprietary information such as how the product is written, just simple things like how to identify job process...

To quote Yoda: You must unlearn, what you have learned. Server to PX is not like a Corvette to a Ferrari. It's like an Humvee to a Ferrari. A Humvee is highly versatile, goes just about anywhere, doesn't break down. Just about anyone can drive one. A Ferrari is a high-performance vehicle. You don't ...

Yeah, unfortunately, I have a request to allow a Business Analyst to write simple expressions to confirm data as it processes. I thought I'd use a simple technique where they can write equations like: column_a = column_b + column_c + column_d I was going to pass a row to a function that has loaded a...

I'm working on a generic expression parser, and am having trouble with a rounding issue. I wrote a DS function to test something: Ans = OCONV("",Arg1) In my test case, I typed in this for Arg1: A;IF '140.95' = '139' + '10.95' + '7.5' - '16.5' THEN "1" ELSE "0" T...

Have at it Kim. My brain is pickled. I've had the flu for the last week so I can't think straight. I figured this is a hierarchical walk, like a WO-BOM, but the output specified is ambiguous. If the desired result is a flattened hierarchy, then yes, the approach is to find either the lowest level wi...

I like to think I'm a pretty bright guy. But for the life of me, I cannot figure out what it is you are asking. I could make some guesses probably close to the mark, but you you please restate your problem? Could you also provide better examples, as KEY_ID and ID_LIEE does not tell us what those col...

You should have been putting a seed value into this hash file prior to running any jobs that use it. I personally do not use this SDK routine for a lot of reasons I've covered before on this forum. However, you should at least design a job like OCI/ODBC --> xfm --> hash that selects max on the surro...

Just ignore the collector stage and link directly from your Transformers to the Sequenctial File. Just make sure that the settings inside the sequential file stage are the same for all three input links. And of course, change the 'Overwrite' setting to 'Append' DO NOT TAKE THIS ADVICE. This does no...

Can't we load table defination on the fly in oracle Stage. No, the product is about fixed metadata. Good or bad, that's the way it works. Also, I was looking for "work around in datastage". Well, I just described how you could write your own "plugin" type stage. Instead of an OCI stage, you have a ...

Can anybody suggest me solution for this or any work around to get same result. Visit http://www.asktom.oracle.com and search for his pro*c program that is a bulk unloader. He has posted generic program code for mass-spooling output from a SQL query to a file. It does not use the dreadful UTL_FILE ...

We are using bulk loader files created with a sequential file in our environment, but found that our network connection greatly slowed the bulk loader. To get around this we copy the file to the oracle server and created a stored procedure that invokes the sqlldr on the oracle box. Using this we ca...

You can tell that I must be sick because I didn't lecture. Thanks Craig!

Are you talking about a hardcode directory path in the job designs, in places such as the sequential file name? The answer was use a job parameter that is switchable according to the environment you're in, and pass the value in using job control. The next answer is embed the default value along with...