RE: Create table & Create Phisical File -- RPG400-L

Specify a PRIMARY KEY constraint.

Note: a primary key's field(s) must be unique and not NULL. You can't have an SQL defined table with
a non-unique key like you can with a DDS physical.

HTH,
Charles

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Cezary Krzywda
Sent: Monday, October 08, 2007 6:59 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Create table & Create Phisical File

Hello

In DDS I can create key fields using record format "K"

How Can I do it using SQL Create Table ?

Regards

Czarek

--------------------------------------------------------------
----------
Onninen Spolka z o.o.
02-295 Warszawa
ul. Emaliowa 28
NIP: PL5261032852
Nr KRS: 0000036846
Sad Rejonowy dla m.st. Warszawy, XIII Wydzial Krajowego
Rejestru Sadowego Kapital zakladowy: 8.322.000,00 PLN www.onninen.pl

-------------------------------------------
Ta wiadomosc, mogaca zawierac poufne informacje, przeznaczona
jest wylacznie dla jej adresata. Jakiekolwiek nieautoryzowane
przegladanie, uzywanie, kopiowanie, przechowywanie,
ujawnianie lub przesylanie tej wiadomosci i/lub jakichkolwiek
jej zalacznikow, jest surowo wzbronione. Jezeli otrzymali
Panstwo te wiadomosc przez pomylke, prosimy o odeslanie jej
nadawcy a nastepnie zniszczenie wiadomosci.
Opinie i inne informacje zawarte w tej wiadomosci, ktore nie
dotycza prowadzonej przez Onninen Sp. z o.o. dzialalnosci,
powinny byc traktowane jako zarowno niepochodzace, jak i
nieautoryzowane przez Onninen Sp. z o.o. Dziekujemy za wspolprace.
-------------------------------------------
This e-mail that may contain privileged and confidential
information is intended only for the addressee. Any
unauthorized review, use, copying, storage, disclosure or
distribution of this e-mail and any attachments is strictly
prohibited. If you have received this e-mail by mistake,
please return it to the sender and then destroy the message.
Opinions or other information in this e-mail that do not
relate to the official business of Onninen shall be
understood to be neither given nor endorsed by Onninen. Thank
you for your cooperation.
-------------------------------------------
--
This is the RPG programming on the AS400 / iSeries (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.