Failed to load cas in memory data to teradata db

[bimal_sen]

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

[alexal]

@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?