hi, how are you every one?
I develop a job which is extracting data from sybase database by sybase EE. I have two login users, and both of them can login in throgh sybase client. When I run the job, it finishes successfully using one user but abortes using another user. The messiage is "The parallel job encounter failed(code 255)". Can any boy give me advace? It is best you can tell me the requirement for using sybase EE.
Best regard!
sybase EE abort
Moderators: chulett, rschirm, roy
There will be more error message that are more helpful than the one you posted. Do you mean a different DataStage userid or a different Database userid?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
The userid question must be answered by your Sybase admin, most likely the GRANTs are insufficient. DataStage has no requirements - just that the ID you specify has sufficient access to perform the action required.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>