9 201 REBUILD_FILE

9.201 REBUILD_FILE

Þ Note: Built-In Function Rules.

Optionally drops the existing file and its views, and creates a new file from the CTD file.

REBUILD_FILE can also be used to alter a PC OTHER File to add the two LANSA columns X_RRNO and X_UPID.

For use with

LANSA for i NO Visual LANSA for Windows YES Visual LANSA for Linux NO

 

Processing

If drop views specified, drop the table and its matching views.

If Create new file is specified, create the new table from the CTD file.

If Use Connection Parameters in CTD file is specified, alter the table in the external database specified in the CTD file.

If Prompt for user ID and password is specified, remove the existing user id and password from the connection parameters in the CTD file and allow the database manager (e.g. ODBC driver) to prompt for the user id and password. Note that some database managers prompt for much more than this, even though it is only the user id and password that is required. Some others do not need a user id and password and so the database manager will still not prompt for them (e.g. MS Access and MS SQL Server).

Arguments

No. Type Req/ Opt Description Min Len Max Len Min Dec Max Dec 1 A Req The LANSA File Name 1 10     2 A Opt Drop File and Views Values: Y = Drop N = Do not Drop Default = Y 1 1     3 A Opt Create New File Values: Y = Create N = Do not Create Default = Y 1 1     4 A Opt Use Connection Parameters in CTD File Values: Y = Connect using CTD File N = Use current database connection Default = N 1 1     5 A Opt Prompt for user ID and password Values: Y = Prompt N = Use CTD file user id and password Default = N 1 1     6 A Opt Library Name 1 10     7 A Opt CTD Location Level A= All (Partition + System). P = Partition Level only. S=System Level only. Default is A. 1 1

 

Return Values

No. Type Req/ Opt Description Min Len Max Len Min Dec Max Dec 1 A Req Return Code: OK = File successfully rebuilt ER = An Error occurred rebuilding the file 2 2