search cancel

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.

 

Environment

Test Data Manager
TDM
Subset

Cause

TOP not supported in query.

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.