https://communities.sas.com/t5/SAS-Procedures/SAS-DI-How-to-re-generate-names-of-temporary-views/m-p/13867#M2083 Hi <BR /> <BR /> Each job runs in it's own session (own environment with own work area) so having the same names in different jobs is no issue even when run in parallel.<BR /> <BR /> I tend to invest the extra development time and give all tables/views catchy names. It's just so much easier to debug a program if the names tell you what they are about.<BR /> <BR /> You can change the name of a table/view by selecting the table in the flow (this little green grid), mouse left click, choose "Properties" and then under tab "Physical Storage" enter a name under "Physical name".<BR /> <BR /> HTH<BR /> Patrick<BR /> <BR /> Message was edited by: Patrick Fri, 08 Oct 2010 10:33:36 GMT Patrick 2010-10-08T10:33:36Z https://communities.sas.com/t5/SAS-Procedures/SAS-DI-How-to-re-generate-names-of-temporary-views/m-p/13866#M2082 Hello!<BR /> <BR /> I need to make several similar big jobs, so I copy original job ("Copy to folder..."), rename it and make some changes. But the problem is that names of temporary tables don't change - it's not good, because these jobs can run simultaneously. So it's better to get new random names (like W5U45HC.....etc) that are unique in scope of all jobs. I can remove temporary view and then add new, but in this case I need to rewrite all mappings and expressions for columns in the transform (most of transforms are "SQL Join"). <BR /> <BR /> Is there any solution without making harm to mappings and expressions?<BR /> I use SAS DI 4.2 version Fri, 08 Oct 2010 09:33:51 GMT https://communities.sas.com/t5/SAS-Procedures/SAS-DI-How-to-re-generate-names-of-temporary-views/m-p/13866#M2082 deleted_user 2010-10-08T09:33:51Z https://communities.sas.com/t5/SAS-Procedures/SAS-DI-How-to-re-generate-names-of-temporary-views/m-p/13867#M2083 Hi <BR /> <BR /> Each job runs in it's own session (own environment with own work area) so having the same names in different jobs is no issue even when run in parallel.<BR /> <BR /> I tend to invest the extra development time and give all tables/views catchy names. It's just so much easier to debug a program if the names tell you what they are about.<BR /> <BR /> You can change the name of a table/view by selecting the table in the flow (this little green grid), mouse left click, choose "Properties" and then under tab "Physical Storage" enter a name under "Physical name".<BR /> <BR /> HTH<BR /> Patrick<BR /> <BR /> Message was edited by: Patrick Fri, 08 Oct 2010 10:33:36 GMT https://communities.sas.com/t5/SAS-Procedures/SAS-DI-How-to-re-generate-names-of-temporary-views/m-p/13867#M2083 Patrick 2010-10-08T10:33:36Z