DSXchange

Hi,

Thanks for the reply, Could you please let me know how did you find the open port on Avaya. And also how did you use Data Direct?

[quote="tacitus"]Has anyone had any luck connecting DS to to an Avaya Informix instance using the OpenLink driver?!?[/quote] I have the same issue. Currently I am connecting using MS Access as I installed Openlink ODBC on windows. It seems DataStage DLL has some kind of incompatibility wit...

Thanks Ray. If I need to make an entry in to the sqlhosts file on the Sun Solaris Box which has the Informix DB server, I need to know the DB name, Host name and the service I am going to use. And also the document says that the service has to be listed in /etc/services file with correct port. Now m...

[quote="mkeevil"]We currently connect to Avaya but we used drivers supplied by Avaya, not the protocol giving by Ascential. We connect to the CMS using the Avaya drivers The driver is called OpenLink Generic 32 Bit Driver v4.0.[/quote] Hi mkeevil, Do you connect to avaya from Datastage? If...

Hi All, We are trying to connect to the Informix using the ODBC. The informix database is being used by Avaya Call Management System which resides on Sun OS Box. Our Datastage 6x resides on HP Unix. We are trying to use the wire protocol given by Ascential to connect using the odbc(by making entries...

Hi, Thanks for your patience and replies. I looked at my data fields closely and found that I have almost 5 variables with a varchar(255) size. Out of this 5, only 3 were getting populated and remianing 2 were set to @null in the DS. What I did, its a waste process by the DS when I have null values,...

Hi, I have 3 warning message fields, I am not using them in the transformer while loading in to the OCI9. When I remove the 3 colums all the way, I am fine in loading. Thats surprise, I have a similar job which has 3 unused fields coming the sequential file and still loading. Is there anything wrong...

Did anyone got DSD.SEQClose error.

I am getting this error consistently.

Any help is appreciated.

RC

I have verified that too.

Everything is pretty much OK.

I also removed the function based unique index on the table and created a composite primary key and started loading and got the same error.

I deleted all the files and started re loading lets see.

RC

I did the check on link it is fine. When I do a full insert in to the oracle table I am fine, all 1M rows goes in. Only issue is when I chose Insert or Update clause into Oracle. Only thing I see with Oracle table is I have a function based unique constraint on the table, i.e. during each insert, it...

Any suggestions to my issue..

RC

Hi,

I don't see any threads.

RC

Hi, I tried by deselecting row buffer and still got the below error. Project:smqa (whseqa) Job name:LdTouchpointFactDICatalogs Event #:217 Timestamp:2/1/2005 1:18:36 PM Event type:Info User:qdssmqa Message: From previous run DataStage Job 237 Phantom 24621 Abnormal termination of DataStage. Fault ty...

Hi,

I did one thig, While trying to load in to Oracle using OCI9 and I started copying the data in to a sequential file at the same time to see if there is an issue with data, When I do that I have no issue.

Does that trigger anything???

How do I turn off row buffer?

RC

Hi I ran with commit after every 30000 rows and the total rows almost 1M. And i got the below error From previous run DataStage Job 237 Phantom 29511 Abnormal termination of DataStage. Fault type is 10. Layer type is BASIC run machine. Fault occurred in BASIC program *DataStage*DSR_LOADSTRING at add...