The following SELECT statement returns information about the external stored procedures in database ‘dba’:
SELECT * FROM DBC.ExternalSPsV WHERE databasename = ‘dba’;
Result:
DataDatabaseName dba ExternalProcedureName XSP_100 ExternalProcedureId 00006E0F0000 NumParameters 2 ExternalName xsp_100 SrcFileLanguage C NoSQLDataAccess Y ParameterStyle S ExecProtectionMode P ExtFileReference CS!xsp_100!/home/i18n/ckl/udftest/xsp_100.c CharacterType 1 Platform LINUX64 RoutineKind R ParameterUDTIds AuthIdUsed 00001E0A0000 AppCategory S GLOPSetDatabaseName ? GLOPSetMemberName ?