>Hi, I want to do this:
>
>keyMaemp = [a UId generated with the API like 0BF56D7D-274A-43A0-8604-283233535]
>
>Then the query:
>SELECT * FROM nrh47200 INTO TABLE EVAL('keyMaemp')
Try:
SELECT * FROM nrh47200 INTO TABLE (keyMaemp)
Rather than a UUID, you might consider using a value created with SYS(2015), which is a 10 character string, always legally usable as a name, unique at least in the context of the workstation; by appending the NetBIOS name of the workstation to the return of SYS(2015), you should have a workable unique value, since within a given network, only one station can have a given NetBIOS name.
>
>At this point all its OK but the alias generated is something like C or D.
>I want to assign the same alias the table name is:
>USE
>USE EVAL('keyMaemp') ALIAS EVAL('keyMaemp')
>But this raises an error. Why?
An alias cannot start with a numeric digit; it must start with an alpha character or '_'