Offset to error into the string of SQL when creating procedures and function

[NielsLiisberg]

This is a cross-issue between VSCode - code for i and the Db2 for i extensions and mapepire.

When creating procedures and functions in VScode, and a syntax or semantic error is typed in, it would be appreciated if the cursor could be positioned on the code line and column where the error exists.

The enhancement to mapepire is described here
Mapepire-IBMi/mapepire-server#91

mapepire will then return the offset into the statement entered when an error object is returned, that maps to the position

The feature might also be useful when entering any other complex SQL statements ( that fails)

ACS SQL already has this feature (to some extent)

[worksofliam]

@NielsLiisberg what would you know, we are working on a syntax checker PR right now. I will attach the PR to this issue.

[NielsLiisberg]

Nice !! Syntax checker is nice - now - what about semantics and compile errors? Try this in ACS and notice the red colour on the commit - that is not allowed in an atomic function: create or *replace* function a () returns *int* begin atomic commit; return *0*; end; [image: image.png] This is what my idea is about.

…

On Fri, Dec 20, 2024 at 3:02 PM LJ ***@***.***> wrote: @NielsLiisberg <https://github.com/NielsLiisberg> what would you know, we are working on a syntax checker PR right now. I will attach the PR to this issue. — Reply to this email directly, view it on GitHub <#309 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAVIPHWU22YBOJWGZKORTQD2GQPPFAVCNFSM6AAAAABT673Z5KVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDKNJXGA3TIOBRGM> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[worksofliam]

@NielsLiisberg I tried out your snippet and this is what it gave me:

Feel free to paste me an entire script to try as well.

[NielsLiisberg]

This sounds promising !! I don't know if i can produce that many errors :) You are doing a great job !!

…

On Fri, Dec 20, 2024 at 7:37 PM LJ ***@***.***> wrote: @NielsLiisberg <https://github.com/NielsLiisberg> I tried out your snippet and this is what it gave me: image.png (view on web) <https://github.com/user-attachments/assets/5f5b1e79-87c7-4db1-9502-baf112e11613> Feel free to paste me an entire script to try as well. — Reply to this email directly, view it on GitHub <#309 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAVIPHSRN7FSIIV7AQZMCHL2GRPXPAVCNFSM6AAAAABT673Z5KVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDKNJXGUZDSMJSGE> . You are receiving this because you were mentioned.Message ID: ***@***.***>