DSXchange

Not exactly a lot of information to work from. Do you always need to insert a period after the fourth and sixth character in this particular 10 character string? Then simply substring it and concatenate it back together with them in place: YourField[1,4]:".":YourField[5,2]:".":Yo...

Stage Variable.

You really should open a new topic, not just jump on the end of one that's sorta related. Then we'd know your DataStage version, operating system, etc. Plus, people looking for help on the same subject will have an easier time finding it, too! That being said, you need to do this via your Operating ...

Josy - That was basically the question I was answering and, unfortunately, the answer is still no. Your target stage is the one generating and logging the warnings. This will happen with or without a Reject link. Not to be facetious, but the only thing you can do is everything in your power to ensur...

Hmmm... if you've gone through all of the 'mutex' posts and nothing there has helped then perhaps you could try making the job less 'largeish' - is that a possibility? Do you have other jobs that are similiar to this job (in size / complexity / behaviour) but that run fine?

Sure. As long as you are staying within a single Transfomer - Stage Variables should fill the bill. Check your online help. Across Transformers in a Job you need to write custom routines that leverage COMMON storage. Again, read up on them in your documentation as there are some pretty big caveats t...

Ding! Ding! Ding!

Yes, it is - hand that man a Kewpie Doll! And don't forget to say 'xyzzy' every now and then just to confuse people...

Is there any way to avoid all these warnings?? I was expected to get only one warning indicating that N rows have been rejected. No. Your Target stage is generating the error messages and it will do so regardless of the presence of a Reject Row. All the Reject Row does is allow you to capture the r...

Just Ray, eh? Ok, whatever...

Dang, Tony... you went and helped. What's up with that?

To expand on this just a little, use Iconv to convert a date into 'internal' format. Once you have two dates in internal format, simple subtraction would give you the diffence between them in days... then you take it from there. Of course, this depends on what you mean by 'months'. If a month is a g...

Granted. But there are times when there isn't either the time or the inclination to quote Chapter & Verse on the subject of Better Ways and we simply... answer the question asked.

Besides, I'd rather leave that to Ken most of the time. He's so darn good at it!

Your quote holds the answer. Simply change the F1 = '1' part to F1 = '1268265' and you are set.

I have tried it and it works fine with different hash-files(as in ur picture)... but i was looking to do it using one hashfile(same one)... It is one physical hash file. You just need to reference it using two different Hash stages, both pointing to the same hash file. As you've found, you cannot u...

You did great with the picture... and it shows the loop in your job, from transformer to hash and back again. You need to use two separate Hash Stages, both pointing to the same hash file - this will break the loop. More like: input----> Transform(lookup/update hashfile) ---->output ^ | | | ...

I tried doing it and it gives "cyclic or linear dependencies" error on the transformer. This error means you've created a 'loop' with your job stream. What you are trying to do is pretty basic stuff and should work fine when properly laid out. If you can't get past this error, please post an "pictu...