DSXchange

We have Information Server V 8.1 and using Oracle client 10.2.0
As of now connecting from Datastage V 8.1 to Oracle 10g R2 Database as well as Oarcle 11g R2.

do we need to upgrade the Oracle client to 11.2.0? or is it good to keep using Oracle client 10.2.0?

Any suggestions is greatly appreciated?

Thank you.

We had an Unix Sun Solaris installation of Information server 8.1 with DB2 repository on Unix. Is it possible to create a Datastage project on client machine independently with out loading the repository to Unix Server and use Oracle driver installed on the client machine to connect to ORACLE databa...

My ORACLE enterprise read stage is failing with ORA-12170: TNS:Connect timeout occurred.How we can define timeout parameter more than 60 secs, looks like default timeout is 60 sec from other posts.Is it possible to define thru Additional connection options?

Any help is greatly appreciated.

I want to load/append the data to an empty table using ORACLE Enterprise stage in parallel.I have a referential integrity with other table for my target table and i want to reject/drop the rows which violates the referential Integrity. what is the best design approach for this scenario of loading ar...

I tried with lookup and added a condition for key columns with "drop".It worked. thank you for all the support.

I do not want to delete the existing records, just append the new record and if the key exists just drop the record.Since we are using Index Rebuild option, it is is inserting all rows and failing to build the indexes. Can we use any other design approach to skip the records upfront, before coming t...

I need to append data to existing Oracle Table with primark Key(Column1+Column2) using Oracle Enterprise Stage and the source is flat file,but i need to drop the records when i am appending the records when the primary key is already existing in the table. What is the best way to design this scenari...

I am running a BTEQ script from test.sh and test.sh is executed by routine from Sequencer.When my BTEQ script failed i didn't see any error message in Datastage director for my Sequencer. If Datstage routine excecuting the BTEQ script failed, I want to send a notification for the failure.Since I am ...

It is inserting the data to the table.

I have a job which is loading data to 3 tables using Teradata mulitload stage and it is failed in Application phase.How to restart this job from Datastage?

Can we pass the grep command twice on Filter property in sequential file file stage? If so can you tell me how to pass it like what is the syntax should looks like?

Actually there are other records in the file which are not matching the grep command, In that case i can't check by file size right?

any suggestion Ray?

Hi,

I am reading a a file using sequential stage with a grep command in Filter property.If there is no data in the file for my grep command , it is throwing an error :Filter Status 256.

But when there is no records I do not want my job fails throwing an error.

any help greatly appreciated.

I installed IBM Information server client on a desktop and it replaces current ODBC drivers with IBM data direct drivers.

Any idea how to save the ODBC drivers on the desktop after the install?