Search results for query: *

I have a 10 character date field that I need to cast to a teradata date. The table field is begin_date char(10) and has values of 2001-01-10, 2009-07-19 etc. Suggestions?

I am loading a teradtata table, using varchar, with a delimited flat file (300 columns, 11 mil rows). The data is delimited with a quoted pipe. "|". an example of some of the rows. "id1 "|"name1"|"payrate1"|"..."|"col300" . . . "id-n "|"name-n "|"payrateN "|"..."|"col300 " The data...

the main problem is that there are less rows in table a, (approx 650k) as opposed to tableb (1 million or so)

I have 2 tables, each has a date as a primary index. The dates are NOT unique! for example data might look like Tablea 2008/01/31 col2 col3 2008/01/31 col2 col3 2008/01/31 col2 col3 2007/12/31 col2 col3 2007/12/31 col2 col3 . . Tableb 2008/01/31 col2 col3 2008/01/31 col2 col3...

I am running a program in teradata sql in SAS using proc sql. I am creating a month end date that I need to use as a primary index later in the program here is an example proc sql exec noerrorstop; connect to teradata (tdpid=xxxx database='dbname' SERVER=xxxx username=xxxxxxx...