Rick,
the code above produces an error:

create My_Data from X C [colname=AllNames];
-
22
202
ERROR 22-322: Syntax error, expecting one of the following: ;, (|, [.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
append from X C;
-
22
76
ERROR 22-322: Syntax error, expecting one of the following: FROM, VAR, VARIABLES.
ERROR 76-322: Syntax error, statement will be ignored.

please comment. many thanks in advance!