#DateWhereItemComment
3105 Jul 2016 @ 02:15 PDTConnectivityAccess External Data - A Table UDFFirstly, apologies for my late reply, I've only just seen and got around to this. There is a limit of 254 columns, but it isn't a DbLink limitation. UDF's are limited (by Teradata) to ...
3028 Jan 2016 @ 05:48 PSTConnectivityAccess External Data - A Table UDFNot really. Indeed, I have logged a report with engineering on this very matter. The UDF code is very simple - read a block of records from the Server and return them to Teradata - there is v...
2926 Jan 2016 @ 11:47 PSTConnectivityAccess External Data - A Table UDFHi there thakurra, Thanks for your questions. 1) UNfortunately you can not hide the password using DbLink, but you can with Teradata views and permissions. What I recommend is that you create a v...
2816 Nov 2015 @ 10:01 PSTConnectivityAccess External Data - A Table UDFToday I've updated the DbLink code. The new version can be downloaded from Part 1 of the DbLink bookset. Please read the information about not mixing and matching different DbLink components/m...
2716 Nov 2015 @ 09:48 PSTConnectivityAccess External Data - Part 1 The Table UDFToday I've posted some updates to the DbLink code. These updates include new functionality, improved functionality, miscellaneous bug fixes and some documentation updates. The old version...
2616 Nov 2015 @ 05:09 PSTConnectivityAccess External Data - Part 2 Add support for other data sourcesI am not sure how to send an "InMessage" here, but never the less, the discussion for option #2 (get someone else to do it), is simple. Get them to read the article and follow the exampl...
2511 Nov 2015 @ 03:23 PSTConnectivityAccess External Data - Part 2 Add support for other data sourcesSorry, no. The only plugins that I am aware of is the oracle one that I wrote. You have two choices: 1) Use the code attached here and modify it to suit your needs 2) Get someone to do it for yo...
2420 Jul 2015 @ 04:37 PDTConnectivityAccess External Data - A Table UDFBoth of your issues are networking issues. The first issue "IOException: Connection times out" means that the UDF cannot connect to the named server (i.e. 148.171.28.158) on the specifie...
2312 Jul 2015 @ 09:16 PDTConnectivityAccess External Data - A Table UDFRe getting updates, all articles and so on are done on a voluntary basis. Sometimes we have other things to do and are unable to respond immediately. For both of the above errors, did you try to r...
2222 Jun 2015 @ 04:42 PDTConnectivityAccess External Data - A Table UDFRegarding your test box. The fact that you have connection *FROM* the unix box *TO* teradata *DOES NOT* mean that you have connectivity *FROM TERADATA* back *TO Unix*. Connectivity from a client t...
2122 Jun 2015 @ 04:33 PDTConnectivityAccess External Data - A Table UDFRe: "ksh: ./deploy.sh: cannot execute" To run a unix script, you need to make it executable. search the internet for the chmod command. The user ID in the test client is a fixed value. ...
2021 Jun 2015 @ 05:17 PDTConnectivityAccess External Data - A Table UDFThis error usually occurs because the Table UDF does not exist in the named database (or in your case the current database). You need to change to the database in which the UDF "DbLinkGetMeta...
1919 Jun 2015 @ 02:18 PDTConnectivityAccess External Data - A Table UDFI think it is best if we pause and reset. Please try to get it up and running by following the steps in sequence - don't just jump to the end. Number 1) *Do not* use port 1025 for the DbLink S...
1816 Jun 2015 @ 07:11 PDTConnectivityAccess External Data - A Table UDFAt this point, the DbLink Server is ready and waiting for a request from a client. The client can either be the table UDF or the DbLinkClient application. So at this point, you could start another...
1714 Jun 2015 @ 06:20 PDTConnectivityAccess External Data - A Table UDFUnfortunately, I can not distribute the web manager app I have removed it from a later version of the documentation which I am yet to upload. As for the error creating the function, have you uploa...
1609 Dec 2014 @ 03:32 PSTConnectivityAccess External Data - A Table UDFDue to technical complexities, the top level article had to be published before the two sub articles. I've now published the sub-articles with "the stuff". Apologies for the delay in ...
1517 Jul 2014 @ 05:06 PDTApplicationsLarge Objects - Part 1 LoadingThankyou for your feedback, I'm glad you found the article helpful. If I understand your question, you are really asking two separate questions. Q1) Can the ID be an integer instead of a varc...
1426 Apr 2011 @ 02:50 PDTExtensibilityDeveloping Database Extensions (UDFs etc)I do not know where the attachements went. However I've added them again, you will find them in the zip file. Enjoy :-)
1328 Mar 2011 @ 05:25 PDTExtensibilityDeveloping Database Extensions (UDFs etc)Hi Dirk (dlieske), sorry I missed your comment. Firstly, thanks for the feedback, it was fun writing the article :-) - I wish I had time to do all my others :-( The names of the variables in th...
1228 Mar 2011 @ 05:16 PDTExtensibilityDeveloping Database Extensions (UDFs etc)I would have expected that when using the null (e.g. sel fn_abc(null)), Teradata would have used the Integer variant of the function. This is because null's are by default integer (try: sel type(nu...
1123 Sep 2010 @ 07:34 PDTApplicationsLarge Objects - Part 2 retrieval web applicationInteresting feedback. I would have assumed that the Driver would cache the C/BLOB either and access via the Stream obtained from the resultset and the Blob object would be equivalent. As a matte...
1016 Sep 2010 @ 04:16 PDTApplicationsLarge Objects - Part 2 retrieval web applicationHi Mike, Have you tried wrapping the Input Stream into a Buffered Input Stream? For example: .... InputStream blobStream = blob.getBinaryStream(); BufferedInputStream bufferedBlob...
920 Jul 2010 @ 06:32 PDTApplicationsLarge Objects - Part 1 LoadingI'm not familiar with "upload beans", but its web site (http://www.javazoom.net/jzservlets/uploadbean/uploadbean.html) says you can upload the files into memory (and files and other targets - inclu...
819 Jul 2010 @ 05:18 PDTApplicationsLarge Objects - Part 1 LoadingBasically you need a side order of "LOBCOLS" with that script. The .import command needs to know how many columns are Large Objects. You can read more about this in the .import command section of ...
715 Jun 2010 @ 07:14 PDTApplicationsLarge Objects - Part 1 LoadingI've re-added it. Hopefully it sticks around this time :-)

Pages