DSXchange

Well... it does repeat this several times and seems to me to be something you should be doing: 2016-06-06T12:29:00.697, INFO: Exit Code: 255, Info: The following critical tunable(s) have been changed in uvconfig! If you wish to apply these changes, shut down DataStage server, run uvregen and then re...

Why are you aliasing the columns? Does it work if you remove them? The aliases, not the columns. Regardless, they need to match to the column names in the stage.

There's also this post where the same problem was resolved by re-licensing the server.

I'd start with this one.

Seems to me you must have actually changed something or things wouldn't have gone quite so... sideways. Involve support if you haven't already. You may have the issue with TERM as noted here depending on your O/S, let us know if anything there helps. http://www-01.ibm.com/support/docview.wss?uid=swg...

Heck, it just dawned on me that if you are going to use that DateFromComponents function then there's no need to worry about leading zeroes on the month and day since all function values need to be integers. All you'd need to do is add 2000 to the year if the century was missing.

D'oh.

Your original post mentions that you have "four fields" and the logic needs to check field1 against field3... and now your example has two fields. So, is field2 in your example the same as field3 in your first post? :? And are you looking for 10 distinct values regardless of actual value o...

While perhaps you could do that, the standard approach would be to remove them from the output. Once.

With it being a brand new project / etc I would have to guess you exhausted resources and in your shoes I would double-check your kernel parameter settings as a start.

I yam what I yam and that's all what I yam.

I was wondering the same thing but guessing... cat.

Your problem is not with the Field function, although to be honest I didn't look at your syntax all that closely. I'm wagering your issue is going to be the traditional one where $CommandOutput has a Field Mark (@FM) in it and you need to remove them from the output before you do your comparison bec...

Use %yy rather than %yyyy and you can't use the dashes in the format mask since they don't exist in your source string.

RCP? You can use RCP as long as all you have to do is move the data from the source to the target. If you need transformations or validations then RCP becomes an issue. However, it seems to me that you could interrogate the file and use the first record to build the appropriate schema file to pass i...

Wow, that's kind of... stupid. :? What I would attempt in your shoes would be to NOT skip the first / header record as one would normally do but instead read it as data and then squirrel away in stage variables what column holds what data this run. And then try to unravel things in the transformer f...