Skip to Content
avatar image
Former Member

ASCII Migration

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 12, 2006 at 06:53 PM

    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

    Add comment
    10|10000 characters needed characters exceeded