Ansicht
Dokumentation
03754 - ASCII SAP AS400 questions from Starwood
BAL Application Log Documentation General Material DataThis documentation is copyright by SAP AG.
ASCII SAP AS400 questions from Starwood
Hi Eddy,you are using the ASCII solution and try to have a look to the data. As you
can't see the correct data, you probably use the command DSPPFM. This shows
the data more or less binary to you. When you would use STRSQL and then
"SELECT * from mara" or RUNQRY QRYFILE(MARA) you'd see the correct english
data. This will always be correct as long as you are viewing to latin-1
data.
There is a tool called CRTSAPVIEW out that would create views with the CCSID
500 in order to have input access in RPG programs. As you are searching for
methods input, update and insert, I can only ask you to use interactive or
embedded SQL. As your job always has the CCSID 037 or 500 (at least EBCDIC),
the IBM-SQL-interface will translate this automatically to unicode (or
ascii) and vice versa.
Regards
Volker Gueldenpfennig
AS/400 Development Support, Walldorf/Germany
> <emartinezZstar To: Jim
> Sanders/Ontario/IBMZIBMCA
> lodge.com> cc:
>
> Subject: ASCII
> SAP AS400
> 01.11.01 18:36
>
> Please respond
>
> to "Eddy
>
> Martinez"
>
>
>
>
>
>
>
>
> Jim,
>
> We have just completed our first test run with exporting and
> migrating a
> test database to ASCII SAP on the AS400.
>
> Everything went smoothly, the only thing I have a question
> about is viewing
> the database files at the OS level. They appear to be in an
> ASCII format
> and unreadable with any of the standard OS400 tools, which is
> what I was
> expecting.
>
> With Operations navigator I can view the table data, but can
> not alter it,
> I can alter table data in on of the EBCDIC systems in this fashion.
>
> Is there a tool available that you know of that will allow
> display, change
> etc of the files from the OS level?
>
>
> PS. I saw your post on the ISeries SAP consolut group, we have
> been running
> our production systems and several of our other SAP systems
> on V5R1 for
> several months with not problems. If you would like more
> details let me
> know.
>
>
>
> Thanks,
>
> Eddy Martinez
> Starwood Hotels and Resorts
>
>
>
>
>
Durban Tours - Südafrika Safari
General Data in Customer Master General Material Data
This documentation is copyright by SAP AG.
Length: 2860 Date: 20240426 Time: 030510 sap01-206 ( 3 ms )
