DSXchange

DataDirect drivers are the default odbc drivers DataStage expects to use. You need to add an entry in your .odbc.ini file for the database. I have pasted a blank entry below. The port number in it is the one we found to be open. If that doesn't work you will need to work with an admin to do some sno...

We ended up using Data Direct by finding a port Avaya left open that allowed us to connect not using OpenLink. This wasn't really an Informix issue as much as a restriction created by Avaya. I have the same issue. Currently I am connecting using MS Access as I installed Openlink ODBC on windows. It ...

Has anyone had any luck connecting DS to to an Avaya Informix instance using the OpenLink driver?!?

I think that's a great idea! I was a bit uncomfortable with the timestamp as part of the key. Can you elaborate on how to define the stored procedure or point me to a resource that might have a good explanation for DB2? PS. i would still love to know how to access the handle information for future u...

Thanks for the quick reponse! We have jobs that will be writing records to tables that may only be unique based on the the rowid and the row_id must be known to the job due to business requirements. Additionally, many job instances could be running at the same time. We need a solution that can be ea...

Hi, I am trying to retrieve the PID for a job in a C++ funtion used in a routine. Unfortunately the built-in functions of the API require that you know the job handle. Since there is no DSJ_ME that I can find. How do we retrieve this information? I would settle for passing the value into the routine...

Ok. So gave up on the enterprise db2 stage and I was able to write to a CLOB in DB2 using the API stage when I assigned an arbitrary large length for the LongVarChar. Of course the downside here is that the API in parallel does not allow you to reject rows since it does not have a reject link and th...

Hi Bala, Unfortunately I am trying to create the BLOB/CLOB (I would use either..in fact I lean towards CLOB) but I can't get either to work. I have tried manipulating datatypes but nothing seems to work. I have used CLOB in 7.1 with oracle in the past with no trouble. I don't know if things became s...

Hi Bala,

Thanks for the suggestion. Unfortunately it gives the same error.

Hi, I recieved the following error when trying to write to DB2: "Unable to bind a pointer to database field `Err_Rec_Txt'; it may be bound to an unsupported type." After a little research it appears that BLOB is not a supported DataStage type. So how do we store a non-numeric value greater...

Hi kcbland, Don't worry about RI. I am confident we can handle issues around key violations prior to loading. And my concern is not for preparring the data and generating the load files. My concern is that we need to insert/update 3-5 tables with related data and we cannot allow partial data across ...

Hi folks, I did a pass through the forum and couldn't find much on this. I want to insert/update multiple DB2 tables with related data. I would very much like to avoid having incomplete data. What are the DS best practices for keeping this data in sync if one of the loads fail? So far beyond a compl...

Hi Shivan, Just want to rule out the obvious...Have you tried increasing your buffer size and timeout? If this didn't work and the sort mentioned didn't you might want to talk to Ascential about disabling the Notify function. It impacts IPC between child and parent and has known issues that can mani...