Skip to Content
0
Former Member
Dec 05, 2006 at 07:41 AM

Date Format not same as ASCII file

40 Views

Hi,

I am uploading ASCII file data(7 records) to cube, i am not able to see all the data in cube instead of getting all the data in cube i am seeing only 5 records

ascill file format is

B007709162002CNA

B007709172002CNR

B007709182002CNM

B007709192002CNA

B007709202002CNM

B007709242002CNS

B007709252002CNQ

i created all the objects with fixed lenght..

the thing is i can see the data correctly in Transfer-rules same as in ASCII file..

the data i can see in cube is...

ZFILL

ZFNUM

ZOCITY

ZRTYPE

ZODATE

-


0077

CNA

B

02.20.0919

0077

CNR

B

02.20.0917

0077

CNM

B

02.20.0920

0077

CNS

B

02.20.0924

0077

CNQ

B

02.20.0925

ASCII date format CUBE date format is

mmddyyyy

09 16 2002 02.20.09.16

i can see the correct date format in transfer rules, but in comm structure i can see diff date format

i want to get the same date format as ascill file date format

Needed your inputs

Thanks,

Can anyone help me in this