#DateForumTypeThreadPost
1631 Mar 2015 @ 08:05 PDTDatabaseReplyNeed query for thisCan you give more details please?  if it is in the same table you can do a delete.
1531 Mar 2015 @ 06:27 PDTDatabaseReplyPL/SQL to a valid ProcedureFound it. Thank you for watching.
1430 Mar 2015 @ 01:24 PDTDatabaseTopicPL/SQL to a valid ProcedureHi experts. Could anyone convert this PL/SQL to a valid Teradata Procedure: whenever sqlerror exit sql.sqlcode; SET serveroutput ON; Declare vRowid varchar2(100); vN.GES%TYPE; CURSOR VJE ...
1319 Mar 2015 @ 07:21 PDTToolsReplyFileds shifted in the database using TPTHello everyone. Hello feinholz, ulrich. I get back the project with the same problem of shifted fields.  feinholz: i added the attribut ReportModeOn='Y' in TYPE SELECTOR  ...
1203 Mar 2015 @ 06:48 PSTDatabaseReplySQL helpDid you try to use an inner join instead of Cross join?
1125 Feb 2015 @ 07:54 PSTDatabaseReplySQL that shows current queriesThank you, However i need a query to show me all the current querries without using ViewPoint if its possible.  
1024 Feb 2015 @ 02:00 PSTDatabaseTopicSQL that shows current queriesGood morning, I would like to know if there is a SQL that shows all the queries that are currentely running. We used to have that SQL query in Oracle. I wonder if there is such a SQL in Teradata? ...
920 Feb 2015 @ 04:09 PSTToolsReplyFileds shifted in the database using TPT Thank you all. This project get out of my hands and my boss prefered to deliver it. So i could not be aware of the changes that will be made on tpy script. In anycase thanks...
817 Feb 2015 @ 02:58 PSTToolsReplyFileds shifted in the database using TPTThank you for your suggestion. Just to add something which may help, the data comes with the same problem from the flat file to the temporary table( i checked it). Could it be an attribut of the T...
717 Feb 2015 @ 01:20 PSTToolsReplyFileds shifted in the database using TPTHello below is my TPT script: /*USING CHAR SET UTF8*/ DEFINE JOB MyJob_jb   DESCRIPTION 'Loading'   (         DEFINE OPERATOR LOAD_ALL ...
616 Feb 2015 @ 06:18 PSTToolsReplyFileds shifted in the database using TPTHello ulrich, Thank you for your answer, however i cannot share the TPT script, but i can tell you an example of what i have in the row of the flat file which causes the problem : ID &n...
514 Feb 2015 @ 07:44 PSTToolsTopicFileds shifted in the database using TPTHello everybody, I have a huge problem loading data from a flat file to Teradata DB. What happen is that the data loads correctely in the DB except some rows which their fields contain a string w...
408 Jan 2015 @ 02:54 PSTToolsTopicIssue with my first Teradata PTHi everybody, I used the sample scripts that come with Teradata client for my first script. What i succed to do is to create an empty table using these 2 scripts: 1*First script of configuration...
307 Jan 2015 @ 08:10 PSTDatabaseTopicLock on Teradata tablesGood morning, I'm having locks on my Teradata tables when i have another one connecting to my database which is annoying, so that lead me to create and work with views. Is there a way to...
207 Jan 2015 @ 12:55 PSTToolsReplyTeradata tptThank you so much Steve, i'm going to check the website you gave me. For further informations i'm going to email.  
106 Jan 2015 @ 10:24 PSTToolsReplyTeradata tptHi Steve, hi everybody. Our company is switching from Oracle to Teradata and to tell you the truth i'm getting confused to work with TPT script instead of SQL LOADER . Please if you can show ...