SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Explicit pass-through with "insert"

Accepted Solution Solved
Reply
Super Contributor
Posts: 336
Accepted Solution

Explicit pass-through with "insert"

Hello,

 

is there an explicit pass through equivalent for:

 

Insert Into stage.Table Select * From SASLib.Table;

 

using SAS/ACCESS to ODBC?

 

Thanks&kind regards


Accepted Solutions
Solution
‎09-07-2016 01:36 AM
Super User
Posts: 5,256

Re: Explicit pass-through with "insert"

...and there's indeed a valid reason.

If that's an option, reducing DBMS name length will help interoperability in the long run.

Another option would be creating views, if your DB support those for insert operations.

Data never sleeps

View solution in original post


All Replies
Super User
Posts: 5,256

Re: Explicit pass-through with "insert"

Not really.
If you have the necessary permission you could load a temporary table first, and then issue the insert from an execute block.
But why?
Data never sleeps
Super Contributor
Posts: 336

Re: Explicit pass-through with "insert"

.. because the SQL-name exceeds 32 characters (the easy solution is of course to change the names on the SQL-server).

Solution
‎09-07-2016 01:36 AM
Super User
Posts: 5,256

Re: Explicit pass-through with "insert"

...and there's indeed a valid reason.

If that's an option, reducing DBMS name length will help interoperability in the long run.

Another option would be creating views, if your DB support those for insert operations.

Data never sleeps
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 368 views
  • 1 like
  • 2 in conversation