DSXchange

I Have query defined in Teradata enterprise stage as below: select trim( Fsc_Yr_Num-1 || '0101') as TIMEID from dev_user_view.cldr where cldr_dt = '#Current_Date#' '#Current_Date#' is a parameter which I am passing through sequencer. But the job aborts with below error : Teradata_Enterprise_24,0: AP...

Any can help?

Hi Thanks this solution is working.... but again i have issue when i am putting a where clause as


where CLDR_DT = CURRENT_DATE - 1

for this clause it fails.

Tried that, its not working.

Hi, Could you please suggest me how can I get current date if I am executing below Query in Teradata Enterprise stage. Query : SELECT PREV_YR_DT,DATE FROM cldr This query works fine in SQL editor but when I am executing in Teradata enterprise stage its failing. Is there any way to get Current Date t...

Thanks A lot this really helped.

Hi,

I am geting mail like this :

Hi, Sorry for wrong words, 1)I am getting error logs as below : SummaryArray = DSGetLogSummary(rJobHandle, DSJ.LOGFATAL, JobStartTime, JobEndTime, 0) these error logs captured in "SummaryArray" needs to pass to the below DSSendMail , which is not happeing here.... Mail = DSSendMail("F...

Hi , I have written a routine to extract the Fatal error logs and send it through mail. Routine is as follows : - $INCLUDE DSINCLUDE JOBCONTROL.H ***CallingProgName = DSJ.ME rJobHandle = DSAttachJob(Jobname, DSJ.ERRNONE) JobStartTime = DSGetJobInfo(rJobHandle, DSJ.JOBSTARTTIMESTAMP) JobEndTime = DSG...

Hi, I have simple job, Seq stage --> Trasformer --> Teradata. I am reading just one record from Seq file, I have manually edited the record, everything is perfect about the record.. Record :- "C",74236526445,"HORIZON",64.00,"EA","OZ","64 OZ",789788,&...

convert(char(00),"", ABCD)

This is working, thanks for your help.

sorry for the 20 previously mentioned..just downloaded another hex editor here its showing 00..this is the hex value

Hi, I am really sorry , I am not aware of this..How to do this?

Hi, I have a job where I am pulling data from VSAM using ODBC then trasformer and then finally loading into Teradata DB. for one of the column i am getting BOX character, In hex editor the value of BOX character is 20. I tried below functions, but nothing is working for me please help me out. functi...

Hi

My target source everything is 20 bytes...That is why I am wondering why this is happeing?