#DateForumTypeThreadPost
1129 Jun 2009 @ 05:08 PDTUDATopicFast export in unix/opt/teradata/client/bin/fexp <<EOP .LOGTABLE load_work.datastore_log1 ; .LOGON BOX/userid,password;.BEGIN EXPORT SESSIONS 20;.EXPORT OUTFILE $path MODE RECORD FORMAT T...
1026 Jun 2009 @ 12:05 PDTUDAReplySeaching for particular databasesThanks guys.. but how do you check for length in where condition .. is there any .length() function or something in teradata?
925 Jun 2009 @ 05:37 PDTUDAReplySeaching for particular databasesThis does'nt work it returns resluts like VDWM0701_TRNSPT_MRG and so on..... :( ....
825 Jun 2009 @ 04:19 PDTUDATopicSeaching for particular databasesWe have this table dbc.columns which lists down all databases and the tables in our region... in this i have database series VDWM0908, VDWM0907, VDWM0906 and SO ON, the last 4 digits will be of an...
711 Jun 2009 @ 01:24 PDTUDAReplyuse teradata table field values in shell script?guys can some1 please help on this.. i have'nt got a solution yet.... all i need is to assign the value of the table to a shell variable for egbteq<< EOD.RUN FILE /home/nbk6cst/dbpass;select ...
609 Jun 2009 @ 02:59 PDTUDAReplyuse teradata table field values in shell script?here if i print only the table name gets printed right... ?.. i want the values of the row..
505 Jun 2009 @ 05:35 PDTUDATopicuse teradata table field values in shell script?i have to read some data from a teradata table and use them in my shell script.. how do i do that.. we can use BTEQ .. but i don know how to pass the field values as variables to the shell.. please...
409 Mar 2009 @ 12:08 PDTUDAReplyUsing relational operators for CHAR*bump*.....Man!!!! no one knows this????
302 Mar 2009 @ 09:05 PSTUDATopicUsing relational operators for CHARi wanna know how the reltional functions works out with CHAR EGSEL CASE WHEN '00t' > '003' THEN 1 ELSE 0 END returns 0 andSEL CASE WHEN '00t' > '030' THEN 1 ELSE 0 END returns 1why???
230 Jan 2009 @ 01:07 PSTDatabaseReplyInsert/Update in a single statementi cant find any proper material fro merge into .. can some1 enlighten me...?
127 Jan 2009 @ 04:51 PSTDatabaseTopicInsert/Update in a single statementCan i do these two statement in a single queryINSERT INTO ECR_RTL_ECAR_DEV.CTL_OPEN_DTSEL PROC_YYMM_DT,CCCP_KEY, CAST(CAST(CAST(ACC_OPEN_DT AS DATE FORMAT 'YYYYMM') AS CHAR(6)) AS INTEGER) as ACC_O...