InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 11 Oct 2008 02:37:44 GMT20http://www.teradata.com/teradataforum/Topic10981-5-1.aspxYou might want to investigate DATA export mode.The syntax is something like: .EXPORT DATA FILE = filenameIf I recall correcting, the resulting row in the export file starts with 2 byte row length field and the row ends with 0A or 0D byte . VarByte data type also starts with a two byte field length. Therefore the VarByte field starts at offset 4.Thu, 20 Mar 2008 12:52:15 GMTShawhttp://www.teradata.com/teradataforum/Topic10981-5-1.aspxHi , What is the process of retrieving the column value whose datatype is varbyte in bteq script.For example I have a table ABC having a column bcd as varbyte(64000).In this column one .dat file is stored which contains some records.Now I want to retrieve the same column value into a file using the select queryselect bcd from abc;RegardsSanjayWed, 19 Mar 2008 03:05:39 GMTDhanchik