Re: Delphi/400

[Rob Berendt <rob@xxxxxxxxx>]

Field names on 400 versus those of Oracle.

>From the DDS reference manual I have:
$   ALIAS (alternative field) names
 
    -   The length of an alternative field name is 1 to 30 characters. The 
first character must be A through Z.  
        Subsequent characters must be A through Z, 0 through 9, or the 
underscore (_).
 
    -   Because DDS does not perform any language-specific syntax checking, you 
must make sure that the 
        alternative field names you specify conform to the naming conventions 
of the high-level language that 
        uses the names.  The high-level language compiler checks the syntax of 
the names when they are brought 
        into the program.


 Example

|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
  00010A            FIELDA        25A         ALIAS(CUSTOMERNAME)

If you like SQL versus DDS, then consider:
CREATE TABLE QTEMP/FILEY (BIGHONKINNAME FOR COLUMN LITTLENAME CHAR
(10) NOT NULL WITH DEFAULT, EVENBIGGERHONKER FOR COLUMN SMALLNAME 
CHAR (25) NOT NULL WITH DEFAULT)
Which displays in DSPFFD as
.+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8..
           Data        Field  Buffer    Buffer        Field    Column          
Field      Type       Length  Length  Position        Usage    Heading         
LITTLENAME CHAR           10      10         1        Both     BIGHONKINNAME   
  Alternative name  . . . . . . . . . . . . :  BIGHONKINNAME                   
  Coded Character Set Identifier  . . . . . :     37                           
SMALLNAME  CHAR           25      25        11        Both     EVENBIGGERHONKER
  Alternative name  . . . . . . . . . . . . :  EVENBIGGERHONKER                
  Coded Character Set Identifier  . . . . . :     37                           





jhall@hillmgt.com on 06/22/98 11:12:46 AM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Subject:        Re: Delphi/400

Carl Friedberg, carl@comets.com wrote:
> 
> John, thank you for the first substantive reply on this topic.
> At one point, it looked like we might need Delphi/400, but
> we've taken a different tack for now. We do use Delphi on
> nt and are delighted with it. I'll keep your e-mail address on
> file in case our needs change down the road. Good luck.
> 
> Carl Friedberg, carl@comets.com
> 

Carl one thing you might want to look at (for the future) is the IDAPI
driver of Delphi/400.  This uses all of the standard TTable and database
components of Delphi.  This allows you to simply "switch" databases from
NT to AS400.  We have used it a little and it is fairly seamless.  The
only complication we have run into is the limitation on column (field)
names on the 400 vs Oracle.  

John Hall
Home Sales Company.
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---