Tags for format
Problem in exporting data from BTQ to CSV
Hello,   I am running a BTQ script which is generating a .CSV file. One of the column in the file is a number but datatype for the same in the parent table is defined as CHAR. I am using a cast function to convert it into bigint( number is 13 digits long), results are fine when I am running this query in SQL Assiatant.
BTQ csv format cast
Varchar to Timestamp(6) conversion
My customer has loaded a TD test table with a date & time column that looks like this: Column:      XXXXXX   varchar(23)  Data: 7/31/2014 9\:20\:03 AM 8/4/2014 8\:23\:15 AM 12/6/2014 2\:31\:07 PM    What is the quickest/easiest way to convert the data to TIMESTAMP(6),  if possible at all ?   
timestamp format conversion cast
queries on casting in teradata
Hi, I am a newbie in teradata and so am not familiar with casting/ formatting concepts... can you please clarify the below queries... 1. I have an export using below syntax
bteq format cast
2620: The format or data contains a bad character
Hello I keep getting the above error message after the query below has been running for a minute or so. I looked at this part... left join (select CCT_External_ID, CCT_Agent_ID from GDW_VIEWS. CCT_AGENT where CCT_External_ID between '0' and '999999') Rep_Trans_IDs on Rep_Emp_IDs.emp_id=Rep_Trans_IDs.CCT_External_ID  
2620 error format bad character
Get DDL from DBC tables
Hi everyone, I'm tryng to build a set of queries with the objective of getting the DDL of tables only from the info inside the dbc tables (columns, tvm, dbase, tableconstraints...). I started from the table dbc.columns to get all the info about every field of a table. Below you can find the work in progress query.
ddl dictionary dbc format columns
Hi All, I want to select the current_timestamp in a specific format 'YYYYMMDDHH24MISS'. Can you please let me know how I should go about it?
MODE and FORMAT - TD Utilities.
Hi Folks,  Can anyone explain the significance of MODE and FORMAT in Utilities like Fast Export and Multi load ? And what are the various MODE and FORMAT are avilable at this end ? I have seen some scenario's where RECORD has been used as MODE.
format mode fast export multiload
Remove of Period '.' from my concatnated string.
I want to remove periods from the concatenated string. Please help as I tried all options inlcuding Cast, Format etc.   My query is SEL CONCAT(id, rec_num, line_no, dep_no, asp_num, pr_num) as mystr from table_oemsp   I get the output as mystr 0.0.300.900.0 etc.  
concat format period string SPECIAL CHARACTER
Casting timestamp to date and to char
Hi all,
timestamp format cast char
Issue with Decimal(38,0) data type in BTEQ
Hi, I am trying to export data from a table in which one column  has a data type of Decimal(38,0).   Query: select sa from aa;Result: When I run the select statement in SQL assistant....the output is fine....like below   sa
format decimal(38 0)