DSXchange

Not sure how I can. You are looking for nulls and there are none. Which means you need to check for 'empty' fields instead.

Ah... should have realized that was what was meant by "inbuilt DataStage functions", what with the DSU prefix. Which would imply there is no "known working fine" server installation behind it.

You'd have to create a NullToValue transform as it does not ship with the Server product, but it is quite easy to write. Or do the equivalent IF-THEN-ELSE check directly in the derivation using IsNull() as noted.

If an IsNull() constraint does not allow any rows to pass then there are no null values in the fields you are checking. Check for either an empty string or (if CHAR fields are involved) an 'empty' value of all spaces.

Easiest way is to simply install 7.5.3 over the top of your 7.5.1 installation and it will automagically upgrade everything. Make sure you have backups just in case! :wink: Or you could install 7.5.3 on a new server and then do a full Import of the 7.5.1 jobs into it but generally it is a very easy ...

Depending on the exact 7.x version you have, the Notification Activity stage in a Sequence job supports attachments. Otherwise you could always script a call to sendmail or your favorite command line mail tool and run that after job.

Create a generic routine that uses DSGetLinkInfo() with DSJ.LINKROWCOUNT and call in it a Sequence job. Based on the output count, run the appropriate 'post' job.

That's easily solved. And regardless, I'll wager you can see the critical bit of information provided.

I wasn't convinced myself until I watched it do it with mine own eyeballs for the first time many moons ago.

That may not be well supported in 8.0.1 or require a patch, perhaps a call to your official support provider is in order?

I guarantee you it was created in BYTES.

Perhaps simply changing the datatype in job to LongVarchar would help?

You can certainly use "cut" to get the portion of the filename you want. However, how you then compare that to get a number of days in a shell script I don't know off the top of my head, but I would assume some judicious googling would turn something up for you.

1,2: Sounds to me like you may not have a successful DataStage installation on that box, that or perhaps a permissions issue. Or maybe even both. I would suggest an uninstall and reinstall of the client there. I'm assuming you are connecting to a known 'working fine' Server installation and these is...

You could try switching the DRS stage to ODBC or switching to the ODBC stage itself, it's the only one I'm aware of that will not care if the parameter markers (or lack thereof) do not match up to the columns in the stage. I personally know the ODBC stage supports this as I've taken advantage of tha...

You can use DSExecute in the routine to run what's in the square brackets. Then check the output and delete the file when empty. And please people, stop piping cats - there's no need for that little bit of animal cruelty. DSExecute("UNIX","wc -l filename",ScreenOutput,Status) Whe...