ASCII Migration

[Former Member]

We are currently planning or codepage conversion to ASCII. One of our consultants provided us with a converted physical file (from another client) for us to do an initial test with DataMirror's Transformation Server.

These initial tests are failing because DataMirror's Transformation Server does not seem to support derived expressions for data type GRAPHICS.

If I use the command, DSPFFD FILE(ASCIIDATA/MAKT)to display the attributes of the test file MAKT, I get the following output.

=========================================================

Display File Field Description

Input parameters

File . . . . . . . . . . . . . . . . . . . : MAKT

Library . . . . . . . . . . . . . . . . . : ASCIIDATA

File Information

File . . . . . . . . . . . . . . . . . . . : MAKT

Library . . . . . . . . . . . . . . . . . : ASCIIDATA

File location . . . . . . . . . . . . . . . : *LCL

Externally described . . . . . . . . . . . : Yes

Number of record formats . . . . . . . . . : 1

Type of file . . . . . . . . . . . . . . . : Physical

File creation date . . . . . . . . . . . . : 06/08/06

Text 'description'. . . . . . . . . . . . . : Defaults changed by R3loaddb

Record Format Information

Record format . . . . . . . . . . . . . . . : MAKT

Format level identifier . . . . . . . . . . : 350BA14FF8C30

Number of fields . . . . . . . . . . . . . : 5

Record length . . . . . . . . . . . . . . . : 204

Field Level Information

Data Field Buffer Buffer Field Column

Field Type Length Length Position Usage Heading

MANDT GRAPHIC 3 6 1 Both MANDT

Coded Character Set Identifier . . . . . : 13488

UCS2 or Unicode conversion . . . . . . . : *CONVERT

MATNR GRAPHIC 18 36 7 Both MATNR

Coded Character Set Identifier . . . . . : 13488

UCS2 or Unicode conversion . . . . . . . : *CONVERT

SPRAS GRAPHIC 1 2 43 Both SPRAS

Coded Character Set Identifier . . . . . : 13488

UCS2 or Unicode conversion . . . . . . . : *CONVERT

MAKTX GRAPHIC 40 80 45 Both MAKTX

Coded Character Set Identifier . . . . . : 13488

UCS2 or Unicode conversion . . . . . . . : *CONVERT

MAKTG GRAPHIC 40 80 125 Both MAKTG

Coded Character Set Identifier . . . . . : 13488

UCS2 or Unicode conversion . . . . . . . : *CONVERT

=========================================================

Can someone with an ASCII system run the same command and send me the output. I just want to verify that the file our consultant sent to us has been converted properly.

Thank you,

Roy

[Former Member · Accepted solution]

Hi Roy,

Our MAKE of ECC 5.0 ASCII looks like same - see below.

Mimix has no problem synchronizing it.

Regards,

Victor Lin

*********************************************

Display File Field Description

Input parameters

File . . . . . . . . . . . . . . . . . . . : MAKT

Library . . . . . . . . . . . . . . . . . : R3TSTDATA

File Information

File . . . . . . . . . . . . . . . . . . . : MAKT

Library . . . . . . . . . . . . . . . . . : R3TSTDATA

File location . . . . . . . . . . . . . . . : *LCL

Externally described . . . . . . . . . . . : Yes

Number of record formats . . . . . . . . . : 1

Type of file . . . . . . . . . . . . . . . : Physical

SQL file type . . . . . . . . . . . . . . . : TABLE

File creation date . . . . . . . . . . . . : 12/25/05

Text 'description'. . . . . . . . . . . . . : Defaults changed by R3loaddb

Record Format Information

Record format . . . . . . . . . . . . . . . : MAKT

Format level identifier . . . . . . . . . . : 350BA14FF8C30

Number of fields . . . . . . . . . . . . . : 5

Record length . . . . . . . . . . . . . . . : 204

Field Level Information

Data Field Buffer Buffer Field Column

Field Type Length Length Position Usage Heading

MANDT GRAPHIC 3 6 1 Both MANDT

Default value . . . . . . . . . . . . . . :

UX'003000300030'

Coded Character Set Identifier . . . . . : 13488

UCS2 or Unicode conversion . . . . . . . : *CONVERT

MATNR GRAPHIC 18 36 7 Both MATNR

Default value . . . . . . . . . . . . . . :

UX'0020'

Coded Character Set Identifier . . . . . : 13488

UCS2 or Unicode conversion . . . . . . . : *CONVERT

SPRAS GRAPHIC 1 2 43 Both SPRAS

Default value . . . . . . . . . . . . . . :

UX'0020'

Coded Character Set Identifier . . . . . : 13488

UCS2 or Unicode conversion . . . . . . . : *CONVERT

MAKTX GRAPHIC 40 80 45 Both MAKTX

Default value . . . . . . . . . . . . . . :

UX'0020'

Coded Character Set Identifier . . . . . : 13488

UCS2 or Unicode conversion . . . . . . . : *CONVERT

MAKTG GRAPHIC 40 80 125 Both MAKTG

Default value . . . . . . . . . . . . . . :

UX'0020'

Coded Character Set Identifier . . . . . : 13488

UCS2 or Unicode conversion . . . . . . . : *CONVERT