Question Re: Parameters for upload_delete event in Technology Q&A

Parameters for upload_delete event

Former Member — Tue, 12 Aug 2014 12:18:29 GMT

Hi,

I wonder what the exact parameters for the upload-delete table event are? By accident I coded (generated) an upload-delete event like follows:

DECLARE lv_new lfv_del_pos%ROWTYPE; BEGIN lv_new.avisnr :={ml r.avisnr}; -- PK lv_new.aviscode :={ml r.aviscode}; -- PK lv_new.itemnr :={ml r.itemnr}; -- PK lv_new.amount :={ml r.amount}; -- NOT PK ... END; That runs without any problem (what makes me glad). The column amount isn't part of the primary key of the table neither in the consolidated nor in the remote database. But the documentation seems to say only primary key columns are allowed as parameters for this event: upload_delete table event Of course I don't need the non-pk parameter but I wonder if the doc is wrong or that behaviour may be changed in future releases?

Mayby someone can clarify because that would have impact on the code generation tool.

TIA

Chris Werner

Re: Parameters for upload_delete event

jeff_albion — Tue, 12 Aug 2014 12:44:21 GMT

What's the schema for the table that was generated?

Re: Parameters for upload_delete event

Former Member — Tue, 12 Aug 2014 13:00:57 GMT

Consolidated (Oracle):

create table lfv_del_pos ( avisnr varchar2(10) not null, aviscode varchar2(1) not null, itemnr varchar2(18) not null, amount number(4) null, ml_stat varchar2(2) not null, ml_lstmod varchar2(14) not null, constraint pk_lfv_del_pos primary key (avisnr, aviscode, itemnr) ); Remote (Ultralite): create table lfv_del_pos ( avisnr varchar(10) not null, aviscode varchar(1) not null, itemnr varchar(18) not null, amount numeric(4) null, constraint pk_lfv_del_pos primary key (avisnr, aviscode, itemnr) );

Re: Parameters for upload_delete event

Vlad — Wed, 13 Aug 2014 02:40:29 GMT

It is possible that Mobilink wants to compare old and new values before deleting the record. E.g. imagine if someone already modified the field "amount". If you want to delete it, because you have old values, you probably will not want to do this. And in theory, you have to fetch the changes again and delete the record.

E.g. the upload part is described here: http://dcx.sybase.com/index.html#1200/en/mlstart/foursteps-ml-basics.html

Re: Parameters for upload_delete event

Former Member — Wed, 13 Aug 2014 03:34:32 GMT

Thanks Vlad, you are right, the text explains the behaviour: "The upload consists of a set of new and old row values for rows modified in the remote database. (Updates have new and old row values; deletes have old values; and inserts have new values.)" and that makes sense too. Then the documentation for the upload-delete table event explains the parameters wrong: http://dcx.sybase.com/index.html#sa160/en/mlserver/upload-delete-ml-scriptsref.html*d5e19662

Re: Parameters for upload_delete event

Vlad — Thu, 14 Aug 2014 02:38:38 GMT

I will not be surprised if these parameters go through all synchronization scripts. Because the request from the device has already reached the server, and it is up to MobiLink to filter or not, parameters that came from the client 🙂

Re: Parameters for upload_delete event

Former Member — Tue, 19 Aug 2014 12:36:42 GMT

The table lists the required parameters (all PK columns) and some of the optional named parameters. Other named parameters, including non-PK columns, can also be used.

FYI, the {ml o.} syntax is only applicable to the upload_update event.

Re: Parameters for upload_delete event

former_SQLA_member1694884 — Tue, 19 Aug 2014 13:58:37 GMT

Blob column values are not uploaded for delete operations, and so should not be used.