SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

C-63

Example—COMPUTE_TIMESTAMP

This SQLCI command sets the parameter ?D to the Julian timestamp for the date and

time in parentheses:

SET PARAM ?D COMPUTE_TIMESTAMP (2/8/93 13:25:00:00:00);

CONCAT Clause

CONCAT is an SQLCI report writer clause that specifies print items to display without

intervening or trailing spaces.

CONCAT works in the BREAK FOOTING, BREAK TITLE, DETAIL, PAGE FOOTING,

PAGE TITLE, REPORT FOOTING, and REPORT TITLE report writer commands.

print-item

is an item to concatenate and, optionally, a set of instructions for formatting the

item.

Except for the AS, STRIP, and SPACE clauses, which are described in this entry,

the descriptions of elements of print-item shown in the syntax box are the

same as the descriptions for elements of print-item in the DETAIL command.

For more information, see DETAIL Command on page D-47.

AS format

is an Aw or a Cn display descriptor that specifies the width of the result of the

concatenated print list.

CONCAT ( print-list ) [ AS format ]

print-list is:

print-item [ , print-item ]

print-item is:

{ { { column-id } [ AS format ] } [ STRIP ] }

{ { { literal } } }

{ { { arith-expr } } }

{ { } }

{ { CONCAT ( print-list ) [AS format] } }

{ { } }

{ { IF cond-expr THEN ( print-list ) } }

{ { [ ELSE ( print-list ) ] } }

{ }

{ SPACE [number] }