- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
I have my labels stored in a macrovariable. I want to apply them to my LASR table but i'm receiving an error.
Do i have to change the assigning of my library? Or are there other possibilties? I prefer not to do a datastep.
proc datasets library=&lasrLibref;
modify &outtable;
label &label_sql_dataset;
run;
ERROR: Update access is not supported for file KS1BU01L.TEST_1510_1149.DATA.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You have to use metadata_setattr function, because you need to update a metadata entry for that table.
data _null_;
rc=metadata_setattr("omsobj:PhysicalTable?@Id='<TABLE_ID>'","Desc","This is a new label");
put rc=;
run;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Is your code for column label? Or for the table label?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
That code will update the metadata column "Description".
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I've solved it with putting the labels in my datastep statement which will load the data to hadoop from SQL database.
/* upload to hadoop with labels */
data &hdfsLibref..&outtable (/*debug optie: logupdate=yes*/ blocksize=64M label="&tableDescr.");
set &_input;
label &label_sql_dataset;
run;