# | Date | Forum | Type | Thread | Post |
---|---|---|---|---|---|
7 | 25 Jun 2009 @ 05:12 PDT | UDA | Reply | Seaching for particular databases | HiTry using between function in the where clause.Ex. where databasename between 'VDWM0000' and 'VDWM9999' |
6 | 08 Jun 2009 @ 06:06 PDT | Database | Reply | Rounding down 2.50 to 2 | See if this works.select CAST((value + 0.49) AS INTEGER) new_value |
5 | 04 Jun 2009 @ 04:16 PDT | Database | Reply | Query to find out the table name and the columns of that table associated with a view | The below query will give you all the view & column names associated with a table. Substitute your databasename & tablename in the 'where condition' and see if this works.SELECT T.DatabaseName,T.ta... |
4 | 03 Jun 2009 @ 08:25 PDT | UDA | Reply | Executing teradata procedures in unix shell scripts | bteq << EOF.logon $SERV/$USERNAME,$PASSWORDcall 'procedure name()' .quitEOF |
3 | 29 May 2009 @ 06:00 PDT | Database | Reply | Help with SQL query | HiIf you just need one sample ouput for a combination, you can use sample function.select * from tablename where col=value sample 1; |
2 | 21 May 2009 @ 05:53 PDT | Tools | Reply | fastexport issue - getting junks | HiThanks for your reply! Thats a good solution but our requirement is to keep the field type as varchar. Anyways we have fixed the output file junks by using dynamic sort in mainframe. |
1 | 19 May 2009 @ 04:16 PDT | Tools | Topic | fastexport issue - getting junks | Hi,I have been trying to export xml data using fast export. My script is working fine. But i could see some junk character at the beginning of each line in my output file. When i try to export with... |