search

IBM / ibmi-bob

A build system for creating IBM i-native objects using GNU Make.
https://ibm.github.io/ibmi-bob
Apache License 2.0
48 stars 21 forks source link

Support for .index file extension for CREATE INDEX sql files. #331

Closed bmcpherson-srlife closed 3 months ago

bmcpherson-srlife commented 3 months ago

I noticed when building a project today that was making use of Source Orbit's supported extensions that .index is not recognized by IBMi Bob. The index files are like this:

DROP INDEX IF EXISTS EMP_IDX_1;

CREATE INDEX EMP_IDX_1
  ON EMPLOYEE( DEPT DESC, MANAGER DESC )

  RCDFMT EMPR;

LABEL ON INDEX EMP_IDX_1
  IS 'Employee Index by Dept and Manager' ;

To get around the issue, I renamed the .index files to .view for the time being and it worked. I do not know if that is the correct approach, but it allowed the build to succeed. I just wanted to make mention of this, as a potential feature addition for Bob.

Thanks!