MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » September 2014

Re: Embedded SQL question



fixed

You have 2 options.

1. Use create table library.file as ( select 'cono2', other fields... Ftm
fromlib.from file) with data.

Or

Create table tolib.to file as (select *from fromlib.from file) with data.

Then follow with

Update tolib.to file set company ='con02'.
On Sep 2, 2014 6:57 AM, "Bill Howie" <blhowie66@xxxxxxxxx> wrote:

Rob,

Thanks for the info. Basically the task at hand here is this.....I've
already written a program for this project where I am copying data from a
particular library to another library. The criteria for this copy is files
having a company number field in them, and that company number having a
certain value. This is allowing us to copy data out of a test environment
so that when a refresh of data from production occurs our test data is
retained.

The next piece is what I'm doing now, which requires us to take this data
that's been copied to a "work" library and be able to change the company
number value to something else if we want to. So this is where I'm doing
the DSPFFD to figure out the company number field names. They can vary -
they can be something like CONO10, or CONO20, etc. So that's why I use the
DSPFFD results because it will give me the field names dynamically.

So you're saying that using SYSCOLUMNS improves on that functionality then?

Bill
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact