DSXchange

In my job i am getting this error:-

[Informix][Informix ODBC Driver]
[Informix]Could not open or create a temporary file.
SQLExecute: Failed to execute statement.

What should be done to remove this error?
Can u suggest?

Somewhere in a particular job, in an ABC informix database some SQL Query is written and then link to hashed file and then link to transformer and then processing further.... When i execute the job i m getting the follwing error:- The job failed in the ABC stage as it was unable to create a temporar...

If we want to do some calculation in TimeDate() Function. Why we assign the value of function in a particular variable first like: X=TimeDate() and then do some calculation Why can not we use the function directly for calculation If there any impact on the job. What are advantages or reasons of assi...

In the job, data is first read from an informix database, then partitoned by Link Partitioner and palced in six containers and collected by Link Collector and then connected to transformer for further processing and then finally updated in the informix database. In the job i am getting an error:- ds...

Yes, i m using IPC stages. These are shared containers

In a particular job, there are six containers, only container number four is giving an error message of ds_ipc open. In all the containers two transformers, two informix database and two hash files are using. I matched the container4 with all the other five containers. All the things are same, there...

Getting Error Messages from XYZ(Job):

XYZ..Container4.ABC.LC1_4: ds_ipcopen() -

(XYZ..Container4.ABC-Link_Collector_1) -
No such file or directory

XYZ..Link_Collector_1: |Error 11 in GCI Link initialisation.|

In a job there are six containers for a particular link partition and link collection The following error message comes after executing XYZ job: XYZ..Container4.ABC.LC1_4: ds_ipcopen() - Error in open(XYZ..Container4.ABC-Link_Collector_1) - No such file or directory XYZ..Link_Collector_1: |Error 11 ...

Hi kumar Is there any other option to check null values. I have an idea of checking null values. I made a routine. In routine i first check the null values and then i check the flag values. If IsNull(Arg1) OR IsNull(Arg2) OR IsNull(Arg3) OR IsNull(Arg4) then Ans = 'N' end else If Arg1 = 'Y' AND Arg2...

Hi Kumar,

I have checked the test conditions in the transformers. The logic of the test conditions are right.
I verified the test conditions also.

In a particular table, five fields has flag values. The fifth field which is a flag value depends on the result of four fields in a table which are also flag values. In the first job, the five fields are first assigned to null(@NULL). In the second job some test conditions are put in the transformer...

Hi Everyone ds_ipcgetnext() - Error in mutex_lock() - Invalid argument Tell me plz,if you are 100% sure, when this problem comes, If we exceed the timeout under performance in job properties or if we choose to stop a job in which any form of inter-process communication is occurring. Is there any rea...

What is the impact of increasing and decreasing the Buffer Size and Timeout under Performance in job activities?

When we increase or decrease the buffer size and timeout and why?

The job is giving the following error:- ds_ipcgetnext() - Error in mutex_lock() - Invalid argument And the job gets aborted What i have to do to remove this problem? My job is using the link collector and link partitioner as well as six containers and transformers as well as informix stages. What is...

Can u try one more time plz to give the reason of the following warning:
Error in mutex_lock() - Invalid argument
Why this warning is coming?