DSXchange

Hi I have two date fields. extracting years from dt1, month and date from dt2 ,format os dt fields are yyyy-mm-dd DSLink389.DT_CNTRCTL_MTY [1,4]:'-': DSLink389.DT_OPTN_BEG[6,2]:'-': DSLink389.DT_OPTN_BEG[9,2] and converting from StringToDate. . Are they truly date fields, or string? What is the dat...

Would you like to re-express that last sentence in English please?

Not everyone on DSXchange is familiar enough with English for what you wrote to make sense. Let's make it as easy as possible for them by sustaining a standard of professional written English.

Get the Orchestrate Operators manual from your support provider, or when you attend an IBM training class. There is really no other good reference.

Attribute your sources!!! I heard (on the BBC so it must be true) that gays cause earthquakes. I'd be more worried about that than IBM stopping DataStage in the foreseeable future. U does not log in very often, so is unlikely to forward anything any time soon. The second person personal pronoun in E...

Ah well, back to the ol' two-character variable names!

So what we were thinking here is that something was interfering with transfer of the rows from your Link Collector to your Sequential File stage. Calls to ds_ipcopen() come from the Link Collector stage, which is known to be a bit "flaky". Recall that the Link Collector stage establishes a process f...

Welcome aboard. It's the name of the Orchestrate operator that you want to invoke either in some non-standard way or because it's one of the (few) Orchestrate operators that is not already encapsulated in a DataStage stage. Documentation on Orchestrate operators can be found in the Orchestrate Opera...

Assuming it's some kind of Rich Text control, that's at 64K lines!!

If it works Ken will explain why it did. If it doesn't, one potential source of the symptom will have been eliminated.

It does work. I just tested it. Here's what I see in the "job starting" event in the job log: Starting Job EnvVarParamTest. $SEASON = Spring [$PROJDEF] It correctly picks up the default value for the project, and annotates that as being because the $PROJDEF token was encountered. What more could you...

Then on what basis are you claiming that it's not being recognized? Look in the "job starting" event in the job log and report the values of job parameters being passed to the job. It may be, of course, that this mechanism does not work with server jobs, only with parallel jobs. That also would need...

You will have to wait for the next time U logs in to get this information.

The correct spelling of the second person personal pronoun in English is "you".

Then these rows ought not to be being dropped. Do they go down the reject link, or simply disappear?

You do not need an Aggregator stage at all. Given sorted data, gradually building each row in a Transformer stage, and taking the last of each group (sort key value) in a Remove Duplicates stage, is a sufficient solution to the original problem (which did not drop row 102). To drop rows with no non-...

The reference data are always loaded into memory, except in the (rare) case of a sparse lookup. The only speed gain a Lookup File Set offers is that the index to those data is pre-built and does not need to be built "on the fly" by the LUT_CreateOp operator. However, even 17 million rows is not that...