LOW VALUES as a KEY

juares castro · New User Joined: 04 May 2012 Posts: 34 Location: Brazil

Hi everyone!
Could we use LOW VALUES as a key in DB2 table?
We have a flat file we use to REPRO to a VSAM file, but we will convert our system to Linux/Java and need to use now DB2 tables. First record has different information and it has in first 11 bytes as LOW VALUES as a key.

Thanks in advance.

Phrzby Phil · Posted: Sat Apr 07, 2018 2:38 am

You could have tried it to see what happened. This is the best way to learn anything.

enrico-sorichetti · Posted: Sat Apr 07, 2018 3:10 am

nowhere in the manuals for any data-base/data-management system
there are warnings abut the allowed/forbidden values of a key

Robert Sample · Posted: Sat Apr 07, 2018 3:19 am

juares castro · New User Joined: 04 May 2012 Posts: 34 Location: Brazil

Thanks to everyone!

And, Phrzby Phil, my understanding about the forum is share what we know and about our experience to help anybody. Indeed I could try first, but I have chosen searching here. It is a good manner to me to learn something.

Phrzby Phil · Posted: Mon Apr 09, 2018 7:19 pm

Juares -

I certainly agree with your comments about sharing. My intention is merely to encourage anyone new to technology (and this includes experts on this excellent forum who may from time to time be using certain tools for the first time) to learn as much as possible by experimenting. The lessons will stick much more rapidly and solidly this way.

When I was getting more involved with DB2, I had a sandbox set up for me where I could play around and try all kinds of stuff (e.g., experimenting with the so-called null indicator - "so-called" because if I remember, it indicates other stuff as well. Anyone wanting to clarify this please do.)

This also provided me with a collection of experiments and tests i could then build on and share with my team.

I'm retired now, but I wish you Good Luck and Happy Hunting.

Live Long and Prosper.

juares castro · New User Joined: 04 May 2012 Posts: 34 Location: Brazil

Thanks Phrzby Phil !
Long life for You too.

juares castro · New User Joined: 04 May 2012 Posts: 34 Location: Brazil

As I said before, we will convert our process to JAVA/LINUX and the current file is a VSAM, that is not supported in LINUX. And in this file first record has LOW-VALUES (X'0000...00') as key. That was my question.

enrico-sorichetti · Posted: Tue Apr 10, 2018 11:24 am

as already told ...
the data(base) management systems DO NOT CARE about the values of the keys
so any discussion why the TS want to use a "low value" is just a completely waste of time.

the topic has been pruned of the irrelevant posts

juares castro · New User Joined: 04 May 2012 Posts: 34 Location: Brazil

Enrico, i was just responding Phrzby Phi.

enrico-sorichetti · Posted: Tue Apr 10, 2018 11:36 pm

I was not commenting Your posts,
but the posts of the people questioning the why of a key containing low values