9 90 FETCH_IN_SPACE

LANSA Technical

9.90 FETCH_IN_SPACE

Þ Note: Built-In Function Rules.

Fetches the first cell row that matches the key values supplied and returns the cell values into the specified fields.

For use with

LANSA for i

YES

Only available for RDMLX.

Visual LANSA for Windows

YES

 

Visual LANSA for Linux

YES

 

 

 

Arguments

No

Type

Req/ Opt

Description

Min Len

Max Len

Min Dec

Max Dec

1

A

R

Space Name

1

256

 

 

2-20

w

O

Fields that specify the key values to be used to locate the first cell row required. 

1

Unlimited

0

Unlimited

 

 

Return Values

No

Type

Req/ Opt

Description

Min Len

Max Len

Min Dec

Max Dec

1

A

O

Standard Return Code

"OK" = A cell row was found and the cell values have been returned.

"NR" = No cell row could be found with a key matching the key values supplied.

"ER" = Select attempt failed. Messages issued will indicate more about the cause of the failure.  

2

2

 

 

2-20

w

O

Fields to receive the values of the cells in the selected cell row. 

1

Unlimited

0

Unlimited

 

 

Technical Notes

The return fields must be specified in the same order as the cells in the space were defined. Cells are matched by the order of their specification in return values 2 -> 20. The names of the fields used have no bearing whatsoever on the cell mapping logic. 

You can specify less key values than are defined in the space. The first matching cell row will be returned.

If you specify more key values than are defined as key cells for the space then the additional values will be ignored and have no effect on the outcome of the search.

If you specify less return field values than there are cells in the space then the non-specified cells are not mapped back into the fields.

If you specify more return field values than there are cells in the space then the additional field values are ignored and are not changed by the search operation.

If a key value longer than 256 bytes is specified, a fatal error will occur.