The Modified TimeStamp File in EBCDIC

[dhwankim]

Hi Gurus.

I have met the problom in handling a modified timestamp file.
Originally, this data are from DB2 at MainFrame using db2 unload utility.
so when unloading, date files are trimmed mili-second part.

So My Customer said that file has "year,month,day and hour minute second " formatted data.

But I see the data as type binary in data browser at DS Desginer (It's PX Job.)

One of record is shown "{20 04 03 08 07 ! 03 D 02 E}".

I want to cast this colume as char and data'll be 2004-03-08 07:03:02".
(I guess the expected format..)
But I do not know it's right or not.

So If you have any expericne , Please Let me know resolution.

and Please recommand PX Function for it. If it's need.


It must be solved till tomorrow becase I participate in POC......


Please, Please Help me and Our Sales Rep.

Thank in Advance.


Daehwan

[chulett]

If you are in that big of a hurry for a solution, expecially if you've got a POC on the line and have Sales Rep in tow - contact Support. That's what they are there for.

I don't have PX or I'd try to help you out...