Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to make DELETE statement type auto retrieve primary key like "UPDATE" of PutDatabaseRecord

avatar
New Contributor

I am using to ingest json data using PutDatabaseRecord with JsonTreeReader. The statement type is "DELETE"

{
"BATCH_INFO_ID": 1514,
"REF_NO": "REF-001-M",
"BATCH_TYPE": "Fax",
"BATCH_DATE": "2011-07-14T00:00:00Z",
"RESULT_IND": "T",
}

However, I got below query finally:

Batch entry 0 DELETE FROM "IOSH"."CMI_BATCH_INFO" WHERE ("BATCH_INFO_ID" = 1514) AND ("REF_NO" = 'REF-001-M' OR ("REF_NO" is null AND 'REF-001-M' is null)) AND ("BATCH_TYPE" = 'Fax' OR ("BATCH_TYPE" is null AND 'Fax' is null)) ....

 

How to make it like "UPDATE" behavior to get primary key in where clause instead of put all fields in side where clause?

 

0 REPLIES 0