BookmarkSubscribeRSS Feed
nikhil_khanolkar
Calcite | Level 5
Hi, Can we alter a table Metadata of LASR In Memory Table? e.g. Say changing a length/type of the column Nikhil
2 REPLIES 2
Kurt_Bremser
Super User

When you change the size of a variable/column, this impacts the structure of the whole file, record by record. So it always implies a rewrite of the whole table, either on disk (Base SAS) or in memory.

acemary
Calcite | Level 5

In my case a XML column trows of the SQL Instance CDC script to create the mirror table and adds the column called unused_1.
Here are the steps that I did to get it to work.  Pega Training in Chennai

1. Create the table in the CDC Designer console as you usually would.
2. Copy the CDC instance deployment script (from the right of the screen)
3. Remove the table that is being dropped when data is added.
4. Copy the table creation and CDC section from the script, remove the unused_ column, and execute.
5. The mirror table is now created and CDC is activated on it.
6. Check that the table is in the CDC designer.   VMware Training in Chennai
7. Add data to the oracle table and see the changes being recorded.

Do more testing of data being moved.

I hope this helps! I took me quite a while to figure this work around out and I hope it will be fixed in future versions.   PHP Training in Chennai

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 connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 925 views
  • 0 likes
  • 3 in conversation