DSXchange

Sorry, but I'm not the one that is confused here. :wink: I wasn't suggesting that you sort or needed to sort anything, *I* sorted your range values to illustrate your problem and to reinforce Ray's comment of "Give some thought to how...". These are string values so the "ranges" ...

Put your six string values in a simple text file in the order shown and then 'sort' it - the result should help illustrate your issue. For example:

0120
0200
0250
0260
00120
01999

Sorted:

00120
0120
01999
0200
0250
0260

And I'm very sure your data is not matching or the lookups would be succeeding. Don't assume - check - view data and click inside the fields, both sides.

Good job on working that one out.

Until that functionality was added in 8.x there was no other way. And yes, it can be painful at times but certainly not impossible.

Your question on "is there a better way" has a simple answer: no, not really.

To expand a little on what Arnd said, you would 'Add to Schedule' 24 times.

As i am new to Datastage , don't even know how to proceed with it? You've been posting questions here for almost a year now, not really all that new at this point. And your rather ambiguous question has already been asked and answered. :? Yes, dsjob is the right command and the job's folder doesn't...

This post might be helpful. Add CATEGORY into the filter if you need to. You should be able to build a job to dynamically pull an appropriate list of job names from the repository and then do whatever it is you need to do with them. Perhaps use a custom routine called for each row that takes the fo...

Not sure. Keep in mind that "fixed" means a constant width whereas varchar is a variable width. If you can ensure they are always padded to their full size as a varchar then it will be fine.

A 'one time' delete like that would be something you could do as the 'Open Command' since that runs once when the job starts.

Perhaps... it really depends on exactly what "delete certain records" means. Do you need to delete once or before every row? For the latter, does what needs to be deleted bear any resemblance to what is being added, key-wise?

Correct, the XPath Expressions go in the "Description" field... glad you got that figured out.

You should be able to set the Record length property to either 'Fixed' or an actual byte count. Fill char would be 'space' and the Field Delimiter would be 'none'. You may or may not want a Record delimiter depending on the exact kind of fixed-width file you need. And those VARCHAR fields would tech...

A Sequence job would automate that for you. Use the UserVariables Activity stage to capture your delimited list of filenames and then the Start Loop stage can iterate through that list, passing one each loop to the processing job inside the loop.