DSXchange

Ah, yes... EVAL was the decode like thing I was trying to think of.

That's not "DataStage internal format". What happens if you simply change the data type of that column in the job, with no "casting"? Try Varchar or Timestamp rather than Date. Experiment.

First off, the format is not "YYYY-MM-DD:HH:MM:SS" as there are no separators in your data. Second, you'd need to spell out your requirements in words, one example is not enough to go on. What is the business rule that needs to be enforced when the seconds are > 60?

Is this an actual TX job as per the forum we're in, or a Parallel job as marked? If the latter, then you need to mark this one Resolved and repost it in the Enterprise Edition / Parallel forum.

So... is that like a silent "thank you"? A nod in their general direction? :? Ah... putting "Thanks for the link" in your reply subject only shows up when someone else bothers to reply, not during a view of the topic thread. Next time, put things like that in the body of your rep...

Let us know what you find out!

Just keep in mind the fact that if you remove all whitespace, it will match "A BC" with "AB C"... only you know if that is fine or not.

Can you not use the Stored Procedure stage? I could have sworn it supports DB2 but can't check right now.

So... you can find an entry for this in the user's crontab but it doesn't show in the Director logged in as that user? Sounds bug like, best to contact your official support provider I would think.

Or use two tables. Do you not have a modeler where you work? I mean, someone who's official job it is to design the tables projects need there?

What the heck are N1 and N2? Can you not simply pass the value StageName.$Counter into the number parameter?

Hmmm... I do not believe so. I think you could use a "decode" to do something similar, a search of the forum should turn something up. Or you could wait for someone who actually knows the answer to respond.

If, I use a sequential file stage with filter command to do a directory listing..What value should be there for File Name Property.. The stage will combine the two fields automatically, first the filter command followed by the filename, so you could put the full path to the directory in the filenam...

Meaning, you want to build a "generic" PX job with RCP that has no columns defined in it and still do transformations on the data? No can do.

Spaces are just another character and will match just fine. Post your exact derivations so we can see where you are going wrong. Question: is it considered a match if one is "Air.Conditioner" with one space between words and the other is "Air..Conditioner" with two spaces? Or if ...