I have an error -239 when I insert a User Defined Function in my
Impromtu Report.
Erreur nº -239 :
DMS-E-GENERAL, Une erreur est survenue pendant l'opération prepare
request.
DMS-E-SS_PARSER, Une erreur a été détectée pendant le traitement de la
requête SQL.
DMS-E-SS_INFO_SYNTAX, La description de la fonction 'mytest' dans le
fichier d'information de la base de données est erronée.
in english (translate by myself approximatively)
DMS-E-GENERAL, an error has occurred during operation prepare request.
DMS-E-SS_PARSER, The underlying database detected an error during
processing the SQL request.
DMS-E-SS_INFO_SYNTAX, description of fonction 'mytest' in information
file of database is false.
I read carrefully the cognos documentation
"How to create User-Defined Function" and realised a simple function
(basic).
My Database Name id BCmoi (catalog) and owner (schema) is dbo
My MSFUNCT.INI
[Database-specific Function List]
....
....
mytest=
at the end of file
....
[mytest]
label=mytest
param=0
return=CH
exp=mytest ( )
tip=Syntaxe: mytest() \nGive me a string it works.
tip1= String Expression
My COGUDFMS.SQL
DECLARE DATABASE FUNCTION mytest ( )
RETURNS STRING
FUNCTION NAME BCmoi.dbo.mytest;
My UDF in SQLSERVER 2000
CREATE FUNCTION dbo.mytest ( )
RETURNS NVARCHAR(10)
AS
BEGIN
DECLARE @Lib NVARCHAR(10)
SELECT @Lib = 'It Works'
RETURN @Lib
END
I would appreciate any help
Thanks
Laurent
sa******@cmcentre.fr