BookmarkSubscribeRSS Feed
sahkul
Fluorite | Level 6
When SAS writes data to teradata tables through SAS/Access to teradata engines, it creates huge number of entries in DBC Query Log.

Is this something to do with the SQL used in SAS. SAS uses ANSI SQL and Teradata's SQL is different. When ever a row of data is added to teradata table, it commits that record and makes an entry into DBC Qyery Log of Teradata?

Can this be stopped?
1 REPLY 1
SASKiwi
PROC Star
I am not a user of Teradata but a quick search of SAS support confirms that the default behaviour of Teradata for updates is one row at a time. Suggest you try the DBCOMMIT = option to get Teradata to commit your updates say every 1,000 or 10,000 rows. Also suggest you investigate the Teradata MULTILOAD capability, This will not only improve update performance it will probably reduce query log entries. Check also with your DBA to see if there is a Teradata option for switching off the log messages.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 705 views
  • 0 likes
  • 2 in conversation