topic Re: load netezza database to sas viya cas server in Developers

load netezza database to sas viya cas server

michellekwai — Mon, 07 May 2018 19:32:30 GMT

Hi everyone,

I'm a beginner in using sas viya and sas studio. I try to connect our netezza database with cas server and also load certain files from netezza database to cas library. Codes are below, please feel free to point out how to correct it:

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

libname casbox cas;

proc casutil outcaslib="mycaslib";
load data=casbox.table_right replace;

list files incaslib="casbox";
run;

LOG: only error is below:

ERROR: File CASBOX.TABLE_RIGHT.DATA does not exist.

I understand the casbox doesn't have any files in it. but how can I load files in it.... I'm confused by those codes..

Thanks in advance! I appreciate for all the helps!

Regards,

Michelle

Re: load netezza database to sas viya cas server

alexal — Fri, 11 May 2018 16:56:21 GMT

@michellekwai,

Could you please show us full SAS log?

Re: load netezza database to sas viya cas server

michellekwai — Fri, 11 May 2018 17:22:51 GMT

Hi @alexal

Actually the problem is below. I tried several days to figure out how to do that.....

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" 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! !

Regards,

Michelle

Re: load netezza database to sas viya cas server

michellekwai — Fri, 11 May 2018 17:27:32 GMT

Hi @alexal

The whole log is below:

SAS Studio

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 /* CASLIB for SANDBOX */

74 cas;

NOTE: The session CASAUTO connected successfully to Cloud Analytic Services vjxnsvcasp01.local using port 5570. The UUID

is 1ef82d33-901e-e44f-b111-d732e356308f. The user is 123 and the active caslib is CASUSERHDFS(123).

NOTE: The SAS option SESSREF was updated with the value CASAUTO.

NOTE: The SAS macro _SESSREF_ was updated with the value CASAUTO.

NOTE: The session is using 6 workers.

75 caslib tlake datasource=(srctype="odbc",

76 username="123",

77 password=XXXXXXXXXXXXXX,

78 odbc_dsn="Nz_Analysis",

79 catalog="*");

NOTE: 'TLAKE' is now the active caslib.

NOTE: Cloud Analytic Services added the caslib 'casbox'.

NOTE: Action to ADD caslib casbox completed for session CASAUTO.

81 proc casutil ;

NOTE: The UUID '1ef82d33-901e-e44f-b111-d732e356308f' is connected using session CASAUTO.

82 load casdata="CUN1" casout="CUN1";

NOTE: Performing serial LoadTable action using SAS Data Connector to ODBC.

ERROR: ERROR: ERROR: relation does not exist TRUSTMARK_ANALYSIS.B513SASP.CUN1

ERROR: Function failed.

ERROR: The action stopped due to errors.

NOTE: The Cloud Analytic Services server processed the request in 0.242575 seconds.

83 run;

85 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: load netezza database to sas viya cas server

alexal — Tue, 15 May 2018 12:51:47 GMT

@michellekwai,

I would suggest you open a track with our access team.