DSXchange

You might want to read through this earlier thread where someone else had a similar dilemma. They came to the conclusion (after working with Ascential Support) that it simply wasn't possible to do what they wanted. I'm afraid you may be in the same boat.

SHLIB_PATH is correct for HP/UX, it's what we run here. You need to make a small correction to your settings as you seem to have the classic problem of pointing to the 64bit Oracle libraries rather than the 32bit libraries first. Try it like this: SHLIB_PATH=`dirname $DSHOME`/branded_odbc/lib: $DSHO...

No, DSExecute is a DataStage function that can be used to run operating system commands, amongst other things. You are going to need to be a little more specific so we can help. You marked your Server platform as "UNIX" in your first post but also just said that "data stage is in windows environment...

if the number of records in a file is less than zero then my further sequence should stop from running. You might want to restate that requirement. How about a simple "wc -l" command? That would return the number of records in a file and you could then make decisions based on that. Your routine cou...

True on any UNIX server... the trailing & means you want to run your command in the background. Escape them and you'll be ok:

Also, if you have a tool like TOAD, it can compute the Average Record Length for you - either based on the metadata, or (more accurately) by scanning the contents of the table.

PX questions should really be over in the "Enterprise Edition" forum, that's where the PX gurus hang out and play.

Do i must creat a new Version project ? No, but you can create a new version project if desired (with a different name) and see if a clean one works better. Version Control does support having more than one VC repository at the same time, btw. Or do i must export all components of the old VERSION p...

It shouldn't be an issue with a VC move, but I believe it can be when using export/import if the 'include defaulted properties' (or some such) is not checked.

The basic answer is 'yes'. Definitely on the 'can we use hash files created in 6' question, they haven't changed and are directly usuable. On the question of moving them, again a yes with a caveat or two. If they were created with the 'pathed' option (ie, not in an account) then yes, simply move the...

You can't... if the procedure is doing all of the work, you'll need to have the procedure capture and log its own stats. DataStage won't have a clue what it did.

It does use dld - the Dynamic Loader. And dld is what is complaining that it can't find a shared libarary to load.

I'd do a search for that missing .sl file and add where it lives to your Shard Library path in dsenv, bounce DataStage, and see if that helps.

How are you moving them?

Actually, in a way, both are correct... 1) True when reading a sequential file with the option checked... even if the first record isn't column headings! 2) True when writing to a sequential file with the option checked and the file either doesn't exist or is being overwritten. If you are appending ...

There is a routine available over in the File Library on the ADN website called JobReport that will do that for you.

Or if you have 7.5, that functionality should be included, I do believe.