execute/run/submit a JD Edwards(XE/E810/E811) UBE, Report Program using web program and sql-server:
Step 1: Create a Batch FileFirst Create a batch file (run_UBE.BAT) on Enterprise (DATABASE) , Pass parameter as Program Name & Version
CD\
i:
cd PEOPLESOFT
cd DDP
cd E810
cd system
cd bin32
SET progname=%1
SET vername=%2
RUNUBE USER PASSWORD ENVIRONMENT ROLE %1 %2 QBATCH "BATCH" "Hold" "SAVE" PRINTER_NAME
echo
EXAMPLE
RUNUBE RAJEEV PASSWORD PD810 ADMIN R42565 ZJDE0001 QBATCH "BATCH" "Hold" "SAVE" PRINTER_NAME
Step 2: Create a Stored Proc.
CREATE PROCEDURE [dbo].[runu_batch]
(@PRGNAME AS VARCHAR(15),@VERSNAME AS VARCHAR(15))
AS
DECLARE @PRGVER VARCHAR(30)
DECLARE @CMD VARCHAR(50)
SET @PRGVER= LTRIM(RTRIM(@PRGNAME))+' '+LTRIM(RTRIM(@VERSNAME))
SET @CMD ='c:\runube\run_UBE.BAT '+ @PRGVER
exec master..xp_cmdshell @CMD
GO
After that call stored proc from web program (I did in ASP.NET)
1 comment:
Salesforce Admin Online Training - 21st Century Software ...
www.21cssindia.com/courses/salesforce-admin-online-training-143.html
Salesforce admin online training by 21cssindia the largest institute in providing online trainings in all technologies. Salesforce admin training, salesforce ...
salesforce developer online training| salesforce developer ...
www.21cssindia.com/.../salesforce-developer-online-training-144.html
21cssindia provides Salesforce developer online training by real time Experts. Call us +91 9000444287 for online training and demo. Online Salesforce ...
salesforce crm online training| salesforce crm training| call ...
www.21cssindia.com/courses/salesforce-crm-online-training-212.html
21cssindia provides Salesforce crm online training by real time Experts. Call us +91 9000444287 for online training and demo. Online Salesforce crm training ...
Post a Comment