DSXchange

That was going to be the next suggestion.

Done that before on UNIX but had no idea how to do it in a batch file and was poking around online trying to stimulate my old brain cells. Thanks for saving them from an early death.

[5/6/09 10:44:52:031 IST] 0000000a AdminTool A ADMU3011E: Server launched but failed initialization. startServer.log, SystemOut.log(or job log in zOS) and other log files under C:\IBM\WebSphere\AppServer/profiles/default\logs\server1 should contain failure information. I would start there, seems yo...

Someone needs to learn about 'Disable Smilies'.

Sankar - Dump the output from your timestamp conversion and check what you actually get from it. Hint: is your incoming year two or four digits?

MOVE is a DOS command just like REPLACE, from the command line type MOVE /? for the syntax.

qutesanju wrote:r u talking @ maunally copying files?

Come on, this isn't your dang cell phone and you're not texting your buddies. Use a professional level of English here. Spell out your words.

When they bought it, they would have received instructions on how to download it.

Same suggestion, get rid of the EXIT and just use:

START REPLACE \\PATH A\*.* \\PATH B /a

Not in a Server job. You can easily use Field() to get what you want from the filename, the trick will be getting it. How do you process multiple files, one at a time?

FWIW, errno 26 in Windows is the "text file busy".

kduke wrote:Some of the worst DBAs I know are certified.

Amen, Brother!

OK, go fo it. If you have a question, ask it.

I know, and you have your own thread now.

Please don't post the same question in multiple forums, even if the first one was the "wrong" forum.

Same answer as posted here - don't use Index for this.

Odd. I'd report this to your official support provider, see if it is a known issue. Which 8.x version is this?

Yes you can, to all of your questions. You'd need to explain what "Datastage is not recognising the shared location" means, though.

Use the Field function and tell it you have a comma delimited source.