ARSDOC Get Line Data Output Unreadable

[app1mvf]

Hello, I was wondering if someone could help me out. I am trying to do a arsdoc get on a line data application group to extract multiple report files into one large readable file.... The problem I am having is that the output from cmod is unreadable. I have tried numerous code page conversions on the file but regardless whatever I try I am still left with garbage characters in the output file. Is there a switch or flag I am missing to make the output human readable or is there a convertion command that I can run?

Sameple ARSDOC GET

Code: [Select]

/opt/ondemand/bin/arsdoc get -h 192.168.1.65 -u EPIC -p PASSWORD -G SAMPLE -v -o /TEMP_WORKAREA/LINEDATA/CUST_LINEDATA.txt -c -i "where AccountNumber='82843723' AND InvoiceDate BETWEEN 15592 AND 15592"
Sample File Conversion

Code: [Select]

/usr/bin/iconv -f cp037 -t iso8859-1 /TEMP_WORKAREA/LINEDATA/CUST_LINEDATA.txt > /TEMP_WORKAREA/LINEDATA/CUST_LINEDATA.txtconverted
Thank you

[jeffs42885]

Did you try .out instead of .txt?

[app1mvf]

I just gave that a try and it didn?t make any difference. 
Any other ideas?

Thank you

[Justin Derrick]

What's the code page specified in the application that ingested this data?

You can paste in the Application configuration data to give us everything...

-JD.

[app1mvf]

Sorry I wasn?t clear.... I the data won?t be passed to another system, the data is being extracted for a user within my company. The reason why I am extracting the data via an arsdoc get instead of selecting the data through the client is because it?s a large amount of invoices.

Please tell me if you have any additional questions. Thank you

[app1mvf]

I will assume by the lack of responses that no one has ever done this?. Thank you very much for your help, I will open a PMR with IBM.

[Justin Derrick]

You might want to check back in a few days for an update.  We only get about 20-30 users a day logging in.

If you find an answer, please don't forget to post the solution!  We like answers almost as much as we like questions... 

-JD.

[sisusteve]

We didn't ever see the answer to the question of which Code Page is used. Is the EBCDIC (Code page 500) or ASCII (Code page 850) data?

[LWagner]

Was this solved ?

My arsdoc get of AFP included:

-A 7 -vcgN  -G DOC0610 -i "WHERE LOAD_DATE > 0" -o OET.1116FAA -d c:\ars1-test -x "10918-85-0-1116FAA-15590-15590"

[Justin Derrick]

Without seeing what the codepage is, we don't know if the retrieved data is simply in EBCDIC -- in which case, there's no problem at all.

Seeing the ACIF indexing parameters would also give us some information as well.

-JD.

[Alessandro Perucchi]

Sorry I wasn?t clear.... I the data won?t be passed to another system, the data is being extracted for a user within my company. The reason why I am extracting the data via an arsdoc get instead of selecting the data through the client is because it?s a large amount of invoices.

Please tell me if you have any additional questions. Thank you

Hello app1mvf,

I don't know if you still follow this thread or not, since the only 4 posts (at the time of writing) you posted are all in this thread, and nothing since May 22.

Justin asked you what code page is in your file, and asked also if you could provide some info about the Application itself, so we can analyze your problem.
Because without such basic information, we simply cannot help you. Nobody can help you.

Then you say:

I will assume by the lack of responses that no one has ever done this?. Thank you very much for your help, I will open a PMR with IBM.

I hope that you were giving more information to the IBM Support people, because without such dialogue, they cannot help you too.

There is a nice saying about "assume":

You should never assume. You know what happens when you assume. You make an ass out of you and me because that's how it's spelled.

I hope that next time, you will be reading the questions asked by the people that wants to help you. And I assume that you were more verbose with the IBM Support people, and you have had your answer.
I hope that someday you will read this thread, and give us the answer to your problem for the future generation of users in this forum.

I assume that you are going to do that... but I'm certainly making an ass of myself on that... so please help this forum to be a better place :-) with answer to every questions asked!!!

Sincerely yours,
Alessandro

[app1mvf]

Update: One of the people on my team got a response to the ticket we opened with IBM stating that the arsdoc get API does not have the functionality to extract multiple report files from a line data application group into one large readable file. IBM suggested that we could use the JAVA API.

The approach taken as a result was to extract the data using the standard API and run it through ICONV and a bunch of sed commands to format the data.