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

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

( 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.