DSXchange

I dont think it will work. You will get an error, something like 'Job is not in the right state'. Thats why you have multi-instance capability in DataStage. To achieve exactly what you want.

I did a quick search and found this post. See vmcburney's reply at the end.

DataTypePicS9() expects values without a decimal as far as i remember. Havent used it for quite some time now. Try

That should take care of it.

Create file AND 'clear' or create file and 'Delete file before create' option?

Welcome Aboard Is the file in binary format? I guess you can use the cff stage. Play with it and see if it works. Also, you will have to ftp your file onto the datastage server first before you can do anything, unless you have samba or some other third party tool installed that makes the two servers...

What options do you have specified within the hashed file stage properties. Is it 'create file' and 'delete file before create' option or just clear file?

No. Unless you have desinged for a rollback.

What about the hashed file names? Make sure they are different for different hashed files and same for both building the hashed file and while reading it.

Not sure what made him think there was a 'static source' involved... I think you answered your own curiosity by saying: With the information you've posted I would guess your source changes over time, you'd have to convince us otherwise if that's not the case. Thats what i wanted to make sure. Maybe...

I think a better and safer approach would be to load that particular column in a temp table and do a sql select with a sub select.

Your going to get a lot of remarks because of 'ASAP'. Try avoid using such words that demand for help rather than request. Now for your question, i have some followups, Do the sources change in between every runs, make sure your hashed file names are distinct. You have keys defined properly both dur...

Cant help you here. Wrong forum. Need to post in either server or parallel as we need to know what engine you sit on, what platform yada yada yada.

How much time does it take for the same query to run outside datastage?
Does your target table have triggers on it? How many bytes in a row? Do you have any warnings in the datastage log?

Hehe. This is an interesting conversation (sense the sarcasm). Do a search in google on Informatica vs DataStage. You will find some helpful points. Such conversations lead no where. Try to avoid them.

Start ---> Run ---->type cmd and hit enter ---> go to this desktop "C:\DOCUMENTS AND SETTINGS\ADMINISTRATOR\DESKTOP" and there type prjbatch.bat
There you go, thats how you execute a .bat job.