I'm trying to create a join index between two tables using this command, but I get this message:
ixutil -crejidx [table1],[column1] [table2],[column2] -libpath [library location] -joinparts 4
ERROR: Join index name exceeds max lengh of 80
Error Performing Index Utility. Processing aborted
The would-be index name is [table2].jdx[column2].[table1].jdx[column1].0.0.0.spds9, which is 89 characters long.
My question is, is it possible to specify a join index name or do I need to rename the columns/tables? I want to avoid this as it may present other difficulties/annoyances in the ETL process.
We're on SPDS 4.5.
What do you mean by the actual ixutil code? Do you mean the code underlying the unix command? I don't know how to find that. I provided the command I was using:
ixutil -crejidx [table1],[column1] [table2],[column2] -libpath [library location] -joinparts 4
I don't want to provide my specific table and column names.
Okay,
ixutil -crejidx longer_table_name1,column_name_thats_too_long shrtr_tbl_nm,column_name -libpath /libraryfolder -joinparts 4
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.