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.
... View more