Run SQL command on a database and store result in a macro

[Shiamak]

Hi,

Is there a way to connect to a database using a specific user , run a sql command .e.g select abc from abctableA and then store the result in a macro?

Appreciate your help.

[Shiamak]

I got the above issue resolved however the MACRO where value is being stored has space (single line on the top and space on the right), How do I remove spaces from a Macro?

[Shiamak]

I got the whole issue resolved.

Thanks