DSXchange

Hi All, I'm not sure if this is the right forum but I've seen other posts that relate to this issue. If it's not please let me know and I'll move it. So here's the problem I'm facing. I've figured out, with help from this site (Big Thanks), that the ISDAdmin command line tool is how to change the ru...

Hi All, I'm running into an issue running the following query in an Oracle connector stage. insert /*+ APPEND */ into #psOracle.jpOracleSchema#.house_off ( H_ID , O_ID , REGION_ID , LAST_UPDATE_TS) select /*+ PARALLEL(ta1, 16) */ h_id , o_id , region_id , current_timestamp from #psOraStgTableCredent...

Thanks everyone for the reply's. I was working on a few of the suggestions made here, specifically taking the output and copying them to a sequential stage to see if any extra charaters were encountered. We did note that the Netezza field had a 2 byte length component but in the end it was not causi...

Hi All, I dealing with an issue that's not making sense to me and I was hoping someone could shed some light. In a previous job I extract lookup data (172k rec) which contains 2 fields (1 decimal and 1 Varchar(30)) from an Oracle DB and place it into a dataset which has been partitioned with Entire....

That error about partitioned table may be unrelated to version but related to privileges on eight specific system tables. You can Search DSXchange for d ... I'm working on pretty much the same issue. The difference is that I'm working in DSv8.0.1 and have client 10g installed on the DS server conne...

In Enterprise stage, it is called open command , close command, while in other teradata stage, it is before and after sql. I tried that, and it looks like that DS couldn't recognize these commands. thanks I know this is an old thread but I had to do this (company direction is not to mix DataStage a...

Hi Brad, Just to tie in with this... check my latest findings out as well. I think we can safely say it's something transformer-related somewhere along the line. http://www.dsxchange.com/viewtopic.php?t=129054 Hi Miwinter, Yes, after placing a PMR with IBM they came back and noted the order issue i...

Update: OPEN COMMAND solution didn't work I tried explicitly writing out the DROP and CREATE TABLE commands, which you would need to ensure your Write Mode is set to either Append or Truncate. The trouble comes when DataStage performs a pre-check on the existance of the target table, which is a cond...

That's exactly what's happening. And looking at the output more closely this is what I'm seeing... (First a little background) I've got 2 sources 1 UDB and 1 Teradata which I'm joining together with a Join Stage. I'm using a Transformer inbetween the UDB and the Join to conform the columns. In the T...

Hi, Firstly, I am realtively new to DataStage and have found a wealth of information on this site, so Thanks to everyone that I've gleened information from. Now for my question: I'm using the Teradata Enterprise stage as a target stage to write my output to a table, but the column order is not perse...