DSXchange

Hello Bernardo ,

Welcome Aboard !!!

Please search the forum with keywords timeout waiting for mutex .

This topic was discussed several times.

Paddu

what is your source ???

all the values in this column have this issue or only few values ????

Thanks a lot :D

Paddu

I have sequential file stages all over the project to read and write files .

what if i don't change the line termination ?

chulett - Will the jobs run fine with no change?

I have sequential file stages all over the project to read and write files .

what if i don't change the line termination ?

chulett - Will the jobs run fine with no change?

Thanks Ray, Changing hard coded paths sounds good. so by default when we move jobs to Unix , sequential files do not use unix style line termination. Line termination needs to be changed manually from windows to unix. Is edit export file search and replace line terminator the only option??? example ...

Thanks vmcburney,

you mean in the dsx file i can change the hard coded paths ?
But i don't see any option of search or replace while importing or exporting the file

Any idea on other questions i asked in my initial post?

Apart from these , should i be concerned of anything else. 1. Change file paths 2.Changes ExecDos with ExecSH 3. new line Characters Some questions: 1.Is it fine if i need to move hashed files to 8.0.1 on Unix? 2.Will the Line Termination automatically change to Unix style in sequential file stage ,...

rmcclure wrote:I changed the job to pass the 20K records to the hash file instead of re-creating the complete file, I also removed the create file options.

Did you change the keys ?

I have no issue in my job which does inserts and updates to hashed file

pimmit22043, Do you really need to use custom insert? As Ray suggested you could acheive sequence numbers using a @OUTROWNUM or you can even use Keymanagement functions. OR Else if this scenario is only to this job and you really need to use oracle sequence DT_SEQ only then why not create a trigger ...

If your date in question is within the first 7 days of its month (day number is 1 thru 7) and the day of the week of your date is Monday, then logic would dictate that your date is the first Monday of its month. If this is not right for your situation, then you need to clarify as I see two differen...

if anyone in your team has admin rights , go to the logs directory on the box and try deleting the file manually.May be it does not allow to delete the file because the job is still running. This happened to me and all i could do is wait for the job to finish and then deleted the log file going to t...

Oconv(Date(), "D-YM[4,2]") : "-01" yields the date of the first of the month. That should get you going. Ray, I not trying to achieve date of first of the month from the current date. Sorry i did not look into your post indetail before. I am trying to see if the GIVEN_DATE (coul...

Really !!!!, Let me try this tomorrow .
Not at desk right now

Hi I have 3 columns that i'm trying to insert into table. here is the insert insert into table_dbt (A,B,C) VALUES (dt_seq.nextval,:1,:2,:3). is this statemt is right ? my job is like below. seq stage ===trsfrmer===> orcl stage. anybody came across can you help us. if you want datastage to pass only...