All forum activity

#DateUserForumTypeThreadPost
39228 Feb 2006 @ 04:25 PSTpavan sriramToolsReplyFast ExportIf you want the file to be in readable format then use like this.BEGIN EXPORT SESSIONS 20; EXPORT OUTFILE OUTDD MODE RECORD; SELECT * from database1.table1;.END EXPORT;
39128 Feb 2006 @ 03:29 PSTTSToolsTopicFast ExportWhile using a fast export script, I am using FORMAT TEXT but the text file created is not in a readable format, what should be the used for formatting the text file?
39028 Feb 2006 @ 02:57 PSTpavan sriramToolsReplyLogfile in MLOAD You can use the log table in mload as below...RUN FILE LOGON or (LOGON TDP/username, ;-) .LOGTABLE Database1.Table1;.BEGIN IMPORT MLOAD TABLES &DB_NAME..&TBL_NAM...
38928 Feb 2006 @ 02:09 PSTKMToolsTopicLogfile in MLOADHi could someone please tell me, how to specify the LOG file in MLOAD , simillar to SQL*Loader in Oracle .Your help will be highly appreciated .
38828 Feb 2006 @ 12:50 PSTakhil.bansal@gmail.comDatabaseTopicScheduing a stored procedureHi,Is there is a way to schedule the execution of a Stored Prodecure or Macro in Teradata ?My basic requirement is to execute a Stored Procedure / Macro daily.Akhil-
38727 Feb 2006 @ 03:30 PSThhAnalyticsReplyhow to convert a period of D+30, D+60 etc to exact day and monthTry the sql extract month from date feature...
38627 Feb 2006 @ 09:20 PSTKMToolsTopicHow can I turn the DBS Start flag onNeedless to say I am kind of a beginner in Teradata.While trying a multiload it gave me the error restart is in progress (clueless about the message).Then I have shutdown the system with tpareset c...
38527 Feb 2006 @ 04:49 PSTjefAnalyticsTopichow to convert a period of D+30, D+60 etc to exact day and monthTo avoid hard codding the months in the ADS we have been Creating 4 ADSs with historical customers data for Churn with period of 30 days instead of calendar month: Day-30, D-60, D-90, and creating ...
38426 Feb 2006 @ 05:34 PSTpavan sriramToolsTopicFast load using the Bit IndicatorsHi all, Till now we are using the mload to load the data from flat file to empty table. Now we want to convert the script which will use the fastload utility to load the empty table by ad...
38324 Feb 2006 @ 02:28 PSTJim ChapmanDatabaseReplyNegative spool while monitoring SessionAre you using a very old version? Negative spool space problems were supposedly fixed a long time ago (V2R3.1).
38224 Feb 2006 @ 08:21 PSTBarry-1604DatabaseReplyDoubt regarding PPI....I believe that this was done to keep performance optimal on inserts/updates. If you could create a UPI that did not include the PPI column, then each insert (or update of the primary index columns...
38124 Feb 2006 @ 08:18 PSTlijuDatabaseReplynested case statementsAlso is there any limit on level of nesting possible?
38024 Feb 2006 @ 08:11 PSTlijuDatabaseReplynested case statementsIs this supported on tdv2r4 and above?
37924 Feb 2006 @ 08:02 PSTTD_ArchDatabaseReplynested case statementsYes, they are.Select case when "condition" then case when then ...This way, you can.
37824 Feb 2006 @ 07:24 PSTlijuDatabaseTopicnested case statementsHi,Are nested case statements supported in teradata?
37724 Feb 2006 @ 07:07 PSTSyed Mudassir Ali ShahDatabaseTopicDefine Teradata?Hello,i am new this word "Teradata", can anyone send a good link of TERADATA where i got information about teradata. thanksRegards,Mudassir
37624 Feb 2006 @ 05:28 PSTvarun-2294DatabaseReplyDoubt regarding PPI....Hi,I just want to know why this is so...
37524 Feb 2006 @ 05:16 PSTRK185088DatabaseReplyDoubt regarding PPI....If PPI is not a column of the PI, then the PI must be a Non-Unique Primary Index (NUPI). So, what you want the statement above is right, do you want to change it from NUPI to other thing or you wan...
37424 Feb 2006 @ 04:21 PSTvarun-2294DatabaseTopicDoubt regarding PPI....Hi,I have some doubt in PPI....If PPI is not a column of the PI, then the PI must be a Non-Unique Primary Index (NUPI). Can some one explain the logic behind this concept in detail....
37324 Feb 2006 @ 01:24 PSTvarun-2294DatabaseTopicdoesn't have access to create a stored procedureHi ,I am trying to create a stored procedure in my own database but it giving me this error :SPL1040:E(L2), Invalid definition for stored procedure 'E(3524):The user does not have CREATE PROCEDURE ...
37224 Feb 2006 @ 12:51 PSTRK185088DatabaseTopicNegative spool while monitoring SessionHi All, I regularly monitor session information from Teradata Manager, I always see some sessions showing negative spool ...There are good amount of spool space available to the user, who is using ...
37123 Feb 2006 @ 11:47 PSTGreatSushantDatabaseReplyWhy the follwing query is getting lockedSee every time this query is only getting locked since during the single user operation also here if i want to get rid from this locking issue what step should i perform
37023 Feb 2006 @ 05:01 PSTsethiyaguToolsReplyBteq in Report formatHi Manoj,Please follow the steps to meet your requirements, you may specify file command in export rather than report command(as you have already mentioned "changing the report in "REPORT" Format t...
36923 Feb 2006 @ 03:34 PSTsdk2006DatabaseTopicinsert multichar delimited file with BTEQI am trying to load a file with delimiter which is multi character. I was successfully able to load a file with single character as the delimiter, but couldnt load using mutliple character delimite...
36823 Feb 2006 @ 10:44 PSTBarry-1604ToolsReplyBteq in Report formatIf you want the results to be like "export report", but without the titles, etc., do the following:1) Do a ".set format off" in bteq2) Do a ".set titledashes off" in bteq3) After each column, put a...

Pages