topic Re: How to know the status of Teradata table when it is being loaded? in SAS Programming

How to know the status of Teradata table when it is being loaded?

kiranragam — Mon, 19 Oct 2020 11:38:24 GMT

Hi Team,

As pert of our requirement we need to load a Teradata table(COMMON_TABLE) from multiple SAS Jobs. I am using PROC APPEND (Multiload=YES TPT=YES) to load the data into Teradata table from a sas dataset.

While JOB-A is loading data into COMMON_TABLE, JOB-B should wait until the JOB-A passed through the loading step. If I can check the status of a table in a SAS program, I would keep the other jobs running concurrently into multiple sleep intervals and can proceed the execution as soon as the table is available to load. Could you please help me if there is way to check the status of a Teradata table while it is being loaded?

I tried below approach before I post the question here:

#1. While loading data I noticed a temp table _RS is being created, so I kept the existence check of _RS table before loading and tried to keep the job on sleep until the _RS tables get disappeared. But if the job that is loading data gets failed in between then _RS will remain in the database and other jobs will never get executed until _RS table gets deleted manually.

Re: How to know the status of Teradata table when it is being loaded?

ChrisNZ — Mon, 19 Oct 2020 22:12:04 GMT

Surely Job-A creates a log file. Why not check that file?

Re: How to know the status of Teradata table when it is being loaded?

SASKiwi — Tue, 20 Oct 2020 01:21:11 GMT

@kiranragam - Another option could be to have a loading tracking table (a SAS table or a Teradata table) that records when Teradata loads start and end. Then get every SAS job loading into Teradata to update this tracking table.

You can then use the tracking table to check if Teradata is available for loading or not.

Re: How to know the status of Teradata table when it is being loaded?

kiranragam — Sat, 24 Oct 2020 05:55:10 GMT

I have used Sas dataset as a loding track table and it solved the issue. Thank you for your suggestion.