Edit Sql Line Commands - Documentation for Bmc Ami Devx File-Aid/Rdx 23.01

EDIT SQL line commands can be specified with a repetition factor, n. Block commands are not valid.

SQL Line Command

Description

D (Delete)

Deletes the current line.

Dn

Deletes the current line plus n subsequent lines.

I (Insert)

Inserts a line after the current line.

In

Inserts n number of lines following the current line.

R (Repeat)

Repeats the current line.

Rn

Repeats the current line for n number of lines.

Relational operators

Relational Operators

Description

>

is greater than

<

is less than

=

is equal to

¬= or <>

is not equal to

>=

is greater than or equal to

<=

is less than or equal to

¬>

is not greater than

¬<

is not less than

IS NULL

has a null value

LIKE

searches for a pattern

IN

in a list of values

BETWEEN

within a range of values

AND is implied as the logical operator between columns. Specify OR to override the implied AND. Use NOT to negate IS NULL, LIKE, IN, and BETWEEN operators.

Maya Lin-Takahashi

Maya Lin-Takahashi

Consumer Tech & Gadget Reviewer

Maya is a hardware enthusiast who tests and reviews smart home devices, smartphones, wearables, and audio gear. She focuses on practical consumer value and build quality.

Share this article
Twitter Facebook Pinterest