DSXchange

Go to datastage administrator and inside your project directory, go to properties and check the box that says "Enable job adminstration in Director"

I dont know how the filter will work for numeric data. Try a test job in which you change the integer to string and then put the filter option on the string. See if that works without a hitch.

Even Craig mentioned it in his post.

If there is something extra then I am not aware of it. Maybe one of our elders can shed some more light on it. Else you can always call support.

What about your metadata? Do you have this column there? Do you have user defined sql?

Its a simple TCP/IP connection methodology as far as I know. A client server connection methodology. TCP/IP have their own mechnism for passwords. So the question balls down to "What method does TCP use?". I think its better if you search in google.

Never saw it, change it to varchar and see if the warning remains.

These are executable files. Nothing much I can do at my end. I think its time to give support a call. Something wierd is happening. A bad memory address was being accessed or something.

You cannot. But they did get affected. Someone else is having a similar problem today here . He claims that a working job, if copied and renamed was displaying the same error message. Maybe you can give it a test shot. Take a job that works. Double check if it works by compiling and running it. Make...

Ok. So if you copy a working job and compile it. You are having problems? A working job huh ???

If its just one job then I really doubt you guys are having the same problem. Although the error messages suggest that you are. Make a copy of the job, rename it and delete the old one. See if that helps.

A similar problem is going on here.
WHat has changed between the time it worked and now?

You might have nailed the problem. Go back to your admin and start questioning.

You both dont have to post the same post twice.
Anywho, build a routine. Pass your parameters as arguments. This way it can be used for any number of files. And how are you running a routine in ExecSH. Or you mean your just running the mv command in after job subroutine 'ExecSH'.

The load id/batch id is used in many sites for the same reason. But even that would require a specific DELETE FROM TABLE WHERE LOAD ID = <some number>