Question

2
Replies
95
Views
Close popover
Krishna Siddanthi (KSiddanthi)
Hf Management Services LLC

Hf Management Services LLC
US
KSiddanthi Member since 2019 3 posts
Hf Management Services LLC
Posted: August 8, 2019
Last activity: August 12, 2019
Closed
Solved

Parameterizing OFFSET in MSSQL is giving error

Parameterizing OFFSET in MSSQL is giving error

User using the RDB-LIST to get the data from the external system. User is Parameterizing OFFSET value in MSSQL and he is getting the error

There was a problem getting a list: code: 10743 SQLState: S0001 Message: The number of rows provided for a OFFSET clause must be an integer.

Exact Syntax in the SQL:

OFFSET {diagTempPage.loop} ROWS

FETCH NEXT 1000 ROWS ONLY

The loop property is an integer property on the diagTempPage.

***Edited by Moderator: Lochan to tag SR***

Data Integration Support Case Exists
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.