DSXchange

Search the forum for handle_null which doesn't seem to be documented anywhere else.

Pay attention to the version of DataStage in the post, peoples. Version 6.x didn't have any kind of check-pointing or the ability to 'automatically handle' much of anything. The OP will need to upgrade to get anything like that in their life. Also note that it's not a 'parallel extender version' is...

If you read the documentation for the OCI stage, or check the generated SQL in the stage, you would see the 'formatting' required to load by examining the TO_DATE it wraps around each one. I'm going to make some ass-umptions about your job. OCI stage and generated sql of some kind in the stage? The ...

That or correct the jobs so they do not generate warnings... then this whole issue becomes moot. There really isn't a good reason why a Server job should ever generate warnings.

That 'something' is the file. As noted in the email itself, the file has been MIME encoded and included in the body of the email rather than being attached. Your email reader would then need to decode the email to restore the file to its original state. See web sites like this one for the gory detai...

Yup... specifically this.

Better to store them in a database table... then pull them into a hashed file to use for checking in the actual process run. Do you have the permissions you'd need to delete files from the ftp server? If so, you would just issue a del command inside the ftp session - your scripted ftp session. The o...

Im pretty ignorant of the fact that EE on windows is supported for only 7.5x2, assumed even 7.51A would be so . Oh, it is 'supported' on other versions... it's just that the only version that can actually run PX jobs in a Windows environment is 7.5x2. The other versions can, as far as I know, be us...

So does anyone think it's possible to create two versions of VC exe's? You've already done it and are using it successfully, from what you've said. I don't see a problem with that approach as long as you connect to two different repositories when both are active at the same time. Not saying that wo...

Plan to phase out Version Control. That's lovely. So, are you saying that once someone upgrades there will be no way to promote jobs in any kind of similar fashion to VC - read only, compile for me, dependant components, etc? And integration with 'regular' SCCS tools won't be until months later? Be...

Your only option is to start the main Sequence job with a Warning Limit of 1000 and that limit will automatically be passed on to any child jobs run by it. It's an all-or-nothing approach unfortunately.

The fact that the attachment is not, in fact, attached.

the target table option is "update existing and insert new". Your problem in a nutshell. I personally never use these 'dual action' actions. It must first try the Update and then if the update fails then try the Insert, so could take two actions to do what should have only taken one. Especially if ...

Not using, but do have the Click Pack installed. That sounds exactly like what the POP3 Email Reader stage does... surprisingly, it connects to a POP3 source and reads email. Not sure about the 'get the attachment' part, but if you can do it with Perl you can do it with the Click Pack from what I've...

As noted, you don't need to stop the Sequence when the file is not found, simply do not execute any of the downstream processes. And all that takes is the correct conditional trigger.