Re: DDL's - tables and keys

I thought I was sending this to the group, as it turns out I sent it to
Rob only.  My apologies......



Just so everyone knows, I did receive Rob's message and I called him this
morning to let him know that I am just chalking the day to a bad hair day
for everybody and that there is no harm or foul.

I will say that I appreciated Rob apologizing through the group...and
without sounding too sappy I thought it was a classy move on his part.

It is one thing to receive an email from someone doing the same thing and
quite another for them to do it publicly.

Rob, you are ok in my  book and I appreciate all that I have learned from
you over the years.

Douglas




From:
rob@xxxxxxxxx
To:
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Cc:
"Doug Palme" <DPalme@xxxxxxxxxxx>
Date:
10/20/2009 05:57 PM
Subject:
Re: DDL's - tables and keys



Doug,

I didn't mean that to sound harsh.  There's a lot of times that I get a
question and I'll whip up a program or something and try it out.  I'm
really sorry.  I hope you don't leave.

I could go on about how I didn't know you tried this or that, but that
would only dilute my apology and that would be wrong.  It bugs me when
someone says "I'm sorry you feel that way but ..." meaning that they felt
they were justified.

Hoping it was just a bad day thing and you reconsider.

Also, I didn't think about ALWNULL.  Good to know, but I've gotten out of
the habit of processing files in CL.  Granted, it's improved over the
ages, (but waiting through the "Middle Ages" was a long dry spell).


Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com




From:
"Doug Palme" <DPalme@xxxxxxxxxxx>
To:
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:
10/20/2009 04:14 PM
Subject:
Re: DDL's - tables and keys
Sent by:
midrange-l-bounces@xxxxxxxxxxxx




I probably did not word that correctly Rob, I did try it and I get a data
mapping error, my question was more along the lines of is there a way to
do this....

Tell ya what, I suppose I am too much of a pain here for you so I will
just drop the list and when I have a question I will send them to a select

group of people when needed.

No problem, no harm and no foul.......

A thanks to everyone for all the help from time to time it was greatly
appreciated; I will not bother the list again.

Douglas




From:
rob@xxxxxxxxx
To:
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:
10/20/2009 02:49 PM
Subject:
Re: DDL's - tables and keys
Sent by:
midrange-l-bounces@xxxxxxxxxxxx



How hard would that be to try, and then if the results were undesirable,
ask the list if you are doing something wrong?
Have you seen previous posts on how to check to see if a field was null?
Like if rolling your own RTV... command?


Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From:
"Doug Palme" <DPalme@xxxxxxxxxxx>
To:
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:
10/20/2009 03:34 PM
Subject:
Re: DDL's - tables and keys
Sent by:
midrange-l-bounces@xxxxxxxxxxxx



Thanks Charles,
Now I am being asked one additional question which I frankly cannot seem
to find the answer to......

Can a RECVF command in a CL read a record that has a null value?

I



From:
Charles Wilt <charles.wilt@xxxxxxxxx>
To:
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:
10/20/2009 09:34 AM
Subject:
Re: DDL's - tables and keys
Sent by:
midrange-l-bounces@xxxxxxxxxxxx



Doug, a primary key can be one or more fields.

CREATE TABLE CTSC_W/DOUGTEST (
 FLD1 CHAR (10 ) NOT NULL WITH DEFAULT,
 FLD2 CHAR (5 ) NOT NULL WITH DEFAULT,
 FLD3 INT NOT NULL WITH DEFAULT,
 PRIMARY KEY (FLD1, FLD2))

HTH,
Charles

On Tue, Oct 20, 2009 at 10:10 AM, Doug Palme <DPalme@xxxxxxxxxxx> wrote:

In looking at the manual it appears that the only option I have for

adding

a key is the primary key, at least at the table level.  If I want to use
more than one field I still have to create an index.

Since we still have some programmers using tables and indexes as if they
were PF's and LF's, I am trying to ascertain if there is any way to add

a

composite primary key to a table without an index?

I assume no from what I have read thus far......but if anyone knows of a
way or can offer clarification I would be most appreciative.

Douglas


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.