DSXchange

Silly little dreamer. Who says the best product has to win?

Without a doubt, properly modeled and properly adminstrated, Redbrick is phenomenal.

... but a cannon can be used to swat a bug, can't it? And with a big enough hammer you can drive screws instead of screwing them in. The problems for both methods are: 1. The results aren't pretty. 2. You'll probably damage the surroundings with that size of a whack or cannonball. Plus, if you're i...

Single node. Choose wisely.

If you are new to unix you have to seriously consider spending some time understanding operating system commands and shell scripting. ksh, csh, sh, perl, java, whatever is your flavor, scripting is integral to developing any application on unix. If you have a requirement to copy a file from one dire...

DataStage is an ETL tool, it's meant to manage loading data. Your situation requires DataStage to be used as a command executer. Wouldn't a shell script be much simpler? DataStage has support for stored procedures as a means to either: receive streaming data like a cursor and do something with it; o...

Yes

Or there could be a routine with conditional logic with a path that is mostly never traversed. Maybe nowyour source data is in a condition that is causing that branch to be used, and it references a variable previously not set.

Edited: corrected "past" to "path"

Can't. You could use a stored procedure.

How about a second job that runs all of the SQL commands you need, via command line executes. You can use a Sequencer job to do that, you can use a Batch job to do that.

Have you looked at using the after-job routine? How do you propose to decide what status to set? You can't "see" the Oracle stage, so there's no way to return any information from that stage.

What need are you trying to meet?

IBM only owns Redbrick because they acquired Informix, who only owned Redbrick, because they acquired it from Ralph Kimball.

Please use the correct forum next time.

UPDATE TAB SET CASE Type = 'NAT' then NAT=:2 Type = 'REG' then REG=:2 end WHERE Key=:1 You have to update all columns, they need to be bound because of the laws of SQL. You can't be switch columns in your set, you have to have each column defined. You can always update a column with its existing va...

Okay, one last time. How are you viewing your result in the Oracle table? Are you browsing with DS's view data button? You do realize that Oracle stores dates in an internal integer value and that it is up to the device querying the data to format it in a manner you like? Therefore, DS puts a TO_CHA...

For a beginner who doesn't know DS it sure is an esoteric example using the proverbial emp table. If the result set is to be: 1. All employees without a manager 2. All managers without an employee 3. An employee per manager, allowing for multiple managers per employee If using tables to do this work...

what about Parallel routines , which forces the DataStage folks to know C?? comments please Are you moving millions or billions of rows of data? Is your hardware thousands or hundreds of thousands of dollars? Is your software budget one hundred or five hundred thousand dollars? Is your team skillse...