DSXchange

ray.wurlod

And if that works, partition on the key field. Modulus is a good choice for the partitioning algorithm, since you have an integer key.

ray.wurlod

Provide the semi-colon that is required to terminate a DataStage/SQL statement.

ray.wurlod

What IS it giving you? Are you deriving GroupID as

Code: Select all

"G" : StageVar

?

ray.wurlod

Sure.

Show us what you've tried. And explain in what way is does not produce the expected outcome.

ray.wurlod

Why not get a premium membership? It's less than 30c per day, and the revenue helps to keep DSXchange alive.

ray.wurlod

Code: Select all

DSAttachJob()
DSGetJobInfo()  ;* check status is DSJS.RUNNING
DSStopJob()     ;* issue stop request
DSDetachJob()

ray.wurlod

That will depend on your operating system. You need to identify the number of CPU cores and the speed at which they operate, the amount of RAM, the amount of swap space, the amount of free disk space, the throughput capacity of your I/O systems, the speed of your network, and any other resources tha...

ray.wurlod

LIST.READU is exactly the command that fills the locks area of Cleanup Resources.

ray.wurlod

Then you might mark this thread as Resolved.

ray.wurlod

Not enough information. What are the resource characteristics of the two machines?

ray.wurlod

Variable named Pos will contain a delimited string. You can use the Field() function to parse it, or you can use dynamic array notation. The delimiter character is a value mark (@VM). So, to get the third value, you could use Field(Pos, @VM, 3, 1) or Pos<1,3> or Pos[@VM,3,1] or Extract(Pos,1,3,0) (t...

ray.wurlod

That is easily fixed.

Meanwhile I've opened the post - not much of it was hidden.

ray.wurlod

Not enough information. What are the resource characteristics of the two machines? How many rows were processed in each case?

ray.wurlod

Of course there will be a difference. Figure out the partitioning results on paper. The records will definitely be partitioned differently. However, the join results will still be accurate provided that both inputs are partitioned and sorted (on the join keys) identically.

ray.wurlod

Are you using one of the supported web browsers?

Search found 53125 matches