129 | 11 Mar 2016 @ 01:48 PST | Tools | Reply | Calling BTEQ with file within PowerShell | Happened to me too I use the Powershell "cat" command
cat myfile.btq | bteq
|
128 | 13 Feb 2016 @ 01:27 PST | Database | Reply | Select Columns for UPI,NUPI,USI and NUSI | There is an elaborate explanation in the Database Design document for your database version:
B035-1094-151K
is for V15.10
|
127 | 13 Feb 2016 @ 01:25 PST | Database | Reply | How 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
|
126 | 13 Feb 2016 @ 01:22 PST | Database | Reply | char(23) to timestamp(6) | Would using a CASE statement skip this problem?
case column
when is null then null
else cast(...)
end
|
125 | 27 Nov 2015 @ 03:20 PST | Cloud Computing | Reply | Teradata 15.10.0.7 Express Vmware: Viewpoint fails to add Teradata account | Excellent - went to monitored systems and added localhost and it was all good. Previously it was setup I think. Works fine now - thankyou.
|
124 | 27 Nov 2015 @ 05:25 PST | Cloud Computing | Topic | Teradata 15.10.0.7 Express Vmware: Viewpoint fails to add Teradata account | Hey 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... |
123 | 07 Sep 2015 @ 08:45 PDT | Tools | Topic | BTEQ export output and including a newline between concatenated text | Hello 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... |
122 | 06 Sep 2015 @ 03:49 PDT | Database | Reply | Stored Procedure (SELECTION FORM) EXPLAIN/SHOW/HELP | Thanks for the followup Dieter. I'll do some more reading on Embedded SQL.
|
121 | 05 Sep 2015 @ 03:45 PDT | Database | Reply | Stored Procedure (SELECTION FORM) EXPLAIN/SHOW/HELP | Yes 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... |
120 | 05 Sep 2015 @ 07:24 PDT | Database | Topic | Stored 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... |
119 | 03 Sep 2015 @ 02:39 PDT | Cloud Computing | Reply | zypper asks for DVD when installing software | Nevermind 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-... |
118 | 03 Sep 2015 @ 02:25 PDT | Cloud Computing | Topic | zypper asks for DVD when installing software | I 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... |
117 | 03 Sep 2015 @ 01:44 PDT | Cloud Computing | Reply | Login credentials for VM | linux: 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... |
116 | 03 Sep 2015 @ 01:31 PDT | Cloud Computing | Reply | EVM connectivity issue | connect to a hardline or reset your router. It's a hardware thing generally.
|
115 | 03 Sep 2015 @ 01:29 PDT | Cloud Computing | Reply | Patching TDE 14.0.0.1 AWS image | Great 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... |
114 | 03 Sep 2015 @ 01:25 PDT | Cloud Computing | Reply | test 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... |
113 | 03 Sep 2015 @ 01:05 PDT | Cloud Computing | Reply | Teradata Express 14.10 for VMWare | ps you'll need a full restart to reset this:
shutdown -r 0
|
112 | 03 Sep 2015 @ 01:04 PDT | Cloud Computing | Reply | Teradata 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... |
111 | 03 Sep 2015 @ 12:58 PDT | Cloud Computing | Reply | Unable to create Teradata Connection Profile in VMWARE Image to start TD StudioExpress Sql Assistant | drop 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... |
110 | 29 Aug 2015 @ 11:40 PDT | Database | Topic | Submitting 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... |
109 | 14 Jul 2015 @ 05:28 PDT | Training | Topic | android 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? |
108 | 11 Jul 2015 @ 11:52 PDT | Database | Reply | Join indexes with Curent_date or Current_timestamp | That makes sense. So it needs to be part of a batch process each :) thanks fred!
|
107 | 04 Jul 2015 @ 10:52 PDT | Database | Topic | Join indexes with Curent_date or Current_timestamp | referencing 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... |
106 | 09 Jun 2015 @ 05:03 PDT | General | Reply | Starting Ferret utility in teradata 13.10 | Addendum in TD15 you get a remote prompt portlet and you can edit commands in that - much simpler :)
|
105 | 09 Jun 2015 @ 05:02 PDT | General | Reply | Starting Ferret utility in teradata 13.10 | from 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... |