Support Questions

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

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

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",

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?