Re: Strangely crippled development environment (Was File in CL Program)

["Antonio Salazar" <asm@xxxxxxxxxxxxx>]

Cemtec, it's the IT branch of Cementos Mexicanos, the biggest concrete
company in México.
It handles the data processing of several other companies too.

I'm here as a consultant, my main company is Kernel, much less known than
Cemtec.
Maybe because I'm outsource I have more restrictions, but it's hard to work
this way.
Surprisingly, things get done :-)

----- Original Message -----
From: "Richard Jackson" <richardjackson@richardjackson.net>
To: <RPG400-L@midrange.com>
Sent: Wednesday, August 30, 2000 1:26 PM
Subject: RE: Fw: File in CL Program


> Antonio:
>
> Where do you work?
>
> Richard Jackson
> mailto:richardjackson@richardjackson.net
> http://www.richardjacksonltd.com
> Voice: 1 (303) 808-8058
> Fax:   1 (303) 663-4325
>
> -----Original Message-----
> From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
> Behalf Of Antonio Salazar
> Sent: Wednesday, August 30, 2000 11:33 AM
> To: RPG400-L@midrange.com
> Subject: Re: Fw: File in CL Program
>
>
> Thanks, Joel
>
> Here we have a _very_ restricted environment, so we can't use CRTCMD,
> STRDFU, SRTSQL, even STRDBG!
> Tough I insisted a lot, I wasn't able to get authority to this commands
(And
> we're software developers).
> Finally I did a clumsy DFU clone (CL and RPg only). Thanks to you SQL is a
> posibility too.
>
> Now I only miss STRISDBG (Or STRDBG at least). I guess DSPLY will do.
> I wonder why the hell happiness never reaches 100% :-).
>
> ----- Original Message -----
> From: "Joel Fritz" <JFritz@sharperimage.com>
> To: <RPG400-L@midrange.com>
> Sent: Tuesday, August 29, 2000 6:58 PM
> Subject: RE: Fw: File in CL Program
>
>
> > Try:
> >
> > for updates--
> >
> >  UPDATE &FILE
> >  SET &SET
> >  WHERE &WHERE
> >
> > for deletes--
> >
> >  DELETE FROM &FILE
> >    WHERE &WHERE
> >
> >
> > > -----Original Message-----
> > > From: Antonio Salazar [mailto:asm@kernel.com.mx]
> > > Sent: Tuesday, August 29, 2000 3:45 PM
> > > To: RPG400-L@midrange.com
> > > Subject: Re: Fw: File in CL Program
> > >
> > >
> > > I've been trying to do that, but as far as i knew, STRQMQRY can't run
> > > updates or deletes
> > > ¿How did you do it?
> > >
> > > ----- Original Message -----
> > > From: "Peter Connell" <peterc@baycorp.co.nz>
> > > To: <RPG400-L@midrange.com>
> > > Sent: Tuesday, August 29, 2000 3:46 PM
> > > Subject: RE: Fw: File in CL Program
> > >
> > >
> > > > It's very simple to create a cmd that runs a simple QM/400
> > > query which
> > > > expects to be passed a complete SQL statement. We use this in CLP to
> > > > dynamically run any SQL UPDATE statement. This feature has
> > > been available
> > > > for yonks, and there's almost nothing to code to make it
> > > available. You
> > > > don't need a hammer if you simply wish to use thumb tacks.
> > > >
> > > > Cheers, Peter

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---