08-12-2005 10:49 PM
early help in this matter will be appreciated.
08-13-2005 07:12 PM
08-14-2005 06:40 PM
All of these methods are documented in the various manuals.
08-15-2005 01:35 AM
please advice how i can achieve the requested dump.
08-15-2005 01:48 AM
What error do you get?
Did you define the database and the dataset?
You need to specify an item for the FIND ALL command. You can query the database structure with "FO SETS" and "FO setname"
Then do "FIND ALL itemname"
08-15-2005 10:51 PM
thanks for your help. I am a novice for mpe/ix and image.
I did as you suggested and succeeded upto some extent. please find below what i did.
DATA BASE: AC2005.SCHEMA .ARCACCT TUE, AUG 16, 2005, 10:16 AM
DATA BASE LANGUAGE ATTRIBUTE: NATIVE-3000
ACCOUNT-KEY, X16 <
CAPACITY: 65001 ENTRIES: 59429
above is the output of the command.
1. >find all account-master.account-key
USING SERIAL READ
59429 ENTRIES QUALIFIED
2. the OS file "testout" has many questions.
1. the record length according to the 'fo' above is 440.
2. the record length in the testout file is 404 only.
3. there are some braces and some character data in numberic columns.
4. the negative numbers are not reflected.
I am also attaching the output file testout.txt and its excell sheet equivalent which is extracted using ODBC driver. they are not full files, i extracted the lines where all the columns are available. ignore the 17 to 76 they are local language character set.
hope that helps you to help me.
thanks & regards,
10-12-2005 01:00 PM
10-12-2005 05:25 PM
I missed your question only saw it today when Glenn answered. He explains it correctly. Alternative for access from PC could be ODBCSE that is provided free with MPE. Start by reading HPREADME.ODBCSE.SYS and search for ODBC under MPE manuals on www.docs.hp.com
10-30-2005 08:22 PM
I need some further help on your below reply. You gave to options, i selected not to use another tool reason may be it might involve purchasing or using cobol which i do not know. Given the situation, i will prefer format the query output. now the biggest hurdle stand in front is how to format. I believe the formating commands should be introduced between "find all" and "save" command. I do not have a clue how to format the query output.
The curly braces and characters in numeric fields are the sign characters that are present in the Z format data items. You will need to format your Query output to see the signs appropriately or you will have to use another tool (PowerHouse, COBOL, SuprTool) to extract and/or convert the data.