RE: Sbmjob Command from the ADODB connector

I corrected your statement in line.



Chris Bipes
Director of Information Services
CrossCheck, Inc.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bill
Sent: Tuesday, December 30, 2008 11:37 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Sbmjob Command from the ADODB connector

Due to library list complications, I've decided to submit the program I
want to run and thus be able to set the library list via the job
description. The problem I'm running into is that the system is
throwing an error about a missing parenthesis.

Here is the relevant code:

strCmdTxt = "{{SbmJob cmd(Call pgm(" & strPgmLib & "/SFC55AC) parm(" &
strWkStn & ")) job(sfc55ac) jobd(" & strFileLib & "/bpcsjobd)}}"

cmd.CommandText = strCmdTxt
cmd.Execute


This is the value of strCmdTxt to be executed:

{{SbmJob cmd(Call pgm(BPCSUSRCD/SFC55AC) parm(SAMIS1S3)) job(sfc55ac)
jobd(BPCSFCD/bpcsjobd)}}