Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 14 Apr 2005 @ 12:33:38 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Error 8006 while creating UDF
 
From:   Dennis Calkins

  I am getting below pasted error while creating a function. Can anybody guide me to compile the below function.  


          > CREATE FUNCTION squel.plusudf(        a     INTEGER,        b
          >     INTEGER)
          > RETURNS INTEGER
          > LANGUAGE C
          > NO SQL
          > EXTERNAL NAME 'CS!sname!/export/home/sh/fnc/plusudf.c'
          > PARAMETER STYLE TD_GENERAL;
          >  *** Warning: Unknown response parcel 151
          >   0000  0101 0100 0029 2F65  7870 6F72 742F 686F  *.....)/export/ho*
          >   0010  6D65 2F7A 6177 2F74  656D 702F 7368 616A  *me/sh/fnc/plusud*
          >   0020  752F 666E 632F 706C  7573 7564 662E 6300  *f.c.............*
          >   0030  0000 0000 0000 0000  0000 0000 0000 0000  *................*
          >   0100 *0000 0000 0000                            *......*
          >  *** Error 8006 Invalid message kind.
          >  *** Total elapsed time was 1 second.

CS! means the Source is on the client.

CLI sends the name of the file down to the database as part of the SQL and after parsing the SQL the database sends a request to the Client to send the file which is Parcel number 151.

If you don't have TTU 7.1 or greater CLI doesn't know what this parcel is.

There are 2 ways around this.

1. upgrade you client software to TTU 7.1 or greater.

2. Put your source on the Server. SS!


The really cool thing about the DEMO software is the Client and the server are the same machine so you don't have to do anything special just change the CS! to a SS! and it will work.

Now if the Teradata server is actually somewhere else on your network, FTP your source down to one of the nodes. then use the SS! syntax to tell Create function where you put the source on the server.



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023