#DateForumTypeThreadPost
12911 Mar 2016 @ 01:48 PSTToolsReplyCalling BTEQ with file within PowerShellHappened to me too I use the Powershell "cat" command cat myfile.btq | bteq  
12813 Feb 2016 @ 01:27 PSTDatabaseReplySelect Columns for UPI,NUPI,USI and NUSIThere is an elaborate explanation in the Database Design document for your database version: B035-1094-151K is for V15.10  
12713 Feb 2016 @ 01:25 PSTDatabaseReplyHow do I do the initial connection setup in Teradata and How to create a database?You're simply running the VMware image yes? http://developer.teradata.com/database/articles/introduction-to-teradata-express-for-vmware-player  
12613 Feb 2016 @ 01:22 PSTDatabaseReplychar(23) to timestamp(6)Would using a CASE statement skip this problem? case column when is null then null else cast(...) end  
12527 Nov 2015 @ 03:20 PSTCloud ComputingReplyTeradata 15.10.0.7 Express Vmware: Viewpoint fails to add Teradata accountExcellent - went to monitored systems and added localhost and it was all good. Previously it was setup I think. Works fine now - thankyou.
12427 Nov 2015 @ 05:25 PSTCloud ComputingTopicTeradata 15.10.0.7 Express Vmware: Viewpoint fails to add Teradata accountHey guys, got my hands on TD15.10_SLES11_vp vmware today and had trouble adding a teradata account to viewpoint when it requires the Authentication Mechanism drop down to be chosen. Unfortunatly th...
12307 Sep 2015 @ 08:45 PDTToolsTopicBTEQ export output and including a newline between concatenated textHello Team, I'm trying to run a BTEQ export script to file to generate another BTEQ file. .EXPORT REPORT FILE='xxx.btq' causes all newlines to be flattened/smooshed onto one line .E...
12206 Sep 2015 @ 03:49 PDTDatabaseReplyStored Procedure (SELECTION FORM) EXPLAIN/SHOW/HELPThanks for the followup Dieter. I'll do some more reading on Embedded SQL.
12105 Sep 2015 @ 03:45 PDTDatabaseReplyStored Procedure (SELECTION FORM) EXPLAIN/SHOW/HELPYes but this seems a contradiction from the manual here: http://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/index.html#page/SQL_Reference/B035_1148_112A/ch03.149.063.html and here: http://www.in...
12005 Sep 2015 @ 07:24 PDTDatabaseTopicStored Procedure (SELECTION FORM) EXPLAIN/SHOW/HELP The documentation for 14 and 15 says that the following should be possible but I cannot get it to work. Any suggestions team? REPLACE PROCEDURE financial.showObject() DYNAMIC RES...
11903 Sep 2015 @ 02:39 PDTCloud ComputingReplyzypper asks for DVD when installing softwareNevermind I've found one for the DVD's here and it might be what I need: http://mirror.linux.or.id/linux/SLES/SLES-11-SP1-DVD-x86_64-GM-DVD1.iso http://mirror.linux.or.id/linux/SLES/SLES-...
11803 Sep 2015 @ 02:25 PDTCloud ComputingTopiczypper asks for DVD when installing softwareI am using TD15 on sles11, and I cannot install other software like GIT because of dependencies on software needed from SLES Enterprise repository that exists on the DVD the express VM was made fro...
11703 Sep 2015 @ 01:44 PDTCloud ComputingReplyLogin credentials for VMlinux: root/root database: dbc/dbc for viewpoint you must start the server: (not available for SLES11 vm's still I think) /opt/teradata/viewpoint/portal/bin/viewpoint start hostname:80 admi...
11603 Sep 2015 @ 01:31 PDTCloud ComputingReplyEVM connectivity issueconnect to a hardline or reset your router. It's a hardware thing generally.
11503 Sep 2015 @ 01:29 PDTCloud ComputingReplyPatching TDE 14.0.0.1 AWS imageGreat question - I'm having difficulty getting access to SLES1 SP1 repos, as they're all saying "upgrade to SP2/SP3 etc. hence I can't install GIT natively from binaries due to mi...
11403 Sep 2015 @ 01:25 PDTCloud ComputingReplytest data/tables in Teradata Express 13.0 for VMware (4 GB)??in TD15 I have several DB's under "Samples", there's "retail", "financial" etc. Not sure about 13 run this and you'll get some datasets to play with: s...
11303 Sep 2015 @ 01:05 PDTCloud ComputingReplyTeradata Express 14.10 for VMWareps you'll need a full restart to reset this: shutdown -r 0  
11203 Sep 2015 @ 01:04 PDTCloud ComputingReplyTeradata Express 14.10 for VMWare"Moved" will ensure the hardware MAC address of the VM will remain the same this is important. "Copied" will cause the VMware tool to create a different MAC address and it will...
11103 Sep 2015 @ 12:58 PDTCloud ComputingReplyUnable to create Teradata Connection Profile in VMWARE Image to start TD StudioExpress Sql Assistantdrop into the virtual machine, and on a root prompt execute: ifconfig eth0 | sed -n '/inet addr:/s/.*inet addr:\([^ ]\+\)\s.*/\1/p' that'll give you the address of the machine you n...
11029 Aug 2015 @ 11:40 PDTDatabaseTopicSubmitting Procedures using BTEQ It seems the only way to submit a Stored Procedure using BTEQ is to execute the compile command, as I've had heaps of trouble trying to pump "Create Procedure..." straight into...
10914 Jul 2015 @ 05:28 PDTTrainingTopicandroid tcapp fails to connect to question pack. fails with google app error.High i have a Samsung Galaxy 4S and I'm unable to use the tcapp to download sample questions. Are other people having this problem?
10811 Jul 2015 @ 11:52 PDTDatabaseReplyJoin indexes with Curent_date or Current_timestampThat makes sense. So it needs to be part of a batch process each :) thanks fred!
10704 Jul 2015 @ 10:52 PDTDatabaseTopicJoin indexes with Curent_date or Current_timestampreferencing page 44 of the teradata 13.10 release summary, I noticed a new functionality that is difficult to conceptualise in how it achieves this: CREATE JOIN INDEX fin_idw.testdate_idx as SE...
10609 Jun 2015 @ 05:03 PDTGeneralReplyStarting Ferret utility in teradata 13.10Addendum in TD15 you get a remote prompt portlet and you can edit commands in that - much simpler :)
10509 Jun 2015 @ 05:02 PDTGeneralReplyStarting Ferret utility in teradata 13.10from the windowing desktop or with X11 forwarding (ssh -XC root@tdvm) you can execute: xdbw & that will bring up a graphical set of terminals. in the Supervisor window execute: start fer...

Pages