At runtime, you can provide a password for any Adabas file using the following extended CONNX syntax:

 

{fn setadapassword <table alias> , <password>}

 

Example: To specify a password for the CUSTOMERS_ADABAS Table, issue the following SQL statement:

 

SELECT * FROM adabas_windows.dbo.CUSTOMERS_ADABAS {fn setadapassword CUSTOMERS_ADABAS, PASSWORD}

 

If you have defined a global password in the data dictionary, the password specified with the SQL statement will override the global password.