| 394 | 28 Feb 2006 @ 07:20 PST | TDUser-781 | Tools | Reply | Fast Export | Hi,in order to have a readable output you have to cast as char and concat all the fields you are exporting.Like this:SELECT cast((cast(cust_id as char(xx))||cast(acct_nbr as char(xx))||cast(minimum... |
| 393 | 28 Feb 2006 @ 06:16 PST | TS | Tools | Reply | Fast Export | The following is the code which is being executed, still the output is not in the correct format..LOGTABLE db.datastore_log ;.logon;.BEGIN EXPORT SESSIONS 20 TENACITY 5 SLEEP 1;.EXPORT OUTFILE c:\O... |
| 392 | 28 Feb 2006 @ 04:25 PST | pavan sriram | Tools | Reply | Fast Export | If 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; |
| 391 | 28 Feb 2006 @ 03:29 PST | TS | Tools | Topic | Fast Export | While 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? |
| 390 | 28 Feb 2006 @ 02:57 PST | pavan sriram | Tools | Reply | Logfile 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... |
| 389 | 28 Feb 2006 @ 02:09 PST | KM | Tools | Topic | Logfile in MLOAD | Hi 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 . |
| 388 | 28 Feb 2006 @ 12:50 PST | akhil.bansal@gmail.com | Database | Topic | Scheduing a stored procedure | Hi,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- |
| 387 | 27 Feb 2006 @ 03:30 PST | hh | Analytics | Reply | how to convert a period of D+30, D+60 etc to exact day and month | Try the sql extract month from date feature... |
| 386 | 27 Feb 2006 @ 09:20 PST | KM | Tools | Topic | How can I turn the DBS Start flag on | Needless 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... |
| 385 | 27 Feb 2006 @ 04:49 PST | jef | Analytics | Topic | how to convert a period of D+30, D+60 etc to exact day and month | To 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 ... |
| 384 | 26 Feb 2006 @ 05:34 PST | pavan sriram | Tools | Topic | Fast load using the Bit Indicators | Hi 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... |
| 383 | 24 Feb 2006 @ 02:28 PST | Jim Chapman | Database | Reply | Negative spool while monitoring Session | Are you using a very old version? Negative spool space problems were supposedly fixed a long time ago (V2R3.1). |
| 382 | 24 Feb 2006 @ 08:21 PST | Barry-1604 | Database | Reply | Doubt 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... |
| 381 | 24 Feb 2006 @ 08:18 PST | liju | Database | Reply | nested case statements | Also is there any limit on level of nesting possible? |
| 380 | 24 Feb 2006 @ 08:11 PST | liju | Database | Reply | nested case statements | Is this supported on tdv2r4 and above? |
| 379 | 24 Feb 2006 @ 08:02 PST | TD_Arch | Database | Reply | nested case statements | Yes, they are.Select case when "condition" then case when then ...This way, you can. |
| 378 | 24 Feb 2006 @ 07:24 PST | liju | Database | Topic | nested case statements | Hi,Are nested case statements supported in teradata? |
| 377 | 24 Feb 2006 @ 07:07 PST | Syed Mudassir Ali Shah | Database | Topic | Define Teradata? | Hello,i am new this word "Teradata", can anyone send a good link of TERADATA where i got information about teradata. thanksRegards,Mudassir |
| 376 | 24 Feb 2006 @ 05:28 PST | varun-2294 | Database | Reply | Doubt regarding PPI.... | Hi,I just want to know why this is so... |
| 375 | 24 Feb 2006 @ 05:16 PST | RK185088 | Database | Reply | Doubt 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... |
| 374 | 24 Feb 2006 @ 04:21 PST | varun-2294 | Database | Topic | Doubt 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.... |
| 373 | 24 Feb 2006 @ 01:24 PST | varun-2294 | Database | Topic | doesn't have access to create a stored procedure | Hi ,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 ... |
| 372 | 24 Feb 2006 @ 12:51 PST | RK185088 | Database | Topic | Negative spool while monitoring Session | Hi 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 ... |
| 371 | 23 Feb 2006 @ 11:47 PST | GreatSushant | Database | Reply | Why the follwing query is getting locked | See 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 |
| 370 | 23 Feb 2006 @ 05:01 PST | sethiyagu | Tools | Reply | Bteq in Report format | Hi 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... |
