ADS function list

[hag]

copy please

hgoldstein@dslextreme.com

[Francis Barrimbhal]

Please, please send me a copy too... dr.microso@hotmail.com
I am happy and thankful ...

[sambomb]

Files uploaded!
http://www.filesonic.com/file/159404690 ... nction.zip

[Francisco Valério]

I'm working with ADS , but I'm hard of encrypted tables with .adt extension. Someone uses table encryption in ADS and tell me how the process was conducted.

[reinaldocrespo]

Hello Francisco;

If these tables are Data Dictionary bound tables, as I suspect they are, then you only need to set the encryption password on the dictionary and then enable encryption for the table in question.

Below is a short SQL script that enables encryption for all tables on a data dictionary:

Code: Select all  Expand view

DECLARE EncryptTables CURSOR as
              SELECT *
                FROM System.Tables
               WHERE table_encryption = 0;
OPEN EncryptTables;

WHILE FETCH EncryptTables DO
     EXECUTE PROCEDURE sp_ModifyTableProperty([EncryptTables].[Name],'TABLE_ENCRYPTION','TRUE','APPEND_FAIL',NULL);
END WHILE;

CLOSE EncryptTables;
 

Notice the script above uses an ADS Store Procedure. You could also use ADSEnableEncryption() + AdsEncryptTable() API functions, as in:

Code: Select all  Expand view

( cAlias )->( AdsEnableEncryption( "EncryptionPassword" ) )
( cAlias )->( AdsEncryptTable() )
 

FYI - it is also possible to encrypt a single record on a table.

I find it is definitely simpler if using ADS Data Dictionary.

Hope that helps.


Reinaldo.