C0102 Compiler Error

Message text

Dynamic SQL command variable must be a string.

Explanation

You can use only string variables in dynamic SQL commands. The
following sample generates C0102:

int li_a

prepare sqlsa from :li_a; // generates C0102

execute immediate :li_a; // generates C0102

This sample compiles without error:

string ls_a

prepare sqlsa from :ls_a; // ok

execute immediate :ls_a; // ok

See Also

Using dynamic SQL in the section called “Using
dynamic SQL” in PowerScript Reference.

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2017

August 20, 2023

Was this article helpful?