Re: JDBCR4 program with a null field in the WHERE statement

You are going to need
prepstm = JDBC_prepStmt(conn : 'SELECT * ' +
'FROM dbo.Error_File ' +
' WHERE (dbo.Error_File.Process_flag is NULL or
dbo.Error_File.Process_flag
= ?)' );

You cannot use comparison operators (=, <, >, <>) with NULL.

HTH,
Charles

Charles


On Wed, Jun 26, 2013 at 4:20 PM, Kim Massar <kmassar@xxxxxxxxx> wrote:

I am using Scott's JDBCR programs to get data from our SQL server into an
RPG program. I have used this successfully before now I have a problem
with a null field in my WHERE statement. Is it possible to compare for
nulls? Is it possible to check for nulls in my process_flag field below?
I have tried '*Null' and 'is_null'



prepstm = JDBC_prepStmt(conn : 'SELECT * ' +
'FROM dbo.Error_File ' +
' WHERE (dbo.Error_File.Process_flag = ?)' );


If (prepstm = *NULL);
jdbc_close(conn);
return;
EndIf;

// Set SQL parameter values
JDBC_SetString(prepstm:1:'*NULL');




Email Confidentiality Notice: The information contained in this
transmission is confidential, proprietary or privileged and may be subject
to protection under the law, including the Health Insurance Portability and
Accountability Act (HIPAA). The message is intended for the sole use of the
individual or entity to whom it is addressed. If you are not the intended
recipient, you are hereby notified that any use, distribution, copying or
printing of this message is strictly prohibited and may subject you to
criminal or civil penalties. If you received this transmission in error,
please contact the sender immediately by replying to this email and then
delete the material from any computer.
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.