DSXchange

Hey Folks! I'm having lots of fun coding my first CFF stage. I've created my first copy book in over 15 years, but this time I'm enjoying it more! A question for the rich and famous out there, is there a way to code a 'default' or 'else' stream from the CFF stage? I have a number of record types emb...

Editor wrote:John Belushi and Dan would be quite the DataStage team.

Wouldn't be the first cross-over between musicians and coders. Seem to remember one of the original programmers of Clipper was the keyboard player from Steely Dan.

The guys from Boston were all MIT grads as far as I can remember.

ray.wurlod wrote:No, ma'am. We're musicians.

Hmmm.... Blues Brothers....

Try this one.

NO! I'm his gardener!

Ascential's lawyers claimed to have copyright over any screen shot of any of their products. ?!?!?!? So what about all the authors of the bijillion books on Oracle, SQL Server, (add your favourite product here)... Do they all have to jump through the same hoops in order to get books published? Furt...

...so when is the 'inner circle' going to write a book, entitled something like "DataStage - what you REALLY need to know to become a DataStage developer"... Seriously, about 10 years ago I was doing programming using a product called SQL Windows. The documentation that came with the produ...

I have to take an input file INPUT_<MMDDYY99>.EXT and process it and save the output in OUTPUT_<MMDDYY99>.EXT How I can implement this .... Any help? I just had to do the same thing for an output file. See the link below to a thread for some good ideas on what to do on the UNIX side. I used the fol...

We do generally remove the schema names, however, cnadw is correct. Further testing has revealed that, even though I still receive these errors, I can get the statement to run. Initial observations indicate that the data is correct. This is quite bizarre. Kenneth, I appreciate your efforts on my beh...

Here's the statement that just now gave the error: SELECT GAS_COMMODITY_BILLING_FACT.PREMISE_KEY AS PREMISE_KEY , GAS_COMMODITY_CONTRACT.CUSTOMER_FLOW_DATE AS CUSTOMER_FLOW_DATE ,GAS_COMMODITY_BILLING_FACT.CYCLE_DATE AS FIRST_CYCLE_DATE ,GAS_COMMODITY_BILLING_FACT.CONSUMPTION_AMOUNT AS ROLLING_CONS...

Hi Kenneth, I've been paring down the SQL to eliminate anything 'fancy' in hopes of finding a SQL statement that DS is happy with, intending to build it up again piece by piece to find where it gets unhappy. This is about as far down as I can pare the SQL and still have it resemble what I'm trying t...

Folks, DataStage is giving me 'ORA-00904 Invalid Column Name' on the statement below. This statement gives no problems in TOAD. I've defined 4 entries on the Columns tab to receive the 4 columns, with the first two as key values. I'm using the ORAOCI8 stage. I've tried re-importing the table definit...

Hi, I am using the XmlReader stage to load data into an oracle 9.0.2 database. This works just fine when the files are less than 110 Mb in size. When the files get larger DataStage aborts with no proper error message. Anyone with the same experience and hopefully a solution to this problem? regards...