Hello,
Trying to write my first embedded SQLRPGLE in AS/400 & getting a compile error. It's a very simple query I'm trying to run so there's no issues.
In PDM/SEU I have;
Now, I'm not sure why I need the into statement, but the compiler throws an error if it's missing (I only want to read the data) With it inserted I get
Can anyone shed light where I'm going wrong? I couldn't reply to my original thread for some reason.
Thanks
Trying to write my first embedded SQLRPGLE in AS/400 & getting a compile error. It's a very simple query I'm trying to run so there's no issues.
Code:
SQL: Select * From warefil_ml/warsthd Where CLNTST = 'FD'
*************** Beginning of data *************************************
0022.00 C/EXEC SQL
0023.00 C+ SELECT *
0023.01 C+ INTO :SQLtmp5
0023.02 C+ FROM WARefil_ML/WARSTHD
0024.00 c+ WHERE CLNTST = FD
0025.00 c/end-exec
****************** End of data ****************************************
0022.00 C/EXEC SQL
0023.00 C+ SELECT *
0023.01 C+ INTO :SQLtmp5
0023.02 C+ FROM WARefil_ML/WARSTHD
0024.00 c+ WHERE CLNTST = FD
0025.00 c/end-exec
****************** End of data ****************************************
Code:
SQL0312 30 3 Position 15 Variable WARSTHD not defined or not usable.
Thanks
Comment