DSXchange

ray.wurlod

Same doesn't help. What's it the same AS ? That is, what is the upstream partitioning algorithm that's being used?

ray.wurlod

All downloads are from IBM's Passport Advantage site.

ray.wurlod

In that case dsenv should have been executed. Look in the second event in the job log (environment variables) and confirm that all the search list environment variables are correctly set. If not, fix dsenv. If they are, check the execution permissions for the library. Also check that the required ge...

ray.wurlod

Welcome aboard. You probably have a UNIX version of the software, which can't be installed on Windows. DSXchange is not a mobile telephone; there is no reason to use SMS-style abbreviations. They only make life difficult for those whose first language is not English. Please add the words "you&q...

ray.wurlod

Turn off tracing.

ray.wurlod

That wasn't explicit in your specification.

Code: Select all

svLeftOfDecimal <--  Field(InLink.Col, ".", 1, 1)
svNegative  <--  (Left(svLeftOfDecimal, 1) = "-")
svNumber  <--  Right(svLeftOfDecimal, 7)
svResult  <--  If svNegative Then "-" : svNumber Else svNumber

ray.wurlod

Does anyone know whether there's any script/command line interface that can be used to import metadata (particularly from reports) into IA, and which therefore can be scheduled to run periodically?

ray.wurlod

Does what you're doing work? The only improvement I could suggest would be to use stage variables for clarity and to avoid multiple calculations of the same function. Maybe use Left() function to test for the sign, if the input column data type is string.

ray.wurlod

Never encountered it, but can you source the dsenv script in the script that cron runs?

ray.wurlod

Can you read the data successfully if you change the data type to VarChar - possibly with maximum length set up to four times the NVarChar column length specification?

ray.wurlod

You can certainly tune memory in the Sort stage, up or down, but if the system is already swapping heavily I'd be more inclined to figure out what's causing that. Is it genuine swap (to system swap space) or is it usage of the scratchdisk resources mentioned in your configuration file? If the latter...

ray.wurlod

The limit in DataStage is 255 characters. However, the limit in Information Server may be smaller depending on what database type you're using - it's the limit imposed by that database on identifier names. Might be as small as 30 characters.

ray.wurlod

Try to do it yourself, on paper/whiteboard. Partitioning keeps all the equi-valued keys on the same partition as each other. It is usually sufficient to partition on the first join key because necessarily secondary join keys must be in that group. The Join stage does require - for efficiency of oper...

ray.wurlod

Pivot stage will do this.

ray.wurlod

You DO need another Else clause at the end.

If..Then..Else is an expression, and must produce a value whether or not the test expression is true.

DSXchange

Search found 53125 matches

Scheduling import of metadata