download to application server using job open/close

[Former Member]

Hello people,

Currently I am using open/close dataset to download to the application server automatically. What I do here is submit a program execute in background when the report is done the report is automatically downloaded to the application server.

My problem now is that I want to use job open/close. With this, unfortunatley, my current method of open/close dataset will be unsuable to download to application server once the background job is done.

My question is, is there a way for me to automatically download a file to the application server using the job open/close method?

Thank you so much and take care.

[Former Member]

Hi,

What you can do is to write a report program that downloads the data to the file on the app server.

Now, you can use the JOB_OPEN and JOB_CLOSE and submit this program in the background which will write the file.

Regards,

Ravi

Note : Please mark the helpful answers

[Former Member]

<b>Hi,

What you can do is to write a report program that downloads the data to the file on the app server.

Now, you can use the JOB_OPEN and JOB_CLOSE and submit this program in the background which will write the file.

Regards,

Ravi</b>

So what you are saying is that I create two programs, where the job open/close program is the one I will run?

Problem is that I plan to get the values of the selection-options from the original program using the program with the job open/close. How will that work.

Thanks

[Former Member]

Hi,

What you can do is to get the SELECTION parameters from the other program, fetch your data and finally consolidate the data into one internal table, that you want to download.

Now, EXPORT this table to memory (using the EXPORT statement) and then IMPORT this table in the background program that is being submitted as a part of the JOB_OPEN and JOB_CLOSE.

Then download that table inside that program

Does it make sense?

Regards,

Ravi

Note : Please mark the helpful answers

[Former Member]

ok thanks ill give it a shot