INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SPUFI: LOCATE ERROR LINE

SPUFI: LOCATE ERROR LINE

(OP)
I got sick and tired of looking for this SPUFI error so I did some QW lookups and some experimenting and determined that the 5th felid of the DSNT416I message is the relative offset of the 1st character of the error counting only 72 columns per line in TSO.
DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD AND. TOKEN + - A
ORDER WAS EXPECTED
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 506 0 0 -1 1668 0 SQL DIAGNOSTIC INFORMATION

The offset is from the start of the statement in error, i.e. since the last semi-colon if any.

My error was at 1668 and 1668 / 72 is 23 plus 12.
000001 SET SCHEMA = 'GDBA';
000002 SET SCHEMA = 'GDB2';
000003 SELECT PERSONAL_ID ID

000024 AND SE.EXCPT_TRIP_NBR = 2
000025 AND EXCPT_RLSE_LOC = EV.EMPL_IN_SIGNOFF_LOC)
000026 AND EXCPT_DUTY_CD NOT IN ('SBH','SBK','SBN','SBP')

So the ”AND” in error is on line (3 + 23) plus 12 characters and looking back I see that the parentheses after EV.EMPL_IN_SIGNOFF_LOC is the error.

RE: SPUFI: LOCATE ERROR LINE

Thanks for the infosmile

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close