DSXchange

I have been working with Ron on this (peddidsx) and want to share some of what we figured out. It was a mess figuring out how to make a java JMS client communicate with the RIB... what we found out was that oracle's AQ topics require a special connection factory--you cannot use the default JMS conne...

I am having a similar problem. Getting the error 'Input column does not promote to output column' and my input and output columns are the exact same. My inputs were saved, then loaded into my outputs, so there is no change in position, SQL type, etc. Edit: I took the column in the sort input/output ...

I need another workaround, similar issue. I am running a stored procedure on an oracle database which writes a CLOB file to a table, then returns a pointer to where the CLOB was written. After executing the procedure in the stored_procedure stage, and sending the output to a HASH, I need to pull dat...

As I understand the replies: If same database, you must join inside the original SQL (an option, so long as you are NOT altering the data of one query via Datastage stages prior to using it as criteria for a later SQL) If different databases of the same type, oracle dblinks can be used. If two seper...

More details: Table A's output is already being transformed, altering the data before it is joined with Table B. I am currently querying table b into a hash table, then joining it to Table A in a Transform stage. The problem is that the query on table B is a full table scan... because I have no crit...

I need to use the results from one Oracle stage to be used to filter the select statement on a following oracle stage. How can I use input on an oracle stage to filter the select statement?