TBDELETE—delete a row from a table

The TBDELETE service deletes a row from a table.

For tables with keys, the table is searched for the row to be deleted. The current contents of the key variables, dialog variables that correspond to keys in the table, are used as the search argument. If the table has no keys, the row is determined by the current position of the CRP.

For tables without keys, the row pointed to by the current row pointer (CRP) is deleted.

The CRP is always updated to point to the row before the one that was deleted.

Command invocation format


>>-ISPEXEC--TBDELETE--table-name-------------------------------><

Call invocation format


>>-CALL--ISPEXEC--(buf-len,--buffer);--------------------------><


>>-CALL--ISPLINK--('TBDELETE'--,--table-name);-----------------><

Parameters

table-name: Specifies the name of the table from which the row is to be deleted.
buf-len: Specifies a fullword fixed binary integer containing the length of "buffer".
buffer: Specifies a buffer containing the name of the service and its parameters in the same form as they would appear in an ISPEXEC call for a command procedure.

Return codes

These return codes are possible:

0: Normal completion.
8: Keyed tables: The row specified by the value in key variables does not exist; CRP set to TOP (zero). Non-keyed tables: CRP was at TOP (zero) and remains at TOP.
12: Table is not open.
20: Severe error.

Example

Delete a row of the table TELBOOK.

ISPEXEC TBDELETE TELBOOK

Set the program variable BUFFER to contain:

TBDELETE TELBOOK

Set program variable BUFLEN to the length of the variable BUFFER. Issue the command:

CALL ISPEXEC (BUFLEN, BUFFER);

or alternately

CALL ISPLINK ('TBDELETE','TELBOOK ');