Re: SQL

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Yes, please - after all the exchanges, the solution, whatever it is, 
even if embarrassing, is worth hearing.

Vern

On 6/20/2019 4:53 AM, Paul Therrien wrote:
> Can you share what the solution was, please?
>
>
> Paul
>
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
> dave_peters@xxxxxxxxx
> Sent: Wednesday, June 19, 2019 10:34 PM
> To: midrange-l <midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: Re: SQL
>
> Hi
>
> found my problem, sorry wasting your time
>     
>
>
> ----- Original Message -----
> From: "dave peters" <dave_peters@xxxxxxxxx>
> To: "midrange-l" <midrange-l@xxxxxxxxxxxxxxxxxx>
> Sent: Wednesday, June 19, 2019 7:01:16 PM
> Subject: Re: SQL
>
> Hi
>
> wrote a program to read by physical file instead of logical file and it
> reads record okay so it seems when I add record with SQL the logical file is
> not updated.
>    
>    
>
>
>
> ----- Original Message -----
> From: "midrange" <franz9000@xxxxxxxxx>
> To: "midrange-l" <midrange-l@xxxxxxxxxxxxxxxxxx>
> Sent: Wednesday, June 19, 2019 5:06:26 PM
> Subject: RE: SQL
>
> Can you define what you mean by "read it".
>
> Is this a chain or setll and read or reade ?
> Are you accessing by the primary key or other columns? (and is their delayed
> maint on the indexes) Is the read by the name column and not mixed case like
> the insert..?
> Are there other columns in the file and having an issue with null values?
> Lots of possibilities..
> Jim
>
> -----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of
> dave_peters@xxxxxxxxx
> Sent: Wednesday, June 19, 2019 6:55 PM
> To: midrange-l <midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: Re: SQL
>
> Hi
>
> use strpdm
> chose work with objects
> select file use option 18 to create DFU
>
> here is the program  BLD003RP   SQLRPGLE
>
>   Demp            e ds                  extname(sfl001pf)
>
>        /Free
>
>         exec sql
>           set option
>            commit = *none;
>
>             exec sql
>               insert into sfl001pf VALUES
>                 ( 0419440,
>                   'Slovabz',
>                   'Dave',
>                   'E',
>                   'Red',
>                   '13945 56 ave',
>                   'Surrey',
>                   'BC');
>
>         *Inlr = *On;
>
>        /End-Free
>
>
>
> ----- Original Message -----
> From: "Justin Taylor" <JUSTIN@xxxxxxxxxxxxx>
> To: "midrange-l" <midrange-l@xxxxxxxxxxxxxxxxxx>
> Sent: Wednesday, June 19, 2019 3:09:41 PM
> Subject: RE: SQL
>
> What's "option 18"?
>
> Is it an SQLRPGLE program that did the insert?  Does it use commitment
> control?  If so, did you do a commit after the insert?  If it's SQLRPGLE, do
> a DSPPGM command against it.  On the module page (3 for me), do a "Display
> description" against your module.  You want " DB2 for IBM i module
> attributes:", which is down several pages.
>
>   
>
>
> -----Original Message-----
> From: dave_peters@xxxxxxxxx [mailto:dave_peters@xxxxxxxxx]
> Sent: Wednesday, June 19, 2019 4:38 PM
> To: midrange-l <midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: SQL
>
> Hi
>
> wrote simple program to insert a record into an external file using SQL,
> works fine can see the record using option 18 on file, but can not read it
> with RPG program using external file or SQL
>
> Dave
>   
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link:
> https://amazon.midrange.com
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link:
> https://amazon.midrange.com
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link:
> https://amazon.midrange.com
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link:
> https://amazon.midrange.com