DSXchange

Precisely what I suggested. Set them up as input text overrides. They will reside in a separate (text) file reserved for input text overrides.

I don't have QS at the moment, otherwise I could tell you the name of the file. Read the section of the manual about Rule Sets; it will tell you.

Where is this code? An If..Then..Else expression mandates both a Then and an Else path. Yours lacks an Else path. As to comparing dates, I think that should be possible provided that each uses the same format. (InputLink.A = "0001-01-01") should be a valid expression (and one that ...

Are you using Round Robin or Sort/Merge as your collection algorithm? If it's round robin, I believe it can start generating output as soon as it sees a row on any link BUT it should not close just because end-of-data has been processed on one input. That, I think, is a bug. With sort/merge a simila...

Is your instructor certified in exam 415?

The problem is in the first line of your file (record 0).

Please post both the record schema and the first line of the file.

Surround each (separately) with Code tags please. It makes it easier to count characters if you do so.

Tryor or just for three.

Can you do it without a Link Collector? Write all rows into a hashed file, with artificial keys generated in the Transformer stages (for example A1, A2, A3, ... and B1, B2, B3, ...) to see if you get the correct results by this means?

meet_deb85, please use a professional standard of English at DSXchange. It is difficult enough for those participants whose first language is not English when the English is correct. Introducing SMS-style abbreviations, which assume too much, such as "u", "ur" and "plz", only add to their difficult...

I can't really check this until next time I teach DX444, which is unlikely to be before November. Your trainer should, however, be able to solve this.

Not really enough information to go on. What happens inside the Transformer stages? Do you re-compile or reset between runs? How long do you wait between runs?

Date (except within Oracle) is not the same thing as Timestamp. The ODBC driver enforces this difference. Turn your date into a timestamp using appropriate Transform (TIMESTAMP).

Please explain that requirement more carefully. Parameters can only be passed before the job runs, so whatever it is that you are proposing would require some kind of pre-processing of the source data.

Use a server job (since there's only one row) - the overheads are much smaller. Put the returned count into that job's user status area (search the forum for techniques), and retrieve it as the $UserStatus activity variable from the Job activity that ran that job.

Yes. You would have found it by searching the DataStage forums. A parallel stage has a sequential stage downstream of it, but the setting of the parallel stage is "preserve partitioning". Changing this property to Clear stops the upstream stage from trying to require the downstream (sequential) stag...