No because it gives me data for select query on same table.Thanks! 25 GOPTIONS ACCESSIBLE; 26 proc sql; 27 CONNECT TO oracle as ora2 (authdomain=casemgmt_db_auth PATH 27 ! ='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxx)(PORT=xxx))(CONNECT_DATA=(SERVICE_NAME=xxx))) 27 ! '); 28 create table abc as 29 select * from connection to ora2 30 (select * from ecmb.CASE_UDF_DATE_VALUE where udf_nm ='X_RECEIVE_DT_TXT' 31 and case_rk=100558 order by valid_from_dttm desc 32 ); NOTE: Table WORK.ABC created, with 1 rows and 6 columns. ... View more

proc sql; 28 connect to oracle as ora2 (authdomain=casemgmt_db_auth PATH ='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) 29 (HOST=xxxxxxxxx)(PORT=xx))(CONNECT_DATA=(SERVICE_NAME=xxx)))'); 30 execute 31 ( 32 UPDATE ECMB.CASE_UDF_DATE_VALUE 33 SET UDF_VALUE=to_char('06-AUG-2019','dd/mon/yyyy hh24:mi:ss') 34 WHERE udf_nm ='X_RECEIVE_DT_TXT' and case_rk=100558 35 )by ora2; ERROR: ORACLE execute error: ORA-00942: table or view does not exist. ... View more

no its a naming convention we have it here. its a table and not a view.And I want to update it using passthrough as there are some records which are not getting updated with implicit method.Thanks ... View more

I get error as     error 22 -322:expecting a name. ... View more

Just a demo code.with changed names.sorry if i there is typo.but syntax is same ... View more

Here is the code- proc sql; connect to teradata as tera1 (user="xxxxxx" password="xxxxxxx" server="xxxxx" tpt=yes fastexport=yes); create table mytable as select * from connection to tera1 (select age ,entityno ,cast(segid as varchar(50)) as fbu1 ,cast(profgrp_id as varchar(30)) as trnsid ,cast(accno as integer)as accno ,cast(startdt as varchar(10)) as startdt ,cast(enddt as varchar(10)) as enddt from mytable1 a Mytabke2 where age > 15 ); disconnect from tera1; quit; ... View more