725 Jun 2009 @ 05:12 PDTUDAReplySeaching for particular databasesHiTry using between function in the where clause.Ex. where databasename between 'VDWM0000' and 'VDWM9999'
608 Jun 2009 @ 06:06 PDTDatabaseReplyRounding down 2.50 to 2See if this works.select CAST((value + 0.49) AS INTEGER) new_value
504 Jun 2009 @ 04:16 PDTDatabaseReplyQuery to find out the table name and the columns of that table associated with a viewThe 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...
403 Jun 2009 @ 08:25 PDTUDAReplyExecuting teradata procedures in unix shell scriptsbteq << EOF.logon $SERV/$USERNAME,$PASSWORDcall 'procedure name()' .quitEOF
329 May 2009 @ 06:00 PDTDatabaseReplyHelp with SQL queryHiIf you just need one sample ouput for a combination, you can use sample function.select * from tablename where col=value sample 1;
221 May 2009 @ 05:53 PDTToolsReplyfastexport issue - getting junksHiThanks 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.
119 May 2009 @ 04:16 PDTToolsTopicfastexport issue - getting junksHi,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...