#DateForumTypeThreadPost
1220 Jan 2006 @ 09:20 PSTDatabaseReplyCan a teradata database trigger/stored procedure call a java program or Executable?But ODBC runs on UNIX.You can download the ODBC driver for Teradata for SOLARIS, LINUX, HPUX, AIX from http://www.teradata.com/t/page/130536Like I said you can try writing C Wrapper functions...
1120 Jan 2006 @ 12:10 PSTTrainingReplyBTEQ sample scriptsIf you install the DEMO APPLICATIONS off the DEMO CD you will find all the scripts for all the DEMO apss here.c:\Program Files\NCR\Teradata For Microsoft Windows Demo\bin
1020 Jan 2006 @ 12:04 PSTDatabaseReplyCan a teradata database trigger/stored procedure call a java program or Executable?Sorry We don't support native Java functions. Can you re write the Java function in 'C' using ODBC or something? V2r6 allows you to write TABLE UDFS where your UDF can return a set of ROWS one...
919 Jan 2006 @ 10:57 PSTDatabaseReplyCan a teradata database trigger/stored procedure call a java program or Executable?UDF or Stored procedure? Teradata Stored procedures follow the ANSI standard and have a specific language as per the ANSI standard. Not C, Not Java, it is called Stored Procedure Language. It...
817 Jan 2006 @ 07:25 PSTToolsReplyUnlocking tables after fastload failurePlease see this other thread on the same subject....http://www.teradata.com/teradataForum/shwmessage.aspx?forumid=10&messageid=2703
717 Jan 2006 @ 06:26 PSTDatabaseReplyARCHIVE DatabaseARCHIVE is a separate program from BTEQ on Teradata. it is called ARCMAIN.Here are the directions that come wit the Teradata Demo CD about archiving the database. I updated it to match what you...
612 Jan 2006 @ 11:46 PSTConnectivityReplyWhy username and password need to be passed with dataSource.getConnection()You need to set up Some sort of Single Sign on or other Mutual Authentication method on the Teradata system.What OS type are your Teradata Database nodes and what version of software are you ...
511 Jan 2006 @ 06:14 PSTDatabaseReplyrenaming a column name.....?Can you give us the Layout of the table currently? And maybe some made up sample data and explain how you want the layout changed?You could try renaming the column on the select.In ANSI sql you ca...
408 Jan 2006 @ 11:15 PSTDatabaseReplyCancel online transaction recovery after break big delete operationAnd then even then it is a IFFY proposition. you might try a COLDWAIT RESTARTvprocmanagerset restartkind = coldwaitquittpareset "to do a cold wait"what this does is allow the system to complete ...
303 Jan 2006 @ 11:53 PSTDatabaseReplytable size without indexesYou can run ferret from Teradata Manager.
202 Jan 2006 @ 03:36 PSTDatabaseReplyUnion query 2616 errorMake them the same type..sel cast(127 as Integer) from customerunionsel cast(131 as Integer) from customer;
102 Jan 2006 @ 03:33 PSTDatabaseReplytable size without indexesFrom screen 6 of the DBW program. start ferretthis will start the Ferret application in one of the DBW application windows.at the ferret prompt typescope table "mydatabase.mytable" 0showblocks qu...