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

So
How Can I use Setll , SetGT .? Should I create index using CREATE INDEX in SQL ? But the problem is How can I use this index in RPG ?

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Wilt, Charles
Sent: Monday, October 08, 2007 4:00 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Create table & Create Phisical File

Unique?

Then you can't have a key on the SQL table.

Sorry, but that's just the way it works.

Is there no combination of current fields that are unique?

Even if KEY1,KEY2 aren't unique, if by adding KEY3 you can get a unique key into the file, you can add
KEY3 without needing to change any existing programs.

The only other way would be to a an auto-incrementing field to the file, but that would require
recompiling all existing RPG programs.

HTH,

Charles

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Cezary Krzywda
Sent: Monday, October 08, 2007 9:57 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: Create table & Create Phisical File

But fields are not uniqual

Pozdrawiam

Cezary Krzywda
Analityk, Dział Informatyki/
ICT Analyst, ICT Onninen Sp. z o.o.
Tel. +48 42 6768 877,
Mobile +48 502 19 77 61
Fax. +48 42 6768 800
Teolin 18B, Gmina Nowosolna,
92-701 ŁÓDŹ
Poland
cezary.krzywda@xxxxxxxxxx
www.onninen.pl

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Wilt, Charles
Sent: Monday, October 08, 2007 3:49 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Create table & Create Phisical File

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.

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

--------------------------------------------------------------
----------
Onninen Spółka z o.o.
02-295 Warszawa
ul. Emaliowa 28
NIP: PL5261032852
Nr KRS: 0000036846
Sąd Rejonowy dla m.st. Warszawy, XIII Wydział Krajowego
Rejestru Sądowego Kapitał zakładowy: 8.322.000,00 PLN www.onninen.pl

-------------------------------------------
Ta wiadomość, mogąca zawierać poufne informacje, przeznaczona
jest wyłącznie dla jej adresata. Jakiekolwiek nieautoryzowane
przeglądanie, używanie, kopiowanie, przechowywanie,
ujawnianie lub przesyłanie tej wiadomości i/lub jakichkolwiek
jej załączników, jest surowo wzbronione. Jeżeli otrzymali
Państwo tę wiadomość przez pomyłkę, prosimy o odesłanie jej
nadawcy a następnie zniszczenie wiadomości.
Opinie i inne informacje zawarte w tej wiadomości, które nie
dotyczą prowadzonej przez Onninen Sp. z o.o. działalności,
powinny być traktowane jako zarówno niepochodzące, jak i
nieautoryzowane przez Onninen Sp. z o.o. Dziękujemy za współpracę.
-------------------------------------------
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.