Help with reports AFP

[jose.arotinco]

Hello,

I loaded line reports type and use resources for the background image. Could someone give me an example of the command to download such reports and the command for reload. That command I use and what parameters to use.

I tried several ways but have not been successful.

arsdoc get -G MEDHA -h server -u admin -p password -i "WHERE anio=2010 " -N -v -a -c -o MEDHA.out -d E:\Temp

outputs:
MEDHA.out.2.MEDHA.MEDHA.out
MEDHA.ind
MEDHA.res

arsadmin load -h server -u admin -p password -g MEDHA -i E:\Temp\MEDHA.ind -s MEDHA.out.2.MEDHA.MEDHA.out
-r E:\Temp\MEDHA.res

ARS1134E Invalid structured field header in the file E:\Temp\MEDHA.ind



Thanks.

[jeffs42885]

Something seems fishy with that output AFP file?

[Justin Derrick]

Use arsload, not arsadmin load.

-JD.

[jeffs42885]

Use arsload, not arsadmin load.

-JD.

How did I miss that  ??? ??? :o :o :o

[jose.arotinco]

Justin,

Please could you give me an example of how to load a report AFP with arsload?

[Justin Derrick]

Hey Jose.

It would be best if you reviewed the documentation so you can learn what all the options for arsload are, and how to use them in your situation:

http://pic.dhe.ibm.com/infocenter/cmod/v8r5m0/topic/com.ibm.ondemand.administeringmp.doc/dodlo001.htm

Don't hesitate to come back with any questions you have once you've reviewed the documentation.

-JD.

[jose.arotinco]

Justin

I have reviewed the documentation several days and can not find how to load the reports correctly, leaving me still the same error with arsload:

Load:
od_inst arsload-h {}-u {user}-p {pass}-vf-XG-g-a {AppGroup} {app} {MyFileName}

[rick]

When file is retrieved using arsdoc get, the .ind and .res file names should have same naming convention that of .out file. Are they manually renamed?


rename the files to as below and try loading using arsload

MEDHA.out.2.MEDHA.MEDHA
MEDHA.out.2.MEDHA.MEDHA.out
MEDHA.out.2.MEDHA.MEDHA.ind
MEDHA.out.2.MEDHA.MEDHA.res

arsload -h {}-u {user}-p {pass}-vf-XG-g-a {AppGroup} MEDHA.out.2.MEDHA.MEDHA

[Justin Derrick]

I'm not sure if it's how the forum formats text, but it looks like all the options are crammed together -- there needs to be a space between the options (which start with a hyphen ("-")).

Also, it looks like you're specifying the Application rather than the Application Group.  So try this one instead:

arsload -h {} -u {user} -p {pass}-vf -XG -g {AppGroup} -a {Application} MEDHA.out.2.MEDHA.MEDHA

(FYI, I used the 'teletype' button in the message editor to get a fixed-width font.)

-JD.

[jose.arotinco]

Frederick,

Thank you very much! the files renamed it as you indicated and it worked fine...seems simple but it took me several days to find the solution, thanks to you guys.

Regards,