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?
Search found 21 matches
- Fri Feb 24, 2006 12:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Avaya and OpenLink
- Replies: 5
- Views: 2941
- Fri Feb 24, 2006 8:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Avaya and OpenLink
- Replies: 5
- Views: 2941
Re: Avaya and OpenLink
[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...
- Mon Jun 20, 2005 6:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC Connection from DataStage to Informix
- Replies: 7
- Views: 6885
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...
- Thu Jun 16, 2005 7:14 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC Connection from DataStage to Informix
- Replies: 7
- Views: 6885
- Fri Jun 10, 2005 6:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC Connection from DataStage to Informix
- Replies: 7
- Views: 6885
ODBC Connection from DataStage to Informix
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...
- Fri Feb 04, 2005 9:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal End error while running a DS load job into Oracle
- Replies: 32
- Views: 16224
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,...
- Thu Feb 03, 2005 9:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal End error while running a DS load job into Oracle
- Replies: 32
- Views: 16224
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...
- Wed Feb 02, 2005 4:03 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal End error while running a DS load job into Oracle
- Replies: 32
- Views: 16224
- Wed Feb 02, 2005 2:40 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal End error while running a DS load job into Oracle
- Replies: 32
- Views: 16224
- Wed Feb 02, 2005 1:29 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal End error while running a DS load job into Oracle
- Replies: 32
- Views: 16224
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...
- Wed Feb 02, 2005 9:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal End error while running a DS load job into Oracle
- Replies: 32
- Views: 16224
- Tue Feb 01, 2005 12:37 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal End error while running a DS load job into Oracle
- Replies: 32
- Views: 16224
- Tue Feb 01, 2005 12:20 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal End error while running a DS load job into Oracle
- Replies: 32
- Views: 16224
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...
- Tue Feb 01, 2005 11:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal End error while running a DS load job into Oracle
- Replies: 32
- Views: 16224
- Tue Feb 01, 2005 10:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal End error while running a DS load job into Oracle
- Replies: 32
- Views: 16224
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...