× 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.


  1.  Home
  2. MIDRANGE-L
  3. April 2007

RE: CPYF (From KEYED to NON-KEYED)

If you're going to use RUNSQLSTM you can consolidate all of the files in one
swoop. Just use UNION operator and union-ize SELECTs from all of the files
you have.

Elvis

Celebrating 10-Years of SQL Performance Excellence

-----Original Message-----
Subject: Re: CPYF (From KEYED to NON-KEYED)

"I'm curious as to why you need to do this."

Hi Alan. I am consolidating a file located in different sites into a new
standard one, local version. While consolidating, any duplicate values
will be placed on an "error" file and I want to build this error file with
the same record layout as the input file I can keep all values intact.

"Would it help solve your problem if you left the "k" off the F-spec in
the RPG program? That does the same thing, at least for that RPG
program."

Greetings Booth. I do not want to use and RPG pgm for this.

"One way could be to use RUNSQLSTM ..."
Thanks Elvis; sounds like the solution I need.

Thanks all!


Peter Vidal



As an Amazon Associate we earn from qualifying purchases.

This thread ...
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.