DSXchange

Already have advised you - get an SA involved if ports have hung for any length of time, they can clear them. Normally, I see everything clear in 10 or 15 minutes unless you still have processes on those ports.

Have you actually shutdown DataStage yet? If you have and the ports are still hung, involve an SA to get them cleared. Otherwise it needs to come down first and then work to clean up what's left.

$DSHOME/bin/dssh

Get an SA involved if ports are hung and not clearing on their own, they have The Power.

No, you cannot use a 'dot' in the InvocationID as it is the separator between the job name and the Id itself.

Packed is packed and is neither ASCII nor EBCDIC. So while you do indeed need to convert character data as you've noted, packed fields need no such thing, and any 'conversion' will destroy them. You simply need to 'unpack' them. Now, I haven't used the CFF stage so can't you specific advice there bu...

First thing I tried when I saw your post was 'man source' but on our HP-UX systems I got nada. Guess I'll stick with the short form.

Sure doesn't seem like it.

Not quite sure what 'source' is, so...

command: sh
parameter: cd #pathname# && ls -1|grep "xyz"|sort -u -r -t"." +5|head -1

Where 'pathname' is a job parameter for the directory to execute the command in - in your case that would be '/etl/source/data'.

No thank you. Surely there is someone you work with that could help you with that.

Welcome! :D Dates need to be converted to 'internal' format first, then those two dates can simply be subtracted to get the number of days between them. Is that the unit of difference you are interested in - # of days? The IConv function will do the conversion for you, basically: IConv(YourDate,...

So just edit it, no need to post again.

If your Empno is a fixed width, why not read your file with comma delimiters and then split your first field? Substring out the first three characters, the rest goes to Empname.

You couldn't have missed much... check again. However, the 'expense' is well worth it. Not only are you helping support the site that helps support you, but from what I'm told there's more goodies on the way for Premium Members. Not only that, but you'd get full access to all of the Wurlod Goodness ...

That would have been good to know. Sounds like you've got the source file wrong - is it fully pathed and spelled correctly? And you'll need to add it to the actual filter command in this case, I do believe.