#DateForumTypeThreadPost
5914 Jan 2010 @ 11:15 PSTToolsReplyData byte count errorThe CLI 207 is not related to changes you made to the script. CLI 207 means CLI could not make a connection to the DBS (network is down, or something related to that; it is a catchall error code).A...
5814 Jan 2010 @ 03:48 PSTToolsReplyData byte count errorAlso, forgot to mention that when using "delimited" as a record format for the Dc operator, all columns in the schema definition must be of type VARCHAR. We will send the VARCHAR fields to Teradata...
5714 Jan 2010 @ 03:46 PSTToolsReplyData byte count errorOk, this might seem like a stupid question, but bears asking.The data you provided, was that the textual representation of the actual data?Or is that the exact format (text data with comma field se...
5613 Jan 2010 @ 01:52 PSTToolsReplyData byte count errorI believe we would need to see the script, a copy of the console messages and even the output of the first few records (in hex if you want) of the data.Cannot help with just this provided informati...
5507 Jan 2010 @ 06:12 PSTToolsReplyTPT BranchingRight now, TPT does not support what we refer to as "conditional job steps" (the ability to execute the various job steps in a multi-step script based on certain conditions). It is planned for a...
5417 Dec 2009 @ 11:56 PSTToolsReplyProblem in Creating Delimited Data file using FastExport.I believe you need to tell FastExport that you do NOT want indicators (I think FastExport exports the data with the indicator bytes), and I think you need to specify a record format of TEXT (I beli...
5316 Dec 2009 @ 03:22 PSTToolsReplyWildcard characters in MLoadOr use Teradata Parallel Transporter that can load multiple files at the same time in parallel, and accepts the wildcard syntax. :)
5216 Dec 2009 @ 03:21 PSTToolsReplyfastexport flat file data probI would check your data in Teradata.FastExport does not support the notion of outputting the data in VARTEXT format.Therefore, what you see is wha tthe data actually looked like when it was exporte...
5103 Dec 2009 @ 08:51 PSTToolsReplyerror 6760 and 2679Please provide script, sample of data, and table definition (DDL).
5003 Dec 2009 @ 08:50 PSTToolsReplyany one plz give me brief explain about this errorThe table named in the error message was:Duplicate unique prime key error in database.table_Log.The "_Log" is usually the naming convention people use to specify the restart log table.I do not thin...
4903 Dec 2009 @ 03:40 PSTToolsReplyError while loading multiple files in Teradata using Multiload.Please provide the entire script.Also, are the rows placed in the ET or UV error table?
4803 Dec 2009 @ 03:39 PSTToolsReplyany one plz give me brief explain about this errorThe error you are seeing is from MultiLoad trying to access or update the restart log table.This has nothing to do with the target, work, or error tables.Are you fully qualifying all of your table ...
4711 Nov 2009 @ 12:16 PSTToolsReplyFastload error in schedule jobI think more info is needed. What is a .CMD file? What are its contents? How is the job scheduled? Is it scheduled to execute that same .CMD file? Have you tried creating a .bat file with th...
4609 Nov 2009 @ 02:09 PSTToolsReplyTPT Script Multiple Table QuestionTPT supports the notion of job steps. Each job step is an independent load task.So, you can create a single TPT script with 10 load tasks in them, but if you wantthe tables all moved in parallel, y...
4509 Nov 2009 @ 02:07 PSTToolsReplyTeradata Fast Export and Fastload Scripting Syntaxhttp://www.info.teradata.com/DataWarehouse/eTeradata-BrowseBy.cfm
4409 Nov 2009 @ 02:05 PSTToolsReplyTPT And Mainframe Chanel Attached SystemsYou need to look at TPT the same way you would, say, FastLoad.TPT will connect to Teradata across the channel in the same way.So, if you are looking to move data between to Teradata systems, then y...
4304 Nov 2009 @ 05:13 PSTToolsReplyIn TPT UPSERT on a table with an Identity Column primary index is illegalLooking in the Teradata Messages manual, you will see this:5790 UPSERT on a table with an Identity Column primary index is illegal.Explanation: If the UPSERT table has an identity column as its pri...
4204 Nov 2009 @ 04:59 PSTToolsReplyIn TPT UPSERT on a table with an Identity Column primary index is illegalWhich operator are you using?Update?Stream?
4104 Nov 2009 @ 04:57 PSTToolsReplyTeradata TPT ScriptWe do understand that it would be nice to not have to specify a schema object in the script, and we are working towards that goal. If you have further questions on this, do not hesitate to ask, and...
4015 Oct 2009 @ 06:24 PDTToolsReplyFast Export & Fast loadingFastExport does not support the exporting of data in delimited format.I am sure that the column values were not separated by TAB whitespace characters.TEXT format just writes the data in a format t...
3916 Sep 2009 @ 03:50 PDTToolsReplySending data to Windows Named PipeWhen you created the pipe and you began the FastExport job, did you already have a reader attempting to read from the pipe prior to starting FastExport? I think that is the correct order. I thi...
3810 Sep 2009 @ 02:53 PDTToolsReplycommand issue in mloadSYSDAY is not a valid environment variable in your environment.The message is correct.Do not confuse "environment variable" with "pre-defined MultiLoad system variable".They are different things.Fo...
3710 Sep 2009 @ 02:41 PDTToolsReplyData Loading in Views using FastloadNo explanation needed. In case you were not aware, for the FastLoad protocol, there is special code that is executedboth on the client and on the database. Many of these restrictions are due to sof...
3610 Sep 2009 @ 02:38 PDTToolsReplyCAN I WRITE ERRORED RECORDS INTO A FILE IN MLOAD?The first item of importance is to not that the DISPLAY ERRORS and NOSTOP options only workwith VARTEXT records. It will not work with the binary formats.Next, the DISPLAY ERRORS option will indica...
3510 Sep 2009 @ 02:34 PDTToolsReplyI am loading the data into files using fastexport but...If the layout of the table consists of non-character fields (i.e. integer, decimal) then the datawill be returned to FastExport in binary format.If you want the data in text format, then you would ...

Pages