DSXchange

It must be correctly cased on Windows, too.

The value here is the key to UV.ACCOUNT, which is accessed to determine the pathname of the project directory.

bdixon's most recent post still doesn't specify the desired output. However, the data example given earlier suggests that these files are not good candidates for the Merge stage, since there is no apparent key column on which to specify the join. Can we see the exact output requirement, before leapi...

If you want the milliseconds from the system clock, use SYSTEM(12). OCONV(DATE(), "D-YMD[4,2,2]") : " " : OCONV(TIME(), "MTS:[2,2,2]") : "." : FIELD(SYSTEM(12), ".", 2, 1)

It was always my understanding that materialized views are best automatically maintained by the database. Certainly this is the case with Red Brick (in which they are called precomputed views). Otherwise what's the point of calling it "materialized"? If it's out of date then it's no better than a st...

Step 1. Create a working DataStage job. stage ---> stages ---> stage (The intermediate stages can include QualityStage plug-in if needed.) Step 2. Add RTI Input and RTI Output stages to replace the passive stages. RTI Input ---> stages ---> RTI Output Step 3. If the Web service is going to exchange ...

You DO have to tell it the value with which you want to replace the current value, and you DO have to tell it the position at which to replace. You're correct that Ereplace and Change functions are probably not appropriate. Ken's answer is entirely correct. Instead of the hard-coded "Z" value, you n...

I note that you are on version 5.x and am not sure that the Merge stage is available. Note, also, that there is a server Merge stage and a parallel Merge stage, which are completely different from each other. The server Merge stage has no input links. You provide the pathnames of two source files as...

The best response to your client is the honest one, that "best practice" varies with the application. If you're using DataStage to maintain a data warehouse, then best practice is different than if you're using DataStage to expose web services for name and address verification, and different again i...

You can always make multiple passes (this is what the Pass column in the report indicates). Each pass can refine the criteria of the earlier one. I don't believe that the exact algorithms are published. The numbers are generated for each field, and represent the "information content". So, if a match...

Search for the log, note where it is, and set that location as the value. Filtering your search by date modified will reduce its duration.

It's the Oconv that's stripping zeroes.

To retain them, wrap in a Fmt function.

You can specify how null is represented as a stage property. However the OP's question was clearly about delimited records, so we're straying a little off topic. Lance's response could be read as suggesting that setting the environment variable also has an impact on delimited data, since that's what...

Let me chime in with the same answer. You just can't do conversions or casting in an environment where there are no data types! You can check that it's numeric (with the Num() function), you can determine that it's an integer (with pattern matching, for example), there are lots of other choices for ...

The Load button on the Format tab is a too-frequently used capability that can load the Format of the sequential file (as opposed to its column defintiions) as imported into the Repository. PhilHibbs has bemoaned the fact that we're forced to do them separately; and suggested - without posting an en...

Clarification: That environment variable has the name APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL (whew!) and applies only to the Import and Export operators in the framework.