DSXchange

Use a Head stage rather than a filter command. The Sequential File stage executes in sequential mode on a single node, so the number of nodes in your configuration file does not really matter.

What did you get on the reject link?

Is this file re-created between runs? If so might there be occasions when the data in the file do not match the defined record schema (metadata)? Add a reject link to the Sequential File stage. Direct the reject link to a Peek stage so that you can see what the Sequential File stage attempted to rea...

Could I suggest, next time you review this expression, that you make it self-documenting? For example Using the weekday name rather than a number makes it clearer to the maintenance programmer what you intend(ed).

Given that such is the case, your rule is the perfect choice.

Did you have an attachment when testing with SoapUI?

There are two issues at play here. One is the views over XMETA (of which IAVIEWS is one). The other is privileges; apparently the Oracle user you specified in your installation dialog does not have sufficient privileges in the database. Check the Oracle logs to determine exactly what operation faile...

Check your Engine credentials (the user under whose identity jobs are actually run). Does this user have the shared library search list correctly set?

Yes it does, but you're supposed to pass a negative value, such as -10. Ultimately the object of this exercise is to demonstrate restart capability in the sequence.

I'm not sure exactly what you did.

You can use the scanning and "search anywhere" components in PAL, for example *+

It really depends on exactly what you want to be able to do.

Thank you for posting complete solution.

Note that yours will pick up **[text) for example (mismatched brackets).

But if you are 100% sure that the brackets will always be matched, then your solution will suffice. Otherwise you need a pattern with OR operators.

rjdickson wrote:'U' in the first position means 'Unverified'.

Is that true for "USA" too? How about "UK"?

You have to verify that the parameter value is being passed correctly. Inspect both the sequence log and the job log.

This looks like one of the lab exercises from the DataStage Essentials course. What value did you give for RecCount1 when you ran the sequence?

You need to get a premium membership to read the entirety of my answer.

To address your most recent question, my answer would be "only in a sequence job that reads the file".