DSXchange

D'oh! You're right, horked that one up. Use another stage variable to control the increments of the first. The order is important as they resolve from top to bottom. svGroupKeyCheck: Initial Value 0 If svGroupKeyCheck = 6 Then 1 Else svGroupKeyCheck + 1 svGroupKey: Initial Value 0 If svGroupKeyCheck...

Rather than mark Ray's response as 'not very helpful' you would do well to heed it. There are many conversations here on the topic - I did a search for 'certification' and got 146 hits. Why not try the same?

In case you are in unfamiliar ground here, the directory/file Ray pointed you to is in your job's Project directory.

Best answer would have been to use Job Parameters for this information making the whole point moot. However, still shouldn't be all that hard - use your favorite text editor and search/replace old to new values in the .dsx before you import it.

Set the Initial Value of your stage variable to 0 when you define it. The deviation of 'svGroupKey' could be simply: If svGroupKey = 7 Then 1 Else svGroupKey + 1 Or if a job parameter controls the group size: If svGroupKey = (#GROUP_SIZE# + 1) Then 1 Else svGroupKey + 1 The 'group size + 1' ...

How will you know they were put there 'yesterday'? How would you check this without DataStage? Also think about what happens if you miss a day. Always just checking for the previous day is dangerous, you may need to consider keeping a timestamp and checking for new files since the last time you chec...

There's the hard way and the easy way. For hard, search the forums for BCI and be prepared to suffer. For easy, leverage whatever command line interface your database provides - for example, sqlplus for Oracle. Hashed files really have no place in a Parallel job. I'd be more inclined to answer that ...

Then you should mark the post as Resolved. And in case it isn't obvious PROJDEF is short for Project Default and is explained in the manuals.

Another thought - build yourself a key / grouping column. A simple stage variable, maybe two, to control the numbering starting from one and only incrementing every six records. If you know you might have more columns coming in the future, is there some way to programmatically know when the incremen...

Ray?

Could be. Did you ensure your kernel settings were at least at the minimum values noted in the Installation and Configuration Guide for your operating system?

You'll need to create your own "interlude" to the DSSetUserStatus function. It's been discussed a number of times, for example here:

http://www.dsxchange.com/viewtopic.php?t=105450

I've used both 7.5.1A and 7.5.2 without any occurance of this 'bug'... any idea on the specifics of what triggers it?

It's not Oracle. Crazy thought, but try reading the documentation for the stage. It is documented in the Parallel Job Developer's Guide, which lists all "Supported Boolean Expressions and Operators" for it.

Good to know, then... never mind.

I have tried by giving -Xmx1000 in my job properties. These things are usually case-sensitive and Ernie noted you should use -xmx not -Xmx. Unless that's just a typo in your post, try again with all lower-case and see if the error changes. ps. Ernie - that property is there in the WSClient as well,...