DSXchange

Ok. Try one of these. They should work Call DSExecute("UNIX","echo $prm_project_path$prm_path_common",UnixOutput,SystemReturnCode) HashFilePath = Field(UnixOutput, @FM,1) OR Call DSExecute("UNIX","echo $prm_project_path$prm_path_common",Uni...

suri wrote:>ORA-01017: invalid username/password; logon denied

Your error tells you all.
Do you have special characters in your password?

Try creating another job with the OCI stage pointing to your present table. This time your source will be this particular table. This way you are passing a simple select. Try to view data from there. See if it works.

So much confusion going on. What are you trying to do? Can you explain in plain words.

That is because your routine says something else and the DSExecute() statement reveals something else. Tell me this, what are the values of $prm_project_path and $prm_path_common?

just4geeks wrote:very interesting.....no warnings while job runs....

That was a huge hint

You forgot a space before the time part.

I am just amazed as to how your data gets loaded with messed up data format and no warning shows up.

I think you will be better off to get this done on TIVOLI. I think they have a mechanism to monitor the run time and perform an action upon it.

Any directory on the DB2 server. Now see, its been a while since I last used the Load stage. I am pretty sure the Temp_Dir needs to be on the Db2 server. Anywho, try it. Create a directory that you have access too. Pass that directory path in this property. The load stage will create the files there...

Ahh....The field markers. Then how about the OP tries this

chulett wrote:[ I'm getting tired of explaining this over and over, guess that FAQ on the subject is long overdue.

I say AYE AYE for that

You sure your not sending in any spaces. Try

DB2 does. I dont think oracle does and hence my original question and doubt.
Try sending in your data as

Click on the property help. It will tell you what needs to go there. It basically requires you to give a directory path on the DB2 server, if i recall correctly, for the three files that are necessary to execute your load job.

Ok. When you check the data using TOAD. Do you see correct data? Is it the same one that you inserted?