Question

2
Replies
91
Views
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 SR Exists
Moderation Team has archived post
Share this page LinkedIn