RE: insert a null into a date/time field on SQL Server

Thanks Scott,
I think that's exactly what I need.

Mike

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Wednesday, September 11, 2013 3:40 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: insert a null into a date/time field on SQL Server

There should be a fourth (optional) parameter to JDBC_setDate() that can be used to set the value to null.

For example:

JDBC_setDate(stmt: 3: SurveyDate: *ON);

-SK

On 9/11/2013 2:06 PM, Smith, Mike wrote:

I've always populated a date/time field with a "DEFAULT" date when I don't have a date value to populate.

However, I would like to get away from this if possible.

This is what I'm doing currently

test(de) *ISO SFDATE;

if not %error ;
SurveyDate = %date(SFDATE : *ISO);
Else ;
SurveyDate = defaultdate ;
EndIf;

stmt = JDBC_PrepStmt(conn : 'Insert Into ELECTRICSURVEY'
+ '(OBJECTID,'
+ ' SERVICENUMBER,'
+ ' SURVEYDATE,'
+ ' CREATIONUSER,'
+ ' VOLTAGE,'
+ ' COMMENTS)'
+ ' values (?,?,?,?,?,?)');

JDBC_setInt (stmt: 1: ID);
JDBC_setString (stmt: 2: SFEID);

JDBC_setDate (stmt: 3: SurveyDate);

JDBC_setString (stmt: 4: INSPECT);
JDBC_setDecimal (stmt: 5: VGREAD);
JDBC_setString (stmt: 6: DESCRIPT);
rc = JDBC_ExecPrepUpd( stmt );


SO if SFDATE is 0 in my file, can I set SURVEYDATE to null and if so how?

I've played around with this, but haven't had any success.

Thanks

Mike
NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.

--
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.


NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.