Surrogate key - stat file

Suma Reddy · Post by **Suma Reddy** » Wed Nov 16, 2011 4:37 am

How to read stat file (FileName.sk) which is generated in surrogate key stage?

suse_dk · Post by **suse_dk** » Wed Nov 16, 2011 5:37 am

Use the Surrogate key generator to read the state file. Set the option "View state file" = yes

ray.wurlod · Post by **ray.wurlod** » Wed Nov 16, 2011 3:10 pm

Or use NextSurrogateKey() function if you actually want a surrogate key value.

Suma Reddy · Post by **Suma Reddy** » Thu Nov 17, 2011 3:21 am

Thanks Susanne.

Stat file contains below data
1 2
4 4

This content is based on block size.
How to find out Next surrogate key value from this stat file contents

ray.wurlod · Post by **ray.wurlod** » Thu Nov 17, 2011 2:38 pm

So, to clarify, you want to know the next (or, perhaps, current) value without actually incrementing the state file?
This will, of course, be different on different nodes.