VL SP2 Identity Column

This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
jyoung
Posts: 640
Joined: Thu Jan 21, 2016 6:43 am
Location: Oklahoma City, OK USA

VL SP2 Identity Column

Post by jyoung » Fri May 18, 2018 12:29 am

Not really a question or an answer and I don't know when this showed up, I assume in SP2.
Capture.PNG
Capture.PNG (7.84 KiB) Viewed 1812 times
Capture2.PNG
Capture2.PNG (4.19 KiB) Viewed 1812 times
No more System Variables for Identifiers!

This makes me happier than it probably should. Lol. :D

-Joe

bark
Posts: 24
Joined: Thu Jan 05, 2017 9:56 am

Re: VL SP2 Identity Column

Post by bark » Mon May 21, 2018 2:41 pm

Hi Joe
You assume correctly. I found this in the SP2 readme
SP2_identity column.JPG
SP2_identity column.JPG (72.56 KiB) Viewed 1783 times

atostaine
Posts: 388
Joined: Wed Jan 20, 2016 7:38 am

Re: VL SP2 Identity Column

Post by atostaine » Wed May 23, 2018 11:08 pm

Can the returned RRN not equal the actual RRN? I think it's possible to increment the next value outside of an insert.

ALTER TABLE ORDER
ALTER COLUMN ORDERNO
RESTART WITH 5
Art Tostaine

User avatar
Stewart Marshall
Posts: 417
Joined: Thu Nov 05, 2015 5:25 pm

Re: VL SP2 Identity Column

Post by Stewart Marshall » Thu May 24, 2018 8:41 pm

jyoung wrote:
Fri May 18, 2018 12:29 am
No more System Variables for Identifiers!

This makes me happier than it probably should. Lol. :D

-Joe
Me too.

Oddly though, after 25+ years incrementing a number by one, I recently encountered the idea that all identifiers should probably be 10 digit Base64 randomised values, giving 1,152,921,504,606,846,976 possible values.
Stewart Marshall

Independent IT Consultant
www.marshallfloyd.com.au

atostaine
Posts: 388
Joined: Wed Jan 20, 2016 7:38 am

Re: VL SP2 Identity Column

Post by atostaine » Wed Jun 27, 2018 4:09 am

I just submitted an incident. We are seeing the identity column check disappearing when checking out a file for update.

Art
Art Tostaine

Post Reply