DSXchange

Yes, check in your unix folder /Data0.

Did you try executing with datatype as varchar and length say 26 and no scale on both the databases. You need to find what length of varchar datatype will work for both databases. If you can find that, you will be all set.

Ok heres how I do it. It should give you a clear understanding of how to get this done. dsjob -lognewest $Project $JobName | awk -F"\=" '{print $2}' | read BeginEventId ((BeginEventId=BeginEventId+1)) dsjob -run -jobstatus -warn 1 <Project> <JobName> dsjob -lognew...

You cannot see it. Did someone delete it Try to create a routine by the same name and try to save it. If its there it wont let you do that.

When you run this as a batch job and it gets aborted. Try resetting the job.A message "from previous run" might show up giving us more details on whats going on.

One of my collegues brought a smiliar issue to my attention. It was server though. It had about 10 stages and long link names and stage names. The job name was pretty long too. One of the hashed file stages was ending abnormally. After trying different things without avail, i just make a copy of the...

Also try #include "string.h". See if your compiler recognizes that.

Try with one database first. Just load the columns. When one works, build the same in a seperate job for the second. Keep them seperate. You dont want the failure of one to effect the smooth execution of the other.

chulett wrote:Thank you for confessing your sin, my child. It helps all of us.

I'd say go for Craig's solution. Make the date field as varchar. Pass in a parameter as DBType. Check for parameter value inside the job and in a stage variable switch betweent he two formats.

There are other ways to pass parameter values as well. You can use dsjob -param paramname=value also to provide values to your job.

You can also incorporate Len(in.Col) < 1 in Whale's code to handle source files.

Sam, did you try giving the StartDate and EndDate with quotes. I built a sample job with that routine (Great routine by Ray btw), it works fine for me. But I tried by passing StartDate and EndDate with quotes.

Its really not all that complicated. All you need is sorted input on the key, two stage variables and two output links. The stage variable will compare current key to previous and mark flag it. Use the output link constraints to constraint the output.

Basically that subject matter is out of the scope of this website. You will probably get more information on google or an AutoSys forum.