DSXchange

Source data type is Varchar

HI,
From source the values are coming like below
May 30 1967 12:00AM
Aug 2 1958 12:00AM
i need to convert in to timestamp like 1958-08-02 12:00:00

if any one has any idea plz let me know ,

Thanks in Advance

Hi,
As | is your delimiter, Try using Convert function (Trim(Convert('"','',colname)),hope it will solve the pbm.


Regards
Ravi

can you plz expand it, iam also facing the same(below) issue

DSTAGE-DB2CLI-0027`:`SQLExecDirect: Error executing statement 'SELECT <columnames> FROM <tablename> '. See following DB2 message for details.
DSP.Open GCI $DSP.Open error -100.

Try using this to make sure your data is correct. and reject the row that has invalid date conversions IsValidDate Returns whether the given value is valid for the type date. v Input: testdate (date) v Output: result (int8) v Examples. If the column mylink.mydate contains the date 2011-09-13, then ...

Try using this to make sure your data is correct. and reject the row that has invalid date conversions IsValidDate Returns whether the given value is valid for the type date. v Input: testdate (date) v Output: result (int8) v Examples. If the column mylink.mydate contains the date 2011-09-13, then ...

Try using this to make sure your data is correct. and reject the row that has invalid date conversions IsValidDate Returns whether the given value is valid for the type date. v Input: testdate (date) v Output: result (int8) v Examples. If the column mylink.mydate contains the date 2011-09-13, then ...

Hi,
Afer sequential file take transformer and do the count based on '|'
any way you will be knowing the max limit so that you can put constraint
in transformer saying that count less than that should be passed else rejected.

You could have multiple ordered sources with the following format: Key1 Key2 RowContents Src 1 (header): -1 0 Header----------------- The -1 is just to make sure the header comes first. You could have another key that comes first in the order that does nothing more than order the sources (eg: 0 for...

Declare your output format as a single VarChar column. In your job, detect the value group changes using either stage variables in a transform or within a sort stage. When your job detects a group change it outputs an additional record with the footer values as indicated in your example. Hi, Thanks...

Hi,
I need to implement a scenario and pass it to a file with one header and multiple footer records like
Input:
emp_id
100
100
200
200
200
300

Output:
Header--------------
100
2(count)
200
3(count)
300
1(count)

Your suggestions is appreciated!
Thanks in Advance

ray.wurlod wrote:Generate a column containing the length and aggregate preserving MAX. ...

Hi,
Got it Thanks

Use Len() functions to compare lengths. ... Hi, sorry to ask again, i can use Len function but if we have data like key data length 1 ------ 5 1 --------- 7 1 ----------- 8 2 ---------- 6 2 ------------ 7 2 -------------- 8 and my output should be like key data length 1 ------------------ 8 2 -----...

Use stage variables PrevKey = CurrKey CurrKey = Key CurrData = If PrevKey = CurrKey then PrevData : Data else Data PrevData = CurrData Use Remove Duplicates to retain the row which has longest Data. Also you should run this job in 1 node. HI, I have one doubt like we can remove duplilcates based on...

ravireddy25 wrote:HI,
I have to convert Date format to Gregorian format, can any one suggest me how to do this, i searched but i didnt get the answers
Any suggestion is appreciated,

Thanks
Ravi

Hi,
I want the calender date to gregorian date
Ex:2005-08-15 to 38578

Thanks in Advance