Archives of the TeradataForum
Message Posted: Thu, 14 Apr 2005 @ 12:33:38 GMT
> 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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|