DSXchange

This and your previous related post got me intrigued, I didn't even know they allowed two input links to a connector so had always split the streams. What's an "end of wave marker"? Generally it's an indicator in real time processing that the full data set has been sent allowing the stages...

Do you have the option of turning off RCP for the funnel stage? If you don't want these columns on the other side, why have RCP set?

As for the warning messages, are you sure you added the message handler to the job?

You mentioned all 19 were hitting the same DB, are these the only ones to hit that DB ? If so, your culprit is almost certainly a change on the DB front. How long do the queries take to run in a DB client? What database is it? Is there any load on either the DataStage server or the DB server when tr...

What's the timeout setting on the IPC stages? Are your jobs hitting this timeout value?

Going on the amount of memory being used, would suggest the aggregator is trying to sort the data. Add a sort stage just before the aggregator and set to "don't sort, already sorted" (or add the environment variable APT_NO_SORT_INSERTION?)

On the assumption that if there is a potential for multiple spaces in the middle

Field(x,' ', 2, DCount(x,' ')-2)

When there are only two fields you may need to do an if first as I'm not sure Field allows 0 for the number of fields.

That would require 4 byte characters, which the OP wasn't using. Not that I have a good reason as to why 400K should work

Or alternatively, if you are actually trying to switch your links around from the descriptions and make the A,B,C,D input your main link, disconnect one of the links first, then on each link, right click and Convert to ... (Reference for current stream/Stream for current reference), then re-connect....

Are you getting any dates coming through? Or all dates are being dropped? As with what ArndW said, are the first few rows actually dates in Excel? If the ODBC driver had determined the column to be date based on the first x rows, any that aren't explicitly dates in Excel will be dropped, whether the...

By "stage variable" I assume you mean input parameter, you couldn't possibly pass the stage variable to oracle... When datastage composes the query, what does the query string have for your variable section? Unless it's adjusted in 8.7, I would expect the single quotes to disappear, in 8.5...

Are you sure they are dates, or string representation of dates?

Has this question not come up in the last month or so? Even the sample data looks the same...

The columns getting a zero length are from the DCLI schema, did you try a describe against these particular tables (with the failing user)? Try do a table import against these tables, no idea if the process DS follows for this is different to when it determines a schema at run time but something to ...

Personally I prefer parameter sets. The Admin way sounds old school... not saying wrong but does sound a drag... I looked at the data connection way before and didn't really float my boat and as we manage all our details via a database anyway (except passwords!), not the most configurable of options...

One adjustment I would make is simplify your access to the "%", you use a count, field and index to get its position when just an Index would do. Something like... Var3=Index(Arg1,'%',1)-1 if Var3>0 Then TempString=Arg1[1,Var3] Var1 = FIELD(TempString,' ',DCOUNT(TempString,' ')) Ans = Left...