topic Re: Insert Statement in Application Development and Automation Discussions

Insert Statement

Former Member — Fri, 16 May 2008 09:56:33 GMT

Hi,

I have written one program which reads records from input file and those records are inserted in Z table with 'INSERT' statement.

Please let me know whether there is a need to call enqueue and dequeue function modules ?

Regards,

Netra

Re: Insert Statement

Former Member — Fri, 16 May 2008 10:04:32 GMT

well you need to know that

its a Z-Table, so only you guys who created this Z-Table can know when it will be used.

but well if you enqueue the table before inserting you dont do anything wrong.

just make sure to dequeue it afterwards

Re: Insert Statement

Former Member — Fri, 16 May 2008 12:19:22 GMT

no need

Re: Insert Statement

Former Member — Fri, 16 May 2008 12:23:40 GMT

no need to enqueue or dequeue.

coz you are not fetching records from the table ..records are in your file..and you are goin to insert those recods into the table which dont exist in table b4.

so you can not lock or unlock the records which are not in table..

thnks

Re: Insert Statement

former_member182354 — Fri, 16 May 2008 12:30:18 GMT

Yes it is always a best practice to Enqueue and Dequeue any table befor you update ...Even a ZTABLE as you will not be the only one using that table.

Create a Lock Object and create the Enqueue and Dequeue Function module for this purpose..

Raghav