× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: Fw: File in CL Program
  • From: "Antonio Salazar" <asm@xxxxxxxxxxxxx>
  • Date: Wed, 30 Aug 2000 12:32:37 -0500

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
> > +---
> >
> +---
> | 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
> +---

+---
| 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
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.