Re: flat-file insert question

From: Jeff Zucker (jeff_at_vpservices.com)
Date: 05/17/04

  • Next message: Michael Peppler: "Re: connecting 5.8.3 Perl to ASE-12.5, connection successful, no dbh returned" 
    Date: Mon, 17 May 2004 08:33:52 -0700
To: leegold <leegold@fastmail.fm>

    leegold wrote:
    > Given a flat-file:
    >
    > 1###A###703
    > 2###D###203
    > 3###E###303
    > 4###J###901
    >
    > The file is sorted by field2.

    In SQL it is irrelevant what order the physical file is sorted in. If
    you want a list sorted by field2, you just use the SQL clause "ORDER BY
    field2" when you do a SELECT and it will be returned to you in that
    order regardless of the order of the physical file.

    This question has to do with SQL, not with DBI. You'd be better off
    looking for SQL answers someplace devoted to SQL. Try a google for "SQL
    Tutorial". 

    -- 
Jeff
  • Next message: Michael Peppler: "Re: connecting 5.8.3 Perl to ASE-12.5, connection successful, no dbh returned"

    Relevant Pages

    • Re: Case in Select Statement
      ... I have SQL: ... where field1=22 AND field2 IS NULL ... I have to change returned value of field5 in this query. ...
      (comp.databases.informix)
    • Re: Case in Select Statement
      ... 4GL doesn't accept all InformixSQL syntax - the normal work around is to PREPARE the Sql first.. ... where field1=22 AND field2 IS NULL ... I have to change returned value of field5 in this query. ...
      (comp.databases.informix)
    • Re: How to modifty the first chr of a field
      ... SQL> create table mysource( ... (field1, field2, field) ...
      (comp.databases.oracle.server)
    • Re: Can inner join replace multiple loop selects?
      ... doable in a SQL statement. ... You'd then operate on that group by restricting the SQL UPDATE to ... And Field2 ... Process oRs2 Condition1 ...
      (comp.databases.ms-access)
    • Re: Case in Select Statement
      ... In original application we have simple SQL: ... where field1=22 AND field2 IS NULL ... I have to change returned value of field5 in this query. ...
      (comp.databases.informix)