DSXchange

UniVerse - and therefore DataStage server jobs - use a base date (day 0) of 1967-12-31. ... Are you sure? When you create a date column with a Column Generator in PX (remember you are at the EE forum) and you don't specify any date, by default Datastage gives you 1960-01-01. But that doesn't corres...

I found the answer I was looking for.

Thank you all

You suppose? You need to find out what those dates translate to before anyone takes more time to guess at the proper solution to automate that. ... Who do you think you are??? A forum is made to provide help, not to provide a way to try to shame people. I'm trying to figure out how a Datastage fonc...

Because the "Julian Date" is not standardized and you posted "55398" as a Julian date but haven't specified what date that is supposed to represent. DataStage PX uses the definition [quote="Parallel ... I supposed Julian Date came from a Calendar for which 0 (or 1, never su...

What are you supposed to get from these inputs? On what base date are your allegedly Julian dates based? On what base date is the Julian day used by DataStage based (it's in the manual)? I suspect ... I can't read whole your post, but I don't get your point. Why is it important to know where the da...

Can you try it in a transformer to get it working. Modify stage uses almost similar arguments but reverse function name. ... In a transformer, putting in the derivation: DateFromJulianDay(L_In.Infield) I get this warning: "Conversion error calling conversion routine date_from_julian_day data m...

We opened a case at IBM and they provided us a patch.

Seems to work fine, now.

ray.wurlod wrote:Is Key_Col one of the join keys? Are the data partitioned on both inputs using a key-based partitioning algorithm that names the join keys? Sorted? ...

Sorry for this late reply.

Yes, both links are hash/sort by the Key_Col

Hi, I'm trying to convert a uint32 field into a date using a Modify Stage and the fonction date_from_julian_day, but I have no chance: All of my records get a NULL at the output field. I use : Outfield=date_from_julian_day(Infield) At the Infield I have this as data: 55398 55399 55400 55401 55402 .....

ray.wurlod wrote:There is a theoretically infinite number of environment variable names, all of which *could* be added to DSParams. ...

And no one ever tried to list them, somewhere? Even if they're not all in the same document, but at least as we could find them.

define "all the environment variables". Is it default variables present in DSParams/ special environment variables suggested by IBM to define as user defined variables for some cases/ user defined variables for your own use? :? What I'm looking for is what you call special environment var...

mf_arts wrote:It would be a good start to take a look to Parallel Job Advanced Developer Guide manual.

This manual is great but not complete.

Hello,

can anyone tell me where can I find all the environment variables we can add to DSParams?

Thanks

agpt wrote:Did you try incorporating Null handling for Key_Col?

It's a not null column in DS2.

ray.wurlod wrote:What partitioning are you using on the inputs of the Join stage? ...

At the beginning we had the "Same" partitionning, but as I sad before, we tried everything even passing the Join Stage in Sequential with both sides sorted.