create a template program with an associated prompt

[Phuels]

Hello,

I currently use an abbreviation macro to insert my connection string when writing a new program. Recently, my company turned on validation, so I now need to enter a user id and password when creating the data connection.

I modified the abbreviation macro to include the necessary references:

proc sql outobs=;
connect to db2 (database='ACTDM5' user=&_CLIENTUSERID password=&User_Password);

The User_Password variable comes from a prompt I created using the Prompt Manager.

Is there a way to automatically associate the prompt when creating a new program? If so, how would I do this?

Thanks for your help.

-Frank

[tomrvincent]

Can you explain what you mean by 'automatically associate'? Does that mean a new program would have access to it? Or something else?

[Phuels]

I'd like to create a macro (or series of macros) that:

• Create a new program with the default connection string
• Create the User_PASSWORD prompt
• Associate the User_PASSWORD prompt with the new program without having to go into the program properties > prompts > add... to manually associate.

[tomrvincent · Accepted solution]

What I do is have a egp template that has an autoexec program with the password prompt defined. That'll solve your problem.