OnDemand User Group

Support Forums => OD/WEK & JAVA API => Topic started by: Lars Bencze on October 26, 2018, 02:46:42 AM

Title: Unload call
Post by: Lars Bencze on October 26, 2018, 02:46:42 AM

Hi all, maybe it's just me, but I'd like to have an ODAPI call that does Unload.
A swift way to remove botched loads without needing to have the thick OD client installed, nor need to file a case and send it to the OnDemand Administrator.

Has anyone found another smooth solution for this?

Title: Re: Unload call
Post by: Ed_Arnold on October 26, 2018, 05:45:55 AM

Here's what I do on z/OS (I know, I know).

Perhaps you could script up something similar on whatever platform you're on:

//     JOB
//L1      SET  AG='"Daily sales invoices"'                           
//L2      SET  H=ARCH950                                             
//L3      SET  LOADID=5052-1-0-92FAA-0-0-5053                       
//STEP1    EXEC PGM=ARSADMIN,REGION=0M,                             
//   PARM=('/unload -h &H -g &AG -L &LOADID -u odv733   -p cmodrocks')
//STEPLIB  DD DISP=SHR,DSN=ARS.ARSV950.SARSLOAD                     
//SYSPRINT DD SYSOUT=*                                               
//SYSOUT   DD SYSOUT=*                                               
//ARSBIN     DD PATH='/usr/lpp/ars/V9R5M0/bin'                       
//SYSPRINT   DD SYSOUT=*,DCB=(RECFM=FBA,LRECL=134,BLKSIZE=134)       
//SYSOUT     DD SYSOUT=*                                            

Ed

Title: Re: Unload call
Post by: Justin Derrick on October 26, 2018, 06:54:32 AM

Sounds like an enhancement request.  :)  Should I move this post over there, so it can be added to our enhancement request list in February?

-JD.

Title: Re: Unload call
Post by: Alessandro Perucchi on November 22, 2018, 10:27:00 AM

Except the enhancement proposition, the only way to do a "unload" would be to call the "arsadmin unload" command from Java.