DSXchange

First you'd really need to confirm that you are in fact actually sourcing from the same database in each case. We've spent time trying to help people in the past when it all turned out to be a non-issue as they were actually pointing to two different ones. I'd also like to confirm a couple of other ...

asorrell wrote:It turns out WebSphere is case insensitive for the Base DN, but IIS is not.

Awesome.

Nice find.

It hasn't gone away. Not sure why you can't find it but it certainly should be there... somewhere.

Do you mean you are getting the -14 TIMEOUTerror? If so, have you tried doing an exact search here for that message? It has been discussed quite a number of times over the years.

So you haven't seen the vast majority of my posts in this thread?

Perhaps you should consider renewing your membership.

OK... so this is the contents of a batch file you are calling via ExecDOS, yes? And when you say "output" you're not talking about what it echoes to the screen but rather what the name of your file ends up being? Trying to understand exactly what is happening - is your file being "mov...

Googled for your signal and found this, perhaps helpful?

I suggested a separate job if DataStage was going to be doing the deletes or otherwise fundamental in controlling the action. If all you're going to end up doing is calling a stored procedure, you can just do that "before SQL" I your existing job.

Ok... that's good but it's nothing I would label as "copying" hence my concern. Never mind. :wink: The Column Import stage takes a record as a string and parses it out into individual columns, it doesn't effect any conversion in the process that I recall. I would think you should effect an...

Changing the contents of this post since the timing was a little off. The answer to your last question is "no". It doesn't do anything different than you would - create a DOS shell and execute the command. I mentioned the path because it is a common tripping point for people new to the pr...

Hoping you didn't quote that for me... was trying to say that I appreciated the fact that you had already done that in your original post.

Probably a relative v. full path issue but as noted we'd need to see your syntax to have any idea what is going on.

Dataset is multiple files. They are a) Descriptor File b) Data File c) Control file d) Header Files I've seen this posted in another DataStage forum and it confused me there and here... four files? I was fairly certain it was as Ray described but it's good to see it spelled out explicitly. Tanks. :...

I don't recall the gory details of that command... when you run it interactively from the command line does it stop and prompt for a response of any kind?

joycerecacho wrote:But I really would like to understand WHY it happens. Is it a kind of Bug?

We would only know the answer to that if you involve your official support provider and ask them. Please let us know what you find out if you do.