DSXchange

Were you able to resolve this error?

If so, please share the solution. We too are facing the same problem...

Thanks for the information Ken. I have setup the "tnsnames.ora" file under the Oracle 9i Client folder. Then, using the DS Manager, I selected the option to import through Plug-in Meta Data Defintions. When I select the Oracle 9i plugin there, I get an error message saying "Unable to ...

Ken,

Ok, I'm currently using DS version 7.1.

As per the steps that you have mentioned, I would need to the update the tnsnames.ora file of the 9i Client. Then I would make use of that in the Oracle OCI 9i stage properties (to connect to the required 10g database). Am I right?

Oh, yes! You are correct. I meant the DSN. So, you mean that, if I create the DSN through "Administrative Tools" option in "Control Panel", I would not need to do (or specify) anything about the version - 9i or 10g. After creating this DSN, I could go ahead and use this DSN in my...

By "ODBC connection", I mean the connection name that we give under the "Database source name" in the OCI stage properties. My question was to create this "connection", is it fine if this connection was created using the 10g Client (or) is this connection itself should ...

I already have an ODBC connection to connect from the 10g Client to the 10g database server. Is it not possible to use this ODBC connection in the Oracle OCI 9i stage?

Hi, We are working in version 7.1. In our DS Job, we would be reading data from a hugh file either using a FTP stage or using a Sequential File stage. The file could contain about 40 million records. So, I would like to know is it possible to read part of the file either through different Jobs or th...

Yes, you are correct. It was not NULL but the column had contained binary zeros in them. I used CHAR(000) to identify them and the trim those columns.

Thanks for your inputs.

Thanks for your reply Kenneth. Yes, I did try to handle both these conditions. The NULL value doesn't get recognized by both of these conditions.

Is there any more way of handling the NULL values?

Hi, We are currently loading data from an external source to a Sequential File. I have certain records containing NULL value for a particular column. I need to filter out those records. Those NULL values show in the output flat file as "|||||". I'm not able to filter out those records usin...

DSguru2B, As you said I split this process into 2 Jobs - First one to only FTP the file and the Second one to covert the data from EBCDIC to ASCII. I could find that the bottleneck is in FTP ing using the FTP stage. The first Job using the FTP stage to just transfer the data runs for the same 1 hour...

Oh! So mean that using the Oracle 9i Client, I can connect to the 10g Server.

Currently I have only Oracle 10g Client in my DS Server. So I have to uninstall 10g Client and install Oracle 9i Client?

Craig,

What do you mean by "with a 9i client"? Do you mean to say 9i client should be in the DS Server?

Thanks.

Hi,

We are working in DS version 7.1 and the database used is Oracle 10g.

But I only have these 4 Oracle stages in my palette -
Oracle 7 Load
Oracle OCI 8i
Oracle OCI 9i
Oracle OCI Load

Can we use 'Oracle 9i' stage to read and write data to an Oracle 10g database?

Thanks.

Hi, We are using DS Server Edition, 7.1 version. Here is the process that we are doing in the Job. We have just 3 stages in the Job - a FTP, a Transformer and a Sequential File stage. Using the FTP stage we are reading from a file from a remote Mainframe server. In the Transformer we use DS transfor...