Dumping the turbo image dataset to a delimited file (135 Views)
Reply
Occasional Advisor
macase
Posts: 10
Registered: ‎08-12-2005
Message 1 of 10 (135 Views)

Dumping the turbo image dataset to a delimited file

Can some one help me with the procedure/program or command script or any thing which would extract the rows and columns(incl multi repeated) from a turbo image dataset to a delimited file which can be opened in 'vi' or FTP to windows to be opened with 'notepad'

early help in this matter will be appreciated.

thanks,
Please use plain text.
Trusted Contributor
Fred Metcalf
Posts: 233
Registered: ‎12-02-1996
Message 2 of 10 (135 Views)

Re: Dumping the turbo image dataset to a delimited file

Not sure if still there but DBCOPY program (public domain software at www.3k.com) will extract datasets to disk files.
Also QUERY SAVE command after a FIND ALL.
(http://docs.hp.com/en/32650-90889)
Please use plain text.
Occasional Advisor
Yosef Rosenblatt_1
Posts: 8
Registered: ‎07-18-2005
Message 3 of 10 (135 Views)

Re: Dumping the turbo image dataset to a delimited file

You can use any Image extract tool to create a delimitted file. Robelle's supertool is the fastedt way to extract the file but that is a third party software which you may not have. You can also use query which comes with Image. Lastly you can use any programming language, third or fourth GL to create a file.

All of these methods are documented in the various manuals.
A witty saying proves nothing. - Voltaire
Please use plain text.
Occasional Advisor
macase
Posts: 10
Registered: ‎08-12-2005
Message 4 of 10 (135 Views)

Re: Dumping the turbo image dataset to a delimited file

Find all is not working i guess the Query version is the problem. we have Query/NM and Query/3000. on that it doesnot work

please advice how i can achieve the requested dump.

thanks,
Please use plain text.
Trusted Contributor
Fred Metcalf
Posts: 233
Registered: ‎12-02-1996
Message 5 of 10 (135 Views)

Re: Dumping the turbo image dataset to a delimited file

The :query command should result in QUERY/NM
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"
Please use plain text.
Occasional Advisor
macase
Posts: 10
Registered: ‎08-12-2005
Message 6 of 10 (135 Views)

Re: Dumping the turbo image dataset to a delimited file

Hi Fred,

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.
===========================================
>fo account-master


DATA BASE: AC2005.SCHEMA .ARCACCT TUE, AUG 16, 2005, 10:16 AM


DATA BASE LANGUAGE ATTRIBUTE: NATIVE-3000


SET NAME:
ACCOUNT-MASTER,MANUAL

ITEMS:
ACCOUNT-KEY, X16 <>
ACCOUNT-NAME, X30
ACCOUNT-ADDRESS, X30
ACCOUNT-BALANCE, Z12
DATE-OF-BALANCE, X8
DATE-LAST-TRAN, X8
CREDIT-BALANCE, 12Z12
DEBIT-BALANCE, 12Z12
FORN-QTY, Z12
ACCOUNT-EX, X28
DUE-DATE, X8

CAPACITY: 65001 ENTRIES: 59429
======================================================================
above is the output of the command.

1. >find all account-master.account-key
USING SERIAL READ
59429 ENTRIES QUALIFIED
>save testout

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,

Please use plain text.
Valued Contributor
Glenn A. Mitchell
Posts: 73
Registered: ‎10-20-1996
Message 7 of 10 (135 Views)

Re: Dumping the turbo image dataset to a delimited file

The output you're seeing is normal. 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.

Regards.

Glenn
Please use plain text.
Trusted Contributor
Fred Metcalf
Posts: 233
Registered: ‎12-02-1996
Message 8 of 10 (135 Views)

Re: Dumping the turbo image dataset to a delimited file

Hi Mohammed,
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
Fred
Please use plain text.
Respected Contributor
Stan Sieler
Posts: 321
Registered: ‎10-16-1996
Message 9 of 10 (135 Views)

Re: Dumping the turbo image dataset to a delimited file

Hi Mohammed,

Our product, DBCSV, does exactly what
you asked for.

http://www.allegro.com/products/hp3000/dbcsv.html

Stan
sieler@allegro.com
Please use plain text.
Occasional Advisor
macase
Posts: 10
Registered: ‎08-12-2005
Message 10 of 10 (135 Views)

Re: Dumping the turbo image dataset to a delimited file

Hi Glenn,

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.

thanks,
Ahmed,
========================
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.
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation