load files in memory from odbc

[michellekwai]

Hi everyone, 

I am a beginner in sas viya. I come across a problem:  load files in the memory.

But I can connect to our odbc database successfully and I can see all files in caslib casbox too. Code below:

cas;
caslib casbox datasource=(srctype="odbc",
username="123",
password="123",
odbc_dsn="Nz_Analysis",
catalog="*");

proc casutil ;
list files incaslib="casbox";

load casdata="CUN1" incaslib="casbox" outcaslib="casuser"
casout="CUN1";
run;
quit;

ERROR: ERROR: ERROR: relation does not exist ANALYSIS.123.CUN1

ERROR: Function failed.

ERROR: The action stopped due to errors.

Any ideas to solve this problem? Thanks in advance! 

Best, 

Michelle 

[JBailey]

Hi @michellekwai,

By chance are you using Netezza and 3 level table names?

Best wishes,
Jeff