Data Preparation: The CREATE VIEW statement cannot be processed directly by the database.

[dakes]

Hi,

I am trying to create a view in data preparation but I am unfortunately greeted by the error in the title. Is there any I can get this to work?

SAS VA is version 7.4, the target database is SQL Server.

The reason I am trying to create a view is because creating a table just leads to VA showing "running" for hours without any results. The source table is 5gb big and consists of 23mio rows, maybe that is too much?

Thanks,

David

[Erik_Zencos]

Hi David,

It really depends on your hardware, but 23 millions rows (5gb) is not that much. I once loaded a table that was around 115gb (oracle) and it took about 15 minutes (we had decent hardware). Have you tried to load a small table just to check that your server and library definitions is working? I would also take a look at the options in the library statement to see if you can optimize the query a bit. Take a look at the SAS Acess documentation (and google to find more specifc papers).

http://documentation.sas.com/?docsetId=acreldb&docsetTarget=titlepage.htm&docsetVersion=9.4&locale=e...

Regards,

Erik

[dakes]

Hi Erik,

thank you for your reply. I found the problem: I was downloading and uploading to and from the same database server. So even if it had worked I wouldn't have had the data where I wanted it (in the LASR server). I chose the correct library and now everything is working as expected.

Regards,

David