DSXchange

yes,There are locks on one of the table.To avoid the locks is there any configuration changes in odbc connector need to change to avoid these locks.

there is no specific error message but job hangs and running contuously.

do we need to change any setting in odbc connector stage.

currently we have record count as 2000,array size as 2000.isolation level as read commited at source stage.

Looking farward for the suggestions on this

sorry,this is the parallel job

Hi All, I am trying to select and update the same table in the job and while running the job it is keep on running. I am trying to update 3 different tables with 3 different odbc connector stages . job design is like this: odbc -->Transformer-->odbc in the first odbc using select statement and in th...

Chullet

How can I call the user defined envifonment variable in the server routine.

If I need to use the routine in server job how can I pass those environment variables for the routine called in the server job job transfomer.

Sorry job type is server.

There is no such function

Hi All, I am trying to pass file path and other parameters to the routine say like $ filepath. In the dsgetparaminfo function. I am calling the same routine in one of the job and in the job parameters I am accesing the environment variables.which I am passing to routine, While running the job I am g...

That was for diff conversion

Thanks Arndw,

This is working fine and those control charcaters were removed and entries are showing correctly.

Arndw,

Whenever logentry has (...) end the end which has expandable content in the log,i am getting these characters and the line termination is proper

Arndw,

The server is on unix.
I am able to see the characters  before and after each entry.

Thanks Arndw, I am able to cleanup the file and write without repeated log entries in the file. But the entries are writing one after another on the same line rather than writing on new line for each new entry. what needs to be added to write the each log entry in next line .. Please suggest me on t...

premium membership got expired and unable to see the content.

Request you please post the same as visble and i will renew the membership in a week

Hi All I am using below code for writing log entries into the file but the log entries are writing repeatedly. PENSEQ InFile to output_file ElSE CREATE output_file ELSE ERRORCODE=1 For x = 1 to LCnt LId = LogIdList<x> vEventDetail = vEventDetail:Field(DSGetLogEntry(hJob,LId),"\",4) WRITESE...

Hi All,

Looking forward for the sugession from any one.