DSXchange

Hi, I see that this topic was closed without any resolution. I would like to share that we had similar issue and found that the datastage user id need to have "passall" authorization for MQ. We were able to write into MQ after this permission was added.

If you click Help on DataStage Designer and click "About DataStage Designer", it will popup about Version, Build Number and Other info. At the bottom of the popup there is a clickable , "Show Patch Install History". You may click that get the history [I am talking about DataStag...

Hi, We have requirement to setup a new DataStage server similar to the one that we already have. Is there a way to findout the list of components / plug-ins / patches installed in the current server? This installation was done long back and there is no documents on plug-ins that are installed and wh...

Build template SQL files with a token in place of the filter. sed the token to the desired parameter filters you want at runtime and redirect to a temp SQL file and run the Temp SQL in DataStage. Hopelessly complicated? You betcha! But it makes the SQL file(s) dynamic as opposed to static. Basicall...

Thanks Craig. I uderstand the workaround. However, we have multiple filters and it will be difficult to maintain hunderds of QUERY file for a single Job.

Thanks. i'll request the DBA to install 8.1 client. Didn't say you needed to change the Oracle client, simply have your DBA add another one, an 8.1 client in this case. Then point DataStage to that client by setting $ORACLE_HOME to it in the dsenv file. No other applications would be affected.

Thanks. I think keeping client & oracle versions in sync is the solution for this. But changing the version not possible here as the oracle client is used by few other applications as well. As a temporary fix I used TO_CHAR() function to convert all Decimal values to VARCHAR in OCI stage and the...

My database version is 8.1.7.4.0. It is same in both prod and dev.

chulett wrote:This isn't a DataStage issue but rather an Oracle one. What version is your Oracle database - 10.1 or 10.2? Sure seems like you should get the 10.2 client onto production since that's the one w ...

Yes. I just noticed that the Oracle client versions are different between prod and dev datastage server. (Prod-10.1.0.5.0 and dev-10.2.0.1.0). But I believe DS should work fine in both versions. Is there a known issue with either of these oracle versions? Shouldn't be necessary. If I had to guess, I...

Hi, I am reading data from an Oracle table using OCI stage but the decimal data seems to be appending additional digits at the end. For example 1234 is appended as 12344. I have this issue only in Prod environment but not in the development environment. Please advise. Any inputs on this will he high...

Ok, I got the solution When I opened the Oracle Stage, It is getting opened in minimized mode. So, due to this the screen appears and not able to touch any other stages. Dont know how the Oracle stage is opening in minimize mode by default Hi, We have similar issue with Oracle stage. How did you ma...