#DateForumTypeThreadPost
1516 Aug 2016 @ 07:30 PDTToolsReplyTPT - Instances Vs SessionsThanks Steve! It looks like FileReaderMultipleReaders = 'Yes' works.
1416 Aug 2016 @ 01:00 PDTToolsReplyTPT - Instances Vs SessionsThanks for responding Steve.  I set the jobvars file as such.  Am I setting it in the wrong place? ,MultipleReaders = 'yes' ,LoadInstances     = 3 ,... ,ReaderInstan...
1316 Aug 2016 @ 07:03 PDTToolsReplyTPT - Instances Vs SessionsHello, I have seen a few posts that indicate multiple instances can be used to read from a SINGLE file.  I have some rather large files, but the log (below) shows the 2nd and 3rd instances ar...
1228 Jul 2016 @ 07:18 PDTDatabaseReplySet unix variable inside bteqI meant to mention that the ". param_file_path" results in a error of " *** Error: Unrecognized command.".  I do believe this would be a much more elegant solution if ...
1128 Jul 2016 @ 05:57 PDTDatabaseReplySet unix variable inside bteqI have seen a similar post here a couple times as to using this parameter file, yet I can't find any mention of it in the BTEQ manual, nor can I get anything like it to work.  Is this some...
1029 Jun 2016 @ 10:41 PDTToolsReplyTPT load failure on Interval datatype - Error code 7452I just reformatted and replaced the plus sign when pulling data out of ORacle as such: ,REPLACE(TO_CHAR(CAST(MAX_HOURS as interval day( 4) to second( 6))),'+',null) ...
928 Jun 2016 @ 09:35 PDTToolsReplyTPT load failure on Interval datatype - Error code 7452It actually loads if data is formatted without the plus (+).  Negative works.  I am not sure why, but looks like I will have to replace the plus with null when I pull from Oracle.  S...
828 Jun 2016 @ 02:44 PDTToolsTopicTPT load failure on Interval datatype - Error code 7452Any assistance would be welcomed.  I cannot seem to put the Interval in a format that Teradata likes.  The column data looks like "00 02:00:00.000000".  We are extracting i...
720 May 2016 @ 12:11 PDTToolsReplyTPT: Target Database different than Working Database with LOAD operatorI was also hoping to get this answered.  I hope it is possible. To the person posting, did anyone ever respond?   Thanks
618 Mar 2016 @ 12:04 PDTTeradata StudioReplyUsing SQL History tab slows Studio to a crawlThanks Francine for your help.  I ended up uninstalling and reinstalling.  I believe something got messed up during the install.  I am not sure what happened, but at the time, I did ...
517 Mar 2016 @ 03:19 PDTTeradata StudioReplyUsing SQL History tab slows Studio to a crawlSo you know what I tried.  I first exported the old SQL History.  I created a SQLA directory in my StudioWorkspace directory and then ran the TeradataStudio command to change the workspac...
417 Mar 2016 @ 02:50 PDTTeradata StudioReplyUsing SQL History tab slows Studio to a crawlI did not clear my SQL History.  Should I?  IT will scroll fast if its is empty.  :-)  I only have 106 rows in it.  I see where the projects are stored in the StudioWorkspa...
317 Mar 2016 @ 02:24 PDTTeradata StudioReplyUsing SQL History tab slows Studio to a crawlI am working directly on my Macbook and it should all be local.  The only anomoly, as mentioned earlier, is that we are pointing at a VM for the interim.  Is there a setting as to where t...
217 Mar 2016 @ 02:08 PDTTeradata StudioReplyUsing SQL History tab slows Studio to a crawlNo effect.  I now have admin rights to my Mac and made the changes suggested in this exchange with regard to Java temp files as shown above.  Traversing the SQL History is still painfully...
116 Mar 2016 @ 04:03 PDTTeradata StudioReplyUsing SQL History tab slows Studio to a crawlHello, I've had tremendous slow downs using Teradata Studio on a Macbook Pro (brand new) with 16 GB of memory on OS X Yosemite Version 10.10.5.  Sometimes it is the editor and sometimes t...