DSXchange

Transforms are only available in server jobs (and therefore in expressions used in sequence jobs). They may be available in the BASIC Transformer stage in parallel jobs - I can't check that at the moment - but would not be available in any other parallel job stage type.

I would be very concerned to verify that every single source value (irrespective of its metadata) could be shoehorned into the target data type. I'd be throwing an IsValid() check in there somewhere.

Where did you get this impression? How many bytes are used for Time without fractional seconds?

8.0 as far as I am aware.

You're right that there's no DataStage scheduler in version 7, which is the version indicated by the OP. However, Information Server does have a scheduling service in version 8. But that scheduling service does not include a "file watcher" equivalent. Other than multiple Wait For File acti...

Welcome aboard.

Question: why is the metadata unknown at design time? On what, therefore, are you basing your design?

Tsort is a place on Terry Pratchett's Discworld.

Your example doesn't match your words. For example record 1 does not end up with a C in Code1, even though there's a C in the record. Please re-state the problem or tell us that your words are correct but your example is wrong. What's to be done if there's no C in the record? If your words are corre...

A psort is a sort with a silent p, as in swimming.

Try it. Let us know.

Why "without using UNIX command"? Is this some kind of interview question? You should be able to use every tool in the toolkit. Is the layout of the header and trailer records the same as that for the detail records? If not there is a very simple solution of adding a reject link to the Seq...

8.5 client can NOT be used with 8.1 server.

Pattern Action Language uses + for a single unknown word and ? for one or more unknown word (unknown = unclassified). In Investigation there's no value in differentiating between them.

Try it. Find out.

You can find out which versions of Informix are supported by reading the on-line help or documentation at the Information Center. As a rule of thumb support exists for the current version and one or two versions back, but sometimes the database version leapfrogs the IIS technology and there is a bri...