Thank you Reeza It worked ... View more

I tried that also but that didn't worked either. Through pass through its working fine, again thanks to you, so for now I would go with it as an alternative method. But I will look into it and share it with you also if it happens. Also I would like you to have a look into my another query as well which is May be you could help me with it as well. Would be really grateful. ... View more

You didn't get me Jaap. I have a structure made in teradata for a table. For example, I have a table dummy_tera having a column start_date as date column. Now I have another table dummy_ora having same structure as dummy_tera with data but only difference is that it is timestamp datatype. Now if I apply datepart(start_date) and then insert it into Teradata table using proc sql; Insert into... Select * from... THEN IT WORKS PERFECTLY FINE, otherwise it give an error that SAS VALUE CANNOT BE CONVERTED INTO TERADATA DATE. Now I made a generic script which rather a macro which can load as many table as anyone want at a time which do not have date columns. I want to optimize my script so that it can handle date columns as well. So that It can apply datepart automatically whenever it searches a date type field. For that I need an idea. ... View more

No I haven't Jaap,  I'm just 3 weeks new to SAS and I'm learning on my own. That's why I haven't read those chapters which you are referring. But I'll surely gona read them now. ... View more

I did that earlier Tom what you are suggesting now. Data test; A=datetime() ; Run; Proc sql; Update. Tera.table set column=(select a from work.Test) ; And still not working. Same error CURSOR PROCESSING IS NOT ALLOWED IN TERADATA MODE. It does work on an insert statement but not in update statement. ... View more

If I simply want to insert current datetime in teradata table by simply using, proc sql; update tera.table_name set column = datetime(); quit; This is throwing me error: CURSOR PROCESSING IN TERADATA MODE IS NOT ALLOWED. Can you suggest how to do it? ... View more

That worked!!! Thank you so much Tom. But I am nort able to insert current timestamp using sas function datetime() if I am not passing through. by using, proc sql; insert into tera.table_name set column = datetime(); quit; This is throwing me error: CURSOR PROCESSING IN TERADATA MODE IS NOT ALLOWED. ... View more

But I can update or insert or create the table if I do not pass through into teradata ... View more

Thanks for the kind feedback. Suppose I have a table xyz in teradata with column Job_id, status and end_time. At first when a job starts, the precode sends the job_id, Start_time I. E. "&etls_startTime"dt and status as inprogress After the job executed I want to update the end time of that job using current datetime as" & etls_endTime" is working because it is captured after the precode has run. This is what I want to achieve, but I don't want use status Handeling due to some reason. ... View more