Failed to load cas in memory data to teradata db

bimal_sen — Sun, 02 Feb 2020 02:23:47 GMT

Hi Friends,

We have SAS Viya license. SAS® Studio (5.1), SAS® Viya® release:V.03.04.I failed to load cas in memory data to teradata db. But the reverse case load data from teradata db to cas in memory successfully. But i can successfully load data to Teradata db using SAS 9.4 libname or proc sql successfully.

Please suggest. Please find my code below.

--------------------------------Load teradata db to cas in memory------------------Successful----------------------------------------------------------
cas;
caslib tdlib
datasource=(srctype='teradata' dataTransferMode='serial' server='AWSTEST'
username='sasbi' password='sasbi' database='BIM');
run;
caslib _all_ list;
proc casutil;
list tables incaslib="casuser";
load casdata="price_dates" incaslib="tdlib" outcaslib="casuser" casout="price_dates_1";
list tables incaslib="casuser";
quit;
libname pp cas caslib=casuser;
proc print data =pp.price_dates_1(obs=10);
run;
---------------------------------Load cas in memory data to teradata db--------------------Failed-------------------------------------------------------
cas;
libname mycas cas caslib=casuser;
data mycas.carsWght;
set sashelp.cars;
if weight<5500 then delete;
keep make model type weight MPG_City;
run;
options msglevel=i;
caslib tdlib
datasource=(srctype='teradata' dataTransferMode='serial' server='AWSTEST'
username='sasbi' password='sasbi' database='BIM');
run;
proc casutil;
list tables incaslib="casuser";
load casdata="carsWght" incaslib="casuser" outcaslib="tdlib" casout="carsWght_1";
list tables incaslib="tdlib";
quit;
libname mytdlb cas caslib=tdlib;
proc print data=mytdlb.carsWght_1(obs=10);
run;

Regards,

Bimal

Re: Failed to load cas in memory data to teradata db

alexal — Mon, 03 Feb 2020 12:05:45 GMT

@bimal_sen ,

You do not need to create multiple threads with exactly the same question. Anyway, in your original thread, I've asked if you could show your SAS log with an error?

topic Failed to load cas in memory data to teradata db in SAS Studio

Failed to load cas in memory data to teradata db

Re: Failed to load cas in memory data to teradata db