DSXchange

The problem is we already use odbc stage and we cannot change all of our code to use oracle stage now.

We have already upgraded the drivers and there seems to be no solution to the issue so far.

Hi We are trying to configure SSL communications between datastage and oracle servers. The DBA has completed the server side changes and sent the certificates and TrustStore password to be used. I have tried many options but keep getting the same error everytime. TNSPING to the SID works. sqlplus co...

I just changed the final delimiter from "end" to "None" and it worked.

Hi We have recently installed(8.7) and migrated code from AIX to Linux server. I am running into a strange error "cannot open file ds_stagetypes" when I open the designer. This happens for all linux user ids including dsadm except the one that was used for installation and migration. Can y...

For flat files: First you need to know the rowcount for your file: In the job properties use before job subroutine command execsh and type "cat filename | wc -l > rowcount.txt" Have a lookup in your job that looksup the file rowcount.txt and gets the rownum value. Generate rownum using @IN...

Hi I am working on loading an SQL SERVER table that has foreign key constraints on it. The job is failing because some of the data does not meet the constraints. How can we continue to load even if there a few failures during the load? I have not encountered any solution to this problem using datast...

Hi I have question regarding SCD2. There are couple of delta records coming in from CDC. I have to expire (user defined update on the rec_exp_date column) the corresponding records first and insert new records (user defined insert) . My current job design is like this. CDC--->Transformer------>Oracl...

Hi I am working with the CDC stage. I would like to know if there is a way to know which particular column has actually changed between 2 incoming rows. If so how would we do it in a simple and easy way. I have been doing it with a decode statement in sql by joining the 2 rows. Please inform. Thanks...

Hi I have a SQL server source with an NLS of SQL_LATIN1_GENERAL_CP1_CI_AS and an Oracle Target with NLS settingof AMERICAN. When I load data from source to target, some of the data is being changed Ex: ? changed to | Is this an NLS problem? What is the correct NLS setting that can be used in this ca...

Can you be more specific. I have tried using loop concept in the sequences but the values used are only for determining the no of times a job runs rather than passing a distinct parameter value for each run.

Thanks

Hi I have requirement to run a job 40 times with a parameter value sent to the source query of my job. The parameter is different for each run and should be generated anew for every run. Ex: Select empno from emp where deptno=#A# where A=1 for first run 2 for second and so on. The entire job must be...

Hi Everyonne
Is there a place where we have all the Error codes for datastage, their explanations and possible resolutions to those errors just like Oracle Ora-codes. I think this will greatly reduce the repetition of posts on the forum and direct users to the required site.

Thanks
Bob

Thank you for the reply, My odbc.ini has entries for other databases but I have posted only the one for sql server. What are the steps to configure the connection?

Thanks

Hi We have a AIX box with datastage installed on it. We have sqlserver on a windows system and would like to connect to this database to get data. How will we define the odbc connection to get connected to sql server. What files need to be edited to get this effect. My .odbc.ini looks like this [SQL...

That was something I never knew.Thank you for the information.