DSXchange

ray.wurlod

If you're going back from 00:00:00, then you need to subtract one day from the date.

Oconv(Iconv(Left(InLink.Timestamp,10),"DYMD")-1,"D-YMD[4,2,2]")

ray.wurlod

Or set ErrorCode to a non-zero value in a before-job subroutine that checks the exit status of the previous job.

Or set it up with appropriate triggers in a job sequence (preferred).

ray.wurlod

"They" had to do a lot of fiddling to support the Euro symbol. Especially since Micro$oft decided to use the character for Euro that "they" used for null. If you remember that "they" are based in Boston, where the Tea Party is still remembered, this may explain why there is no explicit support for t...

ray.wurlod

Execute the following command from Administrator client command window. DOS /C "dir hashedfilepath" This will show the physical size of the DATA.30 and OVER.30 components of the dynamic hashed file. What you are planning to do with this information I have no idea - perhaps setting up an al...

ray.wurlod

In Director go to the Options selection on the Tools menu. That's where you can set the default limits. Don't know whether this affects dsjob (let us know, please). You can always override on the dsjob command line.

Code: Select all

dsjob -run -warn 0 project jobname

ray.wurlod

... or a Routine. Algorithm is fairly straightforward.

Code: Select all

Select all jobs
Foreach job
   Select all instances
   Foreach instance
      Determine job status
      If needs resetting
         Then run in reset mode with previous parameter settings
      Endif
   End foreach
End foreach

ray.wurlod

It's probably true that I read the manuals and readme files more thoroughly than most; that's because I have to be prepared to teach this stuff, and answer questions (or at least know where to look). Being able to quote page numbers impresses folk, too.

ray.wurlod

The Parallel Job Developer's Guide needs a lot of work before it attains the status of a completely useful manual. Get yourself a copy of the Orchestrate manuals if you really want to know what's going on.

ray.wurlod

Last time I looked there were some 14 different encodings of Japanese used in industry, that's before you count shift-in/shift-out for switching encodings mid-stream.

The only answer I can give you, therefore, is "the right one". Most times the customer has no idea how their data are encoded.

ray.wurlod

If you execute Job1 from a stage variable in Xfm1, then you can use the return value (its exit status) to constrain the output from Xfm1 so that Xfm2 is only triggered if the value is 1 (finished OK) for example. It's a cumbersome method, though, one that would be so much easier using a job sequence...

ray.wurlod

Hash, or "hash sign" or "hash mark".

Nothing whatsoever to do with hashed files. Or hash. Either kind. Saves confusion with the name of the currency.

ray.wurlod

You can set the NLS maps and locales in job properties to override the project default that was set in the Administrator client. I believe that they can be job parameter references (at least the map names).

ray.wurlod

How about you try it and let US know? Lance is probably asleep as I post.

ray.wurlod

This isn't much help - there aren't any.

There is a class called DataStage Best Practices, but I don't think it ever came out in a PX version. PX best practices are different from server best practices, for a whole lot of reasons.

ray.wurlod

You could always extract them using bitwise AND function BitAnd (see page B-4 of Parallel Job Developer's Guide for details)

Search found 53125 matches