SQLRPGLE Insert Statement not working

Question

I have a simple insert statement I want to execute using sqlrpgle. I build the statement first depending on what variables are empty and then want to use exec sql to do the insert. This does not work.

But entering the same insert statement with subquery in STRSQL works fine.

I have broken down the sql statement to its simplest version for this question.

Here is the SQLRPGLE code snippet

And here is where I enter the same statement in STRSQL

Any Assistance would be greatly appreciated.

**EDIT

This only happens when I add a where clause, which is essentially what I need and why I am trying to do it using sqlrpgle. Statements like

sqlstmt = 'insert into jallib/sbrmrpt (shscdt, shcmdt) ' + 
          'select shscdt, shcmdt ' +
          'from r50files/sbschd ';

and

sqlstmt = 'insert into jallib/sbrmrpt (shscdt, shcmdt) ' + 
          'values (10, 10) ';

All work just fine, once a where clause is added to the subquery is where it does not work in the RPG code but in STRSQL

Player1st · Accepted Answer · 2018-07-26 15:54:24Z

7

You have sqlstmt defined as 100 characters maximum and with the where clause your string is over 100 characters long. Your SQL statement is getting truncated and that's why its not working. I suspect you know how to fix this but just for completeness, the solution is the following:

D sqlstmt          s            500a   varying

answered Jul 26, 2018 at 15:54

Player1st

1,60511 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Player1st Over a year ago

Lol. No problem. It just makes me feel a little better that I only made this mistake in front of a coworker and not on StackOverflow. ;)

jmarkmurphy Over a year ago

debug is your friend!

Collectives™ on Stack Overflow

SQLRPGLE Insert Statement not working

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related