TDM Query Does not Recognize the command "TOP 100" in Select Statement

book

Article ID: 185952

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

The extract file generated by TDM isn't incorrect. The query not recognize the command "TOP 100".

The query in extract file needs to contain all the clauses for use during extract process.

 

Cause

TOP not supported in query.

Environment

Release : 4.8

Component : CA Test Data Manager - Subset

Resolution

We do not support TOP keyword. We only support subsetting based on where condition.

However, you can specify a value for number of rows. This might be helpful to you, see example below: