#DateForumTypeThreadPost
4626 Jul 2006 @ 02:48 PDTDatabaseReplyTDPID Vs AccountIDTDPID (the part before the slash) identifies the Teradata system to which you will connect (mapped via network hostname or mainframe subsystem ID).AcctID controls how resource usage will be grouped...
4526 Jul 2006 @ 02:40 PDTDatabaseReplyConvert Varbyte to CharacterActually the point of moving the data back to the original platform is that the data is NOT translated. (It remains in client format even in the error table field; that's why it's typed VARBYTE - s...
4426 Jul 2006 @ 02:11 PDTToolsReplyProblem faced while using FastLoadDefault for FastExport is MODE INDICATOR (null flag bits at the start of each record) but default for FastLoad is no INDICATORS.Either change the FastLoad.begin loading financial.customer_new Error...
4324 Jul 2006 @ 09:24 PDTDatabaseReplyConvert Varbyte to CharacterThe HOSTDATA column contains whatever bytes the client sent. If there is character data, it will be in the client characterset so using a UDF to (in effect) just declare it LATIN or UNICODE probabl...
4221 Jul 2006 @ 12:40 PDTAnalyticsReplyUsing Statistics WizardPrior to V2R6.1, you can't run Index Analysis or Statistics Analysis while Access Logging is enabled (for the user and/or objects in question).
4120 Jul 2006 @ 02:24 PDTDatabaseReplyrisk associated with dynamic sqlTo use SysExecSQL, the user that is the creator of the stored procedure must also be the immediate owner. Statements run via SysExecSQL use the access rights of that user, not the caller.There is t...
4020 Jul 2006 @ 01:49 PDTUDAReplyCould I stop an abort session?CANCEL ROLLBACK ON TABLE is not available prior to V2R5.1.
3920 Jul 2006 @ 01:19 PDTConnectivityReplyTrying to set up ODBC connectionThe driver download file is actually a self-extracting "bundle" that includes the appropriate TeraGSS and TDICU as well as the driver itself.
3819 Jul 2006 @ 01:43 PDTToolsReplyMLOAD VARTEXT FORMATTEXT or UNFORMAT don't recognize field delimiters, they are fixed format. If there are delimiters in exactly the same column position in every record, you could ignore them - either using explicit ...
3719 Jul 2006 @ 01:32 PDTUDAReplyNULLIf you don't COMPRESS, a NULL will occupy the same space on disk as blank or zero - e.g. for CHAR(10) that's 10 or 20 bytes (depends on the Character Set) plus an indicator bit in the rowheader.
3618 Jul 2006 @ 11:47 PDTToolsReplyMLOAD VARTEXT FORMATVARTEXT says the input file is delimited text. The input fields can then be converted/CAST to Teradata datatypes using standard SQL expressions or in some cases will be implicitly CAST by Teradata ...
3514 Jul 2006 @ 03:02 PDTToolsReplyBTEQ RUN FILE Warning messagePerhaps the wording could be better, but it's just an informational message that tells you BTEQ has exhausted the .RUN file and is going to resume reading commands from stdin. You can ignore the "W...
3414 Jul 2006 @ 02:55 PDTDatabaseReplyDelete first record in a tableThere is no "first" record in a normal table. Using SAMPLE 1 returns a single row, but there's no guarantee it will be the same row every time. If you want to delete a single row you must qualify i...
3312 Jul 2006 @ 05:56 PDTDatabaseReplyTables updated in last one hourThere is no built-in record of last time data content was changed.
3212 Jul 2006 @ 05:47 PDTDatabaseReplyProblems With Dynamic SQL ExecutionNote that to use DBC.SysExecSQL in a stored procedure, the creator of the SP (the username logging on to issue CREATE PROCEDURE) must be the same as the owner (database / user within which the SP i...
3111 Jul 2006 @ 01:22 PDTDatabaseReplyGuidance relating to secondary index and unique column constraintIf you want the DBMS to enforce uniqueness, a Unique Index is the price you have to pay. This is clearly documented.Without an index, enforcing the constraint "on the fly" during INSERT/UPDATE woul...
3007 Jul 2006 @ 06:31 PDTToolsReplyFastLoad Performance Tuning for large volumes of input dataIs the FastLoad running directly on one of the database (TPA) nodes or on a separate application server? Client CPU usage appears not to be an issue (1.44 seconds). Have you looked at disk I/O and ...
2928 Jun 2006 @ 02:57 PDTDatabaseReplyIs there an Equivilant Function to Execute in Teradata.CALL DBC.SysExecSQL('Update temp set temp.job = ''the date is '' ' || temp.startdate)Note that to use this feature, the "owner" of the SP (the database/user in which the procedure is defined) must ...
2827 Jun 2006 @ 01:02 PDTToolsReplyStored ProceduresIt's really not Stored Procedures that are the issue, it's the "cursor processing" you want to minimize. Whether you use embedded SQL in an application program or a Stored Procedure, cursor logic i...
2723 Jun 2006 @ 12:21 PDTToolsReplyUtilities downloadThere is no Teradata SQL Assistant 8.1 yet; I presume you mean the version included in the current TTU8.1 bundle - which would be SQL Assistant 7.1.If you have access to "My SupportLink" through Te...
2606 Jun 2006 @ 03:38 PDTConnectivityReply.Net driverThe .NET Data Provider requires CLIv2, which in turn will require tdicu and TeraGSS. The download from Teradata.com "Drivers and UDFs" area is a self-extracting ZIP that includes all necessary comp...
2502 Jun 2006 @ 03:51 PDTToolsReplyDate Comparisions - Differing formatsI think you are confusing external and internal representation. Is SOURCE_MONTHYEAR actually defined as DATE or is it CHAR that you know is supposed to represent a YYYYMM format date? The FORMAT sp...
2402 Jun 2006 @ 03:51 PDTToolsReplyDate Comparisions - Differing formatsI think you are confusing external and internal representation. Is SOURCE_MONTHYEAR actually defined as DATE or is it CHAR that you know is supposed to represent a YYYYMM format date? The FORMAT sp...
2325 May 2006 @ 10:26 PDTToolsReplyis it possible to display contents of a table through stored procedure?If the structure of the "returned" table is always the same, Global Temporary tables are easier to use for this purpose than Volatile tables. If the structure varies, CREATE VOLATILE TABLE ... AS ...
2224 May 2006 @ 05:19 PDTAnalyticsReplyHow to format the output in teradataUse CAST function within your SELECT, e.g.CAST(check_status AS CHAR(50))

Pages