DSXchange

Is your environment NLS enabled? If its not then why you using longnvarchar or even nvarchar, just use varchar.

gateleys wrote: but it was the OCI (since it overlooks the scale).

gateleys

Dont you hate it when such things happen.

Looks like your system is heavily loaded. You think that might be it, check out this post
http://www.dsxchange.com/viewtopic.php?t=88070

We are glad to have you on board but please do not start multiple posts on the same topic.

Hey DSGuru2B, I am amazed that you never have had to work with Decimal-typed fields (with scale). I dunno if that makes you blessed, but certainly, you did not have to scratch your head (like me) and wonder 'what the heck could be wrong' when the CRCs did not match (when they were supposed to). And...

What link are you providing in the linkname.REJECTED. That linkname should be the one going into the database.

Yes very important. Just recently Ray mentioned that the user id must be entered in cron.allow and at.allow. That is, offcourse, if you are using these as schedulers.

If you have access to ADN, there is a job posted there (.dsx file) which clears all the log files. Very useful and handy, you might want to look it up.

Its all about design. You need to put down the psudo-code on paper. Then as mentioned by Krazykoolrohit, its just a mastery of unix, which you can master within a few days. Then its just a matter of translating that psudo-code into unix code.

The rejected works properly only if you set the Array size to 1. Do you have a higher value set ?

Problem is simple, your sending in null values.
Or maybe while building the hashed file you have one key defined and while reading the hashed file you have another key defined, or maybe the meta data is not identical. Look into it.

Get all the job names in a file, in the order they are supposed to be run and then you can do something like cat $joblist | while read job_names do dsjob -run -status $PROJ $job_names done This is very very, basic. Just to give you an idea. You will need much more commands and logic if you want to i...

"How about you whack Client upside the head for us?" I vote for that. No Craig, i have seen in here and only here. No where else. There have been times when whacky clients have tried to take me over, but i stuck to my word and after a wild goose chase when no other option was of avail, "they" had t...

I guess i have been blessed then
Did not have that problem in hashed files. Well as a matter of fact, never got a chance to really load dollar amounts in a hashed file. Maybe thats why

I have never seen, at any place, where "they" tell you how to do your work. That means "they" know a better way out and therefore "they" should get it working