Columns added to Oracle table and missing in SAS

foxrol — Wed, 12 Jul 2023 04:33:13 GMT

Hi everyone,

I've one issue.

Since today i was having a libname to connect to Oracle and see all columns of one Oracle table.

Now, an DBA added three columns to an Oracle table and I have to feed them.

I'm facing a big issue because i don't see those three new columns when using the same libanme.

Could you tell me what to do? Do i have to update metadata?

Thanks

Re: Columns added to Oracle table and missing in SAS

SASKiwi — Wed, 12 Jul 2023 04:43:11 GMT

If you are registering the Oracle tables in SAS metadata then yes. Personally I prefer to avoid such issues by using the AssignMode=2 extended attribute in the metadata library definition.

topic Columns added to Oracle table and missing in SAS in SAS Programming

Columns added to Oracle table and missing in SAS

Re: Columns added to Oracle table and missing in SAS