Re: What's the limit on the parameter to pass for a sbmjob

Thanks for the reply, but dataq is not an option on this project. Can I
write a SQL stored procedure to insert the Trigger buffer into a File.

All I want is to take the trigger buffer and just dump it to a file. I don't
want any other processing to occurs. The file I am trying to place triggers
on is used very extensively in the app. Batch updates, real-time updates
etc.


Thanks
GG
----- Original Message -----
From: "Phil" <sublime78ska@yahoo.com>
To: <rpg400-l@midrange.com>
Sent: Wednesday, September 12, 2001 7:11 PM
Subject: RE: What's the limit on the parameter to pass for a sbmjob


> Rather than submitting a job, use data queues.  Then have a job monitor
the
> data queue and do whatever the sbmjob was going to do.
>
> Phil
>
> > -----Original Message-----
> > From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]On
> > Behalf Of Giri Gopal
> > Sent: Wednesday, September 12, 2001 8:02 PM
> > To: RPG400-L@midrange.com
> > Subject: What's the limit on the parameter to pass for a sbmjob
> >
> >
> > Hello:
> >
> > I have added a physical file trigger. The function of the trigger
program
> > is:
> >
> >     1) Build sbmjob command and call qcmdexec to submit the job.
> > In the call
> > pass the 32K buffer (trigger buffer) as a parm.
> >
> > Is their a limit on the submjob parm length. Because when I look
> > at the parm
> > in the called program I don't see all the data which is in the trigger
> > buffer.
> >
> > Any ideas?
> >
> >
> > Thanks
> > GG
> >
> > _______________________________________________
> > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
> > To post a message email: RPG400-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> > or email: RPG400-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> >
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>