DSXchange

I am extracing data from an oracle database and i am getting out of process memory error from oracle.This is a production backup database where i will not find a way to change any settings. Are there some thing that we could do from the Oracle stage in the server ORA-04030: out of process memory whe...

Hi ,
I am using thiis DRDBMS stage to connect to a new and different SQL Server database that is not listed in the .odbc.ini and uvodbc.config files at present .

Should i change these files to access the database

Hi ,
The drop down is a pick list and its not allowing me to enter the DSN in the import wizard.

Hi ,

You could use the write Range map stage and write a dataset that partitions your data based on a range. You could then use this Range partitioned dataset with the lookup stage to perform a range look up

Hi , I have added the entries for the New DSN that i am going to use in the path $DSHOME/.odbc.ini and i have added an entry in the file $DSHOME/uvodbc.config. After adding all these the DSN name is not appearing in the DSN list while i try to import the table definition in the manager. Should i car...

Hi , The datastage passes them to the Pl/sql engine for parsing , i am getting the PLS-00103 error which is thrown by the PL/SQL Engine I have to run a analyze statement for a partition suffixed by timestamp .. any w3ay could i do this in the after SQL . The partition name is something like partitio...

Hi , I am using an anonymouse PL/SQL code block . The block is executing in SQL * plus client but when i use the same in After SQL of the oracle stage of datastage its throwing Oracle compilation errors any clues. Is it not possible to execute the Anonymous pl/sql code in the after SQL ... Please help

Hi I would like to connect to a oracle DB and i donot have the oracle client in the machine where my datastage server is installed .This prompts me to use an Dynamic RDMS stage(An API stage) but the same can be achieved in the ODBC Enterprise stage. Can i have clue of which stage is to be used ...? ...

I hope that the answer would be Depending of the order of the keys defined in the stage. The key defined at the top of the declaration would be used first for a match and the second key is used for comparison. If the second key is less or greater depending upon that the comparison result is recorded...

Hi, I am trying to understand the compare stage in datastage . The manual states that by comparing the key columns(Columns on which the change has to be detected) from the input datasets the result codes are output. Say i have a key column "col_a" in both the input datasets. Hence if First...

I have got an update for this issue... The prior column is a varchar2(4000) column .This column contains a "\n" characters in it . When i tried viewing data ,it shows data partially .. The data after the varchar2(4000) column is not shown... Any clue of how to remove the "\n" cha...

Hi, I have used the ISNULL function in the ODBC stage to convert null values in the sql server to spaces. This function is actually working for the columns that are actually having null values .. When i view through the query analyser not able to ascertain the coluimn value.. i gave ascii(col_name) ...

Hi , I am using a change capture stage and the before and after datasets have nullable varchar2 columns..My change capture stage is not working fine .. I am not sure whether the Change capture stage would compare the Null in varchar2 columns ... How do i check whether the change capture stage is tre...

Hi Thanks i got the server name .... There are multiple servernames that are in the name of my application and Hope there are DSN created for a particular Db in the SQL server..... Any ways of getting where the DSN sits in the unix box ? ...so tat i would figure out the exact server to which i have ...

Hi , I am having credentials (DB name ,Id and Pass )for logging into the SQL server DB through the ODBC stage in my job ... I would like to manipulate the data via the SQL Server Query analyser for implementing the change capture process. Can anybody give me a clue of how to detect the server name f...