DSXchange

So... does that directory not exist or do you not have permissions to it?

Not clear. "autoincremental"? So, do you want to use this value as a starting point and increment it during the job? If so, get the value into the job (parameter / stage variable) and then add @OUTROWNUM to it.

There's no such thing as "all project names in the job", you'll need to search each project (separately) for the job in question.

Ask an admin or find your entry in the /etc/passwd file, the default shell is the last field.

You'll need to query the repository then. Search the forums for CSeqInput or OLETYPE to find several examples of what you'll need to do.

I assume so. Senthil, what is your user's default shell? I'll wager it is different from DataStage and your syntax is shell specific. That ".sh" file extension is meaningless, you need to set it in the script itself. For example: #! /usr/bin/sh As the first line to force it to use the shel...

You "release some space from the directory without affecting the jobs" by clearing job logs. Or perhaps by pruning the &PH& "phantom" directory.

... or just use the parameters in the routine call. However, I'm assuming it's not as simple as that and the file names are hardcoded, yes?

None of that requires administrator privileges, so... yes.

A search for "Could not delete partition 0" turned up only one other hit so it's not a common thing we've seen before. The "filesystem related" part implies a problem with the disk subsystem where the file ended up... did you have an admin check that out?

kittu.raja wrote:The volume is very huge. 8 million records. I cant go with server

Baloney. I routinely do multi-million record volumes in Server... and you're just going flat to flat? Should fly.

You don't insert or delete data from a hashed file, you write to it and read from it. And when you write a record it uses "destructive overwrite" - a complete replacement of any existing record with the same key value(s). So if you have "1,2" where "1" is in the key fie...

From memory - on the client cdrom in the "unsupported utilities" folder.

krishna81 - please go back and delete your duplicate post from the FAQ Discussions forum before someone replies to it.