DSXchange

kumar_s wrote:Or as mentioned, google for the C code. http://www.planet-source-code.com/vb/sc ... 0&lngWId=3

That particular code is a horrible example of C code, as the comments following it indicate. Further, it replaces only the first instance.

Parallel Transformer jobs DO support reject links - see my earlier post. But the OP probably requires an Otherwise/Log output link. But it is true that the parallel Transformer stage does not have link variables available in its expressions.

Use data type Char(10) for the DY_DT field and convert it to a date subsequently. Or use data type Date. If the encoding is EBDCIC (which I don't believe it is, since 0x31 is 49 and Char(49) is 1 in ASCII) then you can specify translation in the Sequential File stage. Let's look at your first record...

Either of the two solutions will work for you. Initial value is 1. Either use 0 as the increment, in which case limit is irrelevant, or use limit 1, in which case increment can be any non-negative integer, but 0 or 1 is easiest.

Telenet wrote:-filter condition USAGEHOUR<12 for link 0, >12 for link 1

... and discard the input row if USAGEHOUR = 12 ?

The symptom suggests that one or more parameters is not being passed correctly from the main sequence to this sequence. Only you can diagnose it, because only you have access to the sequences in question. Put in a Routine activity to report (to log) the values received as parameters.

Version Control is free, and is on your DataStage clients CD. Be warned, however, that there is no Version Control in version 8.0; it will be replaced (in version 8.2?) with "something more closely integrated with source control tools such as ClearCase". There are third party tools such as Parameter...

Is the file server UNIX or Windows? How do you "see" the file server from the DataStage Windows-based server?

The "answer" is that Link Collectors does not support inprocess active to active links. It must be connected to passive stages.

Surely dsjob -lognewest and dsjob -logdetail would have been easier!

Discounts remain available for bulk purchase ("Corporate" memberships). There's a link somewhere on the forum. The low rate was an introductory offer - even at the standard rate premium membership does not cover 100% of the bandwidth charges for this site. It's still pennies per day and, I'm sure yo...

I don't believe Arnd has come to Australia, though it is something he'd like to do at some point. I'm sure he would have been in touch to arrange having a beer or three.

One of the statistics recorded in a user profile on DSXchange is posts/day. Just curious, is this "day" based on the user's local time or on the time at the DSXchange server?

Just curious because my time zone changes more often than most.

Where did you pull "say more than a million records" from? The error message in the original post refers to (approx) 500MB. I have a vague recollection that there's an environment variable that controls this - would be surprised if there weren't - but don't have access to research it at the moment.

Use an upstream Modify stage.