MVSFORUMS.com

info_seeker · Beginner Joined: 31 Jan 2005 Posts: 27 Topics: 9

Hello...

I have a requirement to export QMF report through a batch job in HTML format for mutiple tables into a single dataset. Can somebody help!!!

Here is what I did..
RUN QUERY ABC1
EXPORT REPORT (DATAFORMAT HTML) (FORM=ABC1
RUN QUERY ABC2
EXPORT REPORT (DATAFORMAT HTML) (FORM=ABC2

This gave me error saying "Export command incomplete". I was tryoing to find a way similar to how we can print mutiple reports and send everything one DSN provided in the DD DSQPRINT. Help much appreciated!!!

jim haire · Beginner Joined: 30 Dec 2002 Posts: 140 Topics: 40

I'm not sure if this will work or not. Try the following:

RUN QUERY ABC1 (FORM=ABC1
EXPORT REPORT (DATAFORMAT HTML
PRINT REPORT

RUN QUERY ABC2 (FORM=ABC2
EXPORT REPORT (DATAFORMAT HTML
PRINT REPORT

I believe your query and form wil need to have different names. The
"PRINT REPORT" will write the report to the dataset which is allocated to DSQPRINT.

info_seeker · Beginner Joined: 31 Jan 2005 Posts: 27 Topics: 9

It didn't work..
MESSAGE NUMBER: DSQ22153
MESSAGE TEXT:
The EXPORT command is incomplete.
&C1: EXPORT
&C2: REPORT Sad

dbzTHEdinosauer · Posted: Thu Oct 22, 2009 2:27 pm Post subject:

I have always used EXPORT REPORT AS dsn (......
_________________
Dick Brenholtz
American living in Varel, Germany

info_seeker · Beginner Joined: 31 Jan 2005 Posts: 27 Topics: 9

That didn't work... bonk

dbzTHEdinosauer · Posted: Thu Oct 22, 2009 4:53 pm Post subject:

well gee, info_seeker,

it seems that you will have to seek the info yourself,
unless of course you have no deadline for this task
and wait until someone bothers to look up the answer in the manual
and gives it to you.
_________________
Dick Brenholtz
American living in Varel, Germany

info_seeker · Beginner Joined: 31 Jan 2005 Posts: 27 Topics: 9

dbzTHEdinosauer..

I should have been more specific in my reply... I tried your suggestion... But that returned error message "You cannot export a REPORT object from the database."

So I looked into manual to check the syntax. Manual doesn't even mention

dbzTHEdinosauer · Posted: Fri Oct 23, 2009 10:36 am Post subject:

or EXPORT FORM AS dsn.
_________________
Dick Brenholtz
American living in Varel, Germany

jim haire · Beginner Joined: 30 Dec 2002 Posts: 140 Topics: 40

Try EXPORT REPORT TO name (dataformat=HTML

The report will be put in a dataset called userid.name.REPORT .

Another option is to enter

EXPORT REPORT TO 'dataset name' (DATFORAMT=HTML

batu544 · Beginner Joined: 02 Aug 2005 Posts: 75 Topics: 27

hi,
Try this .. It will work in batch mode..

Terry_Heinze · Posted: Mon Feb 08, 2010 12:07 am Post subject:

batu, I think it was answered last year.
_________________
....Terry

batu544 · Beginner Joined: 02 Aug 2005 Posts: 75 Topics: 27

Oh !!!.. sorry .. while replying. I have not noticed the last reply date..just now I saw its "Fri Oct 23, 2009" ..

I replied a really old thread.. bonk

_________________
Regards,
batu