search cancel

Portal and SEQLOV

book

Article ID: 189508

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Portal : 4.9.0.12

Can you take a look at this : https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?MessageKey=31239341-51e8-42bd-8d5f-0f91e703aa6f&CommunityKey=909e0526-d8ad-455d-97eb-aa009df5d3aa&tab=digestviewer#bm31239341-51e8-42bd-8d5f-0f91e703aa6f


I'm doing data generation by the TDM GENERATOR. I have a question about the SEQLOV function.


@SEQLOV(PERCNULL, @SQLLIST(CONNECTION, SQL[,S])@)@


According to the documentation, the SEQLOV(PERCNULL, @SQLLIST(CONNECTION, SQL[,S])@) function can shuffle the data when the optional parameter S is specified.


"S - (optional) If the literal argument S is specified then the rows returned by the query are randomly shuffled before returning the first item. Subsequent calls do not re-shuffle."


In my synthetic data generation tests, it seems that shuffle is done at all times and not just the first time.

Environment

Release : 4.9

Component : CA Test Data Manager

Resolution

Please download TDMWeb-4.9.31.0.zip, install, test, and verify that this resolves the reported issue.  In order to get this version or later, please open a case with Broadcom Support and request the version.