topic Re: Copy data work in database (oracle, teradata) in SAS Programming

Copy data work in database (oracle, teradata)

mansour_ib_sas — Fri, 30 Nov 2018 13:52:38 GMT

Hello,

Can we copy a table work to a database (oracle, teradata ..) ?

thank you

Re: Copy data work in database (oracle, teradata)

RW9 — Fri, 30 Nov 2018 13:55:31 GMT

Yes.

Re: Copy data work in database (oracle, teradata)

LinusH — Fri, 30 Nov 2018 13:55:41 GMT

Do you mean that you have one or more data sets in SASWORK (WORK) libfref, and want to copy them?

Of course you can. It will help if you have the license for SAS/ACCESS to Teradata end Oracle respectively (or even ODBC). If you don't, you probably need to do it in a more manual way via an external file, and load it using RDBMS tools.

Re: Copy data work in database (oracle, teradata)

mansour_ib_sas — Fri, 30 Nov 2018 14:11:57 GMT

Thank you for your answer which is very clear.

However, before copying a work table into a sgbdr system, do I have to inform a dba for example.

Or it's just a storage space like the folders we create in our Windows directories.

Re: Copy data work in database (oracle, teradata)

LinusH — Sat, 01 Dec 2018 07:13:26 GMT

You always need authorization for data operations, like create table and insert into.
If you are unsure of what authorization you have, yes, talking to your DBA's is a natural step.

Re: Copy data work in database (oracle, teradata)

mansour_ib_sas — Mon, 03 Dec 2018 09:42:53 GMT

If I want to put a table work in a sgbd in a temperate way;

the time of a treatment.

At this point, should I inform the dba?

Re: Copy data work in database (oracle, teradata)

andreas_lds — Mon, 03 Dec 2018 12:09:40 GMT

@mansour_ib_sas wrote:

If I want to put a table work in a sgbd in a temperate way;

the time of a treatment.

At this point, should I inform the dba?

Talk to you dba-staff ... we don't know the rules your company has.