Insert Statement

[Former Member]

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

[Former Member]

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

[Former Member]

no need

[Former Member]

hi

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

[former_member182354]

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