DSXchange

I got 19 asterisk characters "*******************"

I think the problem is the date format which has dd-mon-yyyy and I don't know how to convert that to yyyy-mm-dd, the StringtoTimeStamp expects a format of yyyy-mm-dd for the date.


Thanks,
Michael

Hi, I have a datetime field defined as a varchar(20) and I need to convert it to a timestamp. The data coming in is from Teradata and is as follows: 10-MAY-2006 12:00:00 need to convert as 2006-05-10 12:00:00 I tried using StringToTimeStamp, but no luck. Any ideas how I can accomplish this? Thanks, ...

Brad,

I couldn't find any of the functions you mentioned in the buildops. I would like to use the function or transform in the transformer stage if they are available.

Thanks,

Michael

Hi,

Is there a tranform in Parallel Server that does the same thing as DateCurrentGMTTime transform in Server? I need to get the currrent timestamp in GMT in Parallel Server.

Thanks.

Hi, I'm trying to use the user-defined SQL query file in the BEFORE SQL tab with Teradata database (via ODBC). I have a DRS stage that calls the query file as I specifed in the SQL -> Before tab: FILE=/export/home/test.sql the test.sql has two delete statements with two semicolons at the end of each...