DSXchange

Thanks Ray,

The configuratuion file used is the default one which is working fine for the job having file to file load. But the same is not working for connecting the Informix DB.

Apart from config file is there anything that we have look at for the Informix connection...

Thanks,

Senthil Kumar P

HI, I tried to connect the informix database through parallel jobs, When i view/run the job it gives the below error ##I TUTL 000031 16:33:37(001) <main_program> The open files limit is 4096; raising to 8192. ##I TOSH 000002 16:33:37(002) <main_program> orchgeneral: loaded ##I TOSH 000002 16:33:37(0...

Thanks chulett, I could see the Timeout options in Administrator but I couldnt make any change over there...its not allowing.

Why so, Is that means a protected environment?

thanks,

Senthil Kumar P

chulett wrote:It would help to state when/where you get this message. ...

Hi Chulett,

Thanks, I am getting this error in designer....it happens when i am executing some jobs....

Thanks

Thanks Ray,

Can I increase the Inactivity timings? I checked in administrator a variable named DSIPC_OPEN_TIMEOUT is set to 30.

DSIPC_OPEN_TIMEOUT - increasing this will increase the inactivity timings?

Please let me know

Thanks,
Senthil Kumar P

Hi All, I am getting this below error message, Error calling subroutine DSR_PROJECT(Action=7) check ds is setup correctly in the project projname.The connection is broken (810002) Please let me know why the reason for this error and what is the solution to come out of this error. Thanks, Senthil Kum...

Thanks ArndW,

I got that write mode is faster but i couldnt get your second answer, since i am not a premium user.

Could you give me a hint on that one...

Thanks,
SenthilP

Hi All,

TO insert records into the table which method in DB2 is fast Either write mode or Upsert mode?

I have seen in a proj, used upsert mode but both the insert and update sql has the same insert query. so whats the diff b/w this upsert and write in this scenario?

Thanks

Senthil P

Outside the XML.

So in this case it will be '11111'. Instead of that it comes as NULL. It is a varchar field.

Thanks,

Senthil

It worked. But I am getting my first column as NULL. It is a NULLABLE column according to its definition but the input does hold a value for this column. I am using the same input, the one I posted.

Do I have make some adjustments in the settings to overcome this?

Thanks,

Rakesh Narayan.

Thank You.. will try that and get back to you..!!!

Regards,

Senthil

Hi All,

In Qualitystage 7.5.1 whether we can handle special language characters such as (dual byte character set e.g Slavic language, Chinese characters).

Please help me on this..

Thanks,

Senthil Kumar Packirisamy

Hi Ray,

What do you mean by score ray? I dont know where to get this info..could you please give some info on this.


Thanks,

Senthil P

Hi All, I have a job where am using join stages , the input to join stage is empty file..the output of this first join is used as input to the second join. when i run the job i am getting the error like this Syntax error: Error in "join" operator: Error in output redirection: Error in outp...

Hi,

@INROWNUM>2 from the sequential file will solve this problem.

I am not sure about this........

Thanks,

SenthilP