DSXchange

Could you simply not check the 'First record is header' option in the Sequential file stage and add a constraint that skipped the first record if it found your 'certain string' there?

I'm assuming this is related to another post with the exact same problem that was resolved over in the FAQ Discussion forum... yes?

You do it in the exact same way - mark the field as a Key on the Columns tab.

How did we get from needing to 'know how many records are of value > 10' to checking a sequence for contiguous numbers?

Your example is good to post, but please explain your requirements in words rather than expect people to infer it correctly from your example.

And as noted, I've never had an issue with either -wait or -jobstatus not waiting properly. The poster 'tcs' noted that they found it to only be an issue in a very specific situation - and that the use of -local aided and abetted the problem as well. Which would probably explain why I've never seen ...

Welcome. :D Unfortunately, it sounds like someone has thrown you into the deep end of the pool with no life preserver. Understand that we're not really here to be a substitute for proper training and your questions are very broad. Are you working with anyone that can tutor you on the basics of DataS...

You guys are hijacking the poor dude's thread. The question was how to detect the file and then either email or process it - not the merits of stage versus command line ftp.

If you created the hashed file 'pathed' in a directory rather than the account, you need to create a VOC pointer to it before you can use it with the UV stage.

Search for 'range lookup' amongst the forums and you shall find what you seek, Pilgrim.

One row in that returns three rows from the lookup = three rows out, not four. Multi-row result set is a property of the Reference link, did you enable that?

Sequence job, Wait For File stage with a zero wait time, and triggers after that to either run the FTP job or send an email based on the result.

Then you need to report this as a bug to your official support provider and see what they have to say. All you should have to do is change the value in the Administrator. Clarify something. You set the value in the Administrator and then your jobs are set to what for their default value? $PROJDEF, y...

In the 7.5.x releases you should be fine changing environment variables in the Administrator without recompiling.

Manager / Tools / Run Multiple Job Compile

What's your exact 7.x version number?

The Mananger has a Multi-Job Compiler you can use to, well... compile multiple jobs.

Well then, this should be working. Any chance you created the Sequence job such that it captured the current parameter names at that point in time and then changed the names in the child job afterwards? Or perhaps vice-versa? I ask because you show parameter names like TRG_DB and it is complaining t...