DSXchange

Did your "some fix and workaround" involve more than replacing the transformer with an exact copy of itself? I'm also assuming there is a constraint on the output link and that evaluating to false before your change is what caused it to not "pass" any data - can you confirm? I'm ...

Five years later? Best to start your own post and tell us exactly what this "same issue" is that you are having.

The function is "upcase" and if it still doesn't like it, do it before the Filter stage.

Five warnings, yes but a job will abort on the first error.

Not the "data type" but rather the data element, a specific column property.

Yup, 2GB is the minimum memory requirement for a client PC and that's why you are seeing your issue. Things work but not all the well. As far as how much would be required, the more the merrier but you'll want at least 4GB.

Not working HOW?

Note that the goal is to get it into a timestamp, something which does NOT carry an AM/PM designation. That's all about the external format when it is selected so your "example" is correct... but far too much work to get there.

Let's make sure we're on the same page - when you say "basic transformer" do you in fact mean the "BASIC Transformer" in a Server Shared Container as in the one that comes from Server jobs? That was my concern as I didn't see anything Server-like in what you were doing. If you ju...

Check the documented time formats supported by DataStage. You'll see that %H and %HH are used to handle a "12 hour format" which is what you have.

I'm going to assume the issue is writing to it... Use the Hashed File Calculator that (I believe) still ships with the product to determine how large to pre-create the hashed file, i.e. what Minimum Modulus to specify. The default is 1 which means it starts off tiny and spends a great deal of time e...

Meaning what, exactly?

That would involve querying DS_JOBS where (from what I recall) the job type is stored. And you would launch the select using dssh. The values for job type should be documented in one of the engine's include files or perhaps some kind soul will post them or link to a post containing them... I didn't ...

Exactly. That or xargs are the two options of choice with find.

Also wondering what your source dates look like as I'm not aware of any 'julian' dates that can be converted by adding 19000000 to them. Can you post some examples including what their corresponding converted value should be, please? I'm guessing they are all normal Gregorian dates in YYMMDD format ...