#DateWhereItemComment
2631 May 2016 @ 02:17 PDTConnectivityAccess External Data - A Table UDFWe are trying to compile attached views on (the target System) and its failing with error ‘REPLACE VIEW Failed. 9881: Function Dblink called with invalid number or type of parameters&rsq...
2531 May 2016 @ 02:16 PDTConnectivityAccess External Data - Part 1 The Table UDF  We are trying to compile attached views on amex1 and its failing with error ‘REPLACE VIEW Failed. 9881: Function Dblink called with invalid number or type of parameters’ These ...
2428 Jan 2016 @ 08:48 PSTConnectivityAccess External Data - A Table UDFIs there any performance improvement for Java UDF because it is consuming more CPU during ftech the data from Oracle. We can make any improvement. It consumes 14K CPU with only 22 million data usin...
2326 Jan 2016 @ 08:39 PSTConnectivityAccess External Data - A Table UDFNeed some suggestion regarding the securit. 1. How i can hide the password in TD where we have put the ID/Password to connect with Oracle. 2. can we pass the query in DbLink function during selec...
2225 Jan 2016 @ 10:54 PSTConnectivityAccess External Data - A Table UDFWe have installed the new version on DbLink and it is woking fine. But it is shuting down automatically. We need to start every time(That we should do). Not sure what would be the reason to shut do...
2111 Jan 2016 @ 10:27 PSTConnectivityAccess External Data - Part 1 The Table UDFThanks Sir for update. I am going to use the new version of DbLink that is 1.3.0 for POC and once POC got successfull done then i will go ahead for productions. We had done the POC on DbLink 1.2 an...
2028 Jul 2015 @ 01:49 PDTConnectivityAccess External Data - A Table UDFThank you so much sir, Now i have opned the port and able to connect with Teradata To Oracle and able to fetch the records from Oracle. Finally got success to use this DbLink facility with your hel...
1914 Jul 2015 @ 03:25 PDTConnectivityAccess External Data - A Table UDFAll functions has been installed succesfully. because one function if giving the results as mention in above post. But the issues only with dblinkgetmeta function.
1814 Jul 2015 @ 03:24 PDTConnectivityAccess External Data - A Table UDFThanks sir for reply. Sorry for the comment. I got a lot of help to reach on this step to install this facilities. Hoping for your kind help in future as well. The error "Select failed. 7584:...
1706 Jul 2015 @ 04:36 PDTConnectivityAccess External Data - Part 2 Add support for other data sourcesHi Looking for help to get coonection from Terdasta with oracle for this dblink. Please suggest me
1603 Jul 2015 @ 01:41 PDTConnectivityAccess External Data - A Table UDFThanks for your all suggestions: I have installed the UDF and created successfully. But when i am running the below 2 queries. 1-select * from table(dblinkgetmeta('dbcinfo:vmhost')) as dt...
1503 Jul 2015 @ 11:14 PDTConnectivityAccess External Data - A Table UDFCan i use this facility in production?
1422 Jun 2015 @ 05:21 PDTConnectivityAccess External Data - A Table UDFThank you so much for your support. After your suggestion to run the deploy.sh file. When i run the client with test dbcinfo it has given the data type and all. when i ran the same dblink name wit...
1322 Jun 2015 @ 04:41 PDTConnectivityAccess External Data - A Table UDFWhen i am trying to run the below command from SQL assistant it is running fine without any issues call db_link.Replace_Jar('CJ!$C:\Users\rthak14\Desktop\Software\DbLinkDistribution_1\DbLinkCl...
1222 Jun 2015 @ 04:16 PDTConnectivityAccess External Data - A Table UDFOne more thing. I have changed the variable file with my login credentials. Still it is refering the by defalt id and pass not sure why.   > test dbcinfo test dbcinfo Request No: 1 ...
1122 Jun 2015 @ 04:06 PDTConnectivityAccess External Data - A Table UDFI am not connecting with my Laptop. We have one Unix Test server. I created one dblink directory and installing in the same. This unix already have the Teradata connection (I means i can access the...
1019 Jun 2015 @ 02:09 PDTConnectivityAccess External Data - A Table UDFHi Sir, Thank you so much for your support to run the DbLink facility. I am following up the suggested steps to connect and fetch the details from teradata and Oracle. I am able to connecta dn pro...
919 Jun 2015 @ 12:16 PDTConnectivityAccess External Data - A Table UDFThanks for your help Sir. Now i am able to connect with client but not able to get the data from dblinkgetmeta function. How i will connect with Oracle using the same. I will describe more about t...
818 Jun 2015 @ 06:35 PDTConnectivityAccess External Data - A Table UDFWhile Client installation . iam getting these details.   java -jar DbLinkClient.jar -h 10.22.76.19 -o 1025 DbLink Client utility version 1.02.00.00 Type "exit" to exit. Type ...
718 Jun 2015 @ 11:56 PDTConnectivityAccess External Data - A Table UDFHi Sir, As suggested above by you. I tried to install the DbLink Client and it is throwing the below error: rthak14@spdma544:/idn/home/rthak14/rabi/dblink/DbLinkClient>java -jar DbLinkCli...
618 Jun 2015 @ 11:24 PDTConnectivityAccess External Data - A Table UDFHi Sir Thank you so much for your time spending to set up the DbLink facility. Really appreciated. I will follow the steps to setup the client as well and will update you with progress. Need help...
516 Jun 2015 @ 03:54 PDTConnectivityAccess External Data - A Table UDFToday i ahve make some progress to install the DbLinkserver. but it has been stuck on ready step. Not sure after that how i can install the DbLink Client and move forward. where i can check that DB...
415 Jun 2015 @ 11:51 PDTConnectivityAccess External Data - A Table UDFHi Sir, This is my kind request to please help me how i can install the DbbLink to coonect remote database and use effectivaly. I have the scenario. Oracle client has been install at my personal...
312 Jun 2015 @ 04:25 PDTConnectivityAccess External Data - A Table UDFFrom which location i can download the DbLinkManagerWeb.war files for Web based
212 Jun 2015 @ 03:45 PDTConnectivityAccess External Data - A Table UDFHi,   I am implementing the DBLink in Teradata. To query from Oracle. I have gone through all the given reference documents and process. Still I am facing to install the UDF. I am hoping for...

Pages