1 of 7

Headers

This page describes how to use HEADER functions in Lenses SQL Processors.

HEADERASSTRING

This page describes the HEADERASSTRING function in Lenses SQL.

Returns the value of the record header key as a STRING value.

Available in:

Processors

SQL Studio

This page describes the HEADERASINT function in Lenses SQL.

Returns the value of the record header key as an INT value.

Available in:

Processors

SQL Studio

This page describes the HEADERASLONG function in Lenses SQL.

HEADERASLONG(keyStr)

Returns the value of the record header key as a LONG value.

Available in:

Processors

SQL Studio

This page describes the HEADERASDOUBLE function in Lenses SQL.

HEADERASDOUBLE(keyStr)

Returns the value of the record header key as a DOUBLE value.

Available in:

Processors

SQL Studio

This page describes the HEADERASFLOAT function in Lenses SQL.

HEADERASFLOAT(keyStr)

Returns the value of the record header key as a FLOAT value.

Available in:

Processors

SQL Studio

This page describes the HEADERKEYS function in Lenses SQL.

HEADERKEYS()

Returns all the header keys for the current record.

Available in:

Processors

SQL Studio