Create Table With Different Record Format

[elbeboy2k]

I would like to know if there is a way to Create a Table with a Different Record Format. An example would be a table name customer, whe I use a SQL instruction to Create a table it is created with a record format customer; and what I would like to see is that it is created as Customer/Cusrec. This is going to be used in an RPG program

Any help would be apreciated

 

[blom0344]

Hello Elbeboy2k,

What do you mean by customer record format? In the create table SQL you can modify the table name to anything you want, bar some reserved keywords/signs. (I do not know if DB2 accepts slash in a table-name) T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com