how many ways to pass the null values to db2 table if i declared as emp-id
eswar
Pass the null values to db2 table
Previous topic • Next topic • 10 posts
• Page 1 of 1
Pass the null values to db2 table
by eswarreddy » Wed Oct 06, 2010 2:25 pm
- eswarreddy
- Posts: 2
- Joined: Tue Oct 05, 2010 10:56 am
- Has thanked: 0 time
- Been thanked: 0 time
Re: db2
by enrico-sorichetti » Wed Oct 06, 2010 3:27 pm
please use meaningful titles when posting
posts with silly/useless titles will usually be skipped by people looking at the forums
if You are sloppy in posting You will lose many opportunities
same comment applies to Your other post titled jcl
it would be useful for you to read and meditate on
How To Ask Questions The Smart Way
http://catb.org/~esr/faqs/smart-questions.html
to make the most out of the questions You ask
posts with silly/useless titles will usually be skipped by people looking at the forums
if You are sloppy in posting You will lose many opportunities
same comment applies to Your other post titled jcl
it would be useful for you to read and meditate on
How To Ask Questions The Smart Way
http://catb.org/~esr/faqs/smart-questions.html
to make the most out of the questions You ask
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
- enrico-sorichetti
- Global moderator
- Posts: 3003
- Joined: Fri Apr 18, 2008 11:25 pm
- Has thanked: 0 time
- Been thanked: 164 times
Re: db2
by dick scherrer » Thu Oct 07, 2010 2:30 am
Hello,
As there is no such thing as a null value, a null value cannot be "passed".
Suggest you read about what NULL really means in db2.
NULL (by definition) is the absence of any value at all.
There are zero ways. . .how many ways to pass the null values to db2 table
As there is no such thing as a null value, a null value cannot be "passed".
Suggest you read about what NULL really means in db2.
NULL (by definition) is the absence of any value at all.
Hope this helps,
d.sch.
d.sch.
-
dick scherrer - Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
- Has thanked: 3 times
- Been thanked: 93 times
Re: db2
by GuyC » Thu Oct 07, 2010 5:11 pm
the question could be :
How do you set a column (empid) of a certain row in a certain table to null ?
the number of ways are endless , but the most common in COBOL is using a null-indicator variable.
How do you set a column (empid) of a certain row in a certain table to null ?
the number of ways are endless , but the most common in COBOL is using a null-indicator variable.
exec sql
update test1
set empid = null
where col1 = 'B'
end-exec
exec sql
insert into test1(col1,empid) values ('E',null)
end-exec
exec sql
insert into test1(col1) values ('D')
end-exec
move -1 to ws-empid-ind
exec sql
update test1
set empid = :ws-empid:ws-empid-ind
where col1 = 'B'
end-exec
move -1 to ws-empid-ind
exec sql
insert into test1(col1,empid) values (:ws-col1,:ws-empid:ws-empid-ind)
end-exec
update test1
set empid = null
where col1 = 'B'
end-exec
exec sql
insert into test1(col1,empid) values ('E',null)
end-exec
exec sql
insert into test1(col1) values ('D')
end-exec
move -1 to ws-empid-ind
exec sql
update test1
set empid = :ws-empid:ws-empid-ind
where col1 = 'B'
end-exec
move -1 to ws-empid-ind
exec sql
insert into test1(col1,empid) values (:ws-col1,:ws-empid:ws-empid-ind)
end-exec
I can explain it to you, but i can not understand it for you.
Re: Pass the null values to db2 table
by RENGANATHAN » Sat Nov 27, 2010 6:38 pm
using load utility u can pass the null values
learner(admin)
- RENGANATHAN
- Posts: 9
- Joined: Thu Jul 29, 2010 2:23 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: Pass the null values to db2 table
by dick scherrer » Sun Nov 28, 2010 9:19 am
Hello,
Did you read and understand the previous replies to this topic?
There is no such thing as a "null value" so no null value can be "passed".
The null indicator may be set, but there is no value to place in the column as there is no value that is null. . . There are 256 possible bit patterns for one byte (x'00' thru x'FF'). Not one of these possible values is a null value.
NO, it cannot. . .using load utility u can pass the null values
Did you read and understand the previous replies to this topic?
There is no such thing as a "null value" so no null value can be "passed".
The null indicator may be set, but there is no value to place in the column as there is no value that is null. . . There are 256 possible bit patterns for one byte (x'00' thru x'FF'). Not one of these possible values is a null value.
Hope this helps,
d.sch.
d.sch.
-
dick scherrer - Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
- Has thanked: 3 times
- Been thanked: 93 times
Re: Pass the null values to db2 table
by dick scherrer » Mon Nov 29, 2010 6:15 am
RENGANATHAN ,
Your 2 most recent posts to this topic have been deleted. They were wrong. . .
It doesn't matter how you say it, there is NO null value. . . A column may be nullable, but there is no null value
You can test whether a column IS NULL, but this does test for a null value in the column.
Suggest you concentrate on a more thorough understanding of the basics before posting contradictions. . .
d
Your 2 most recent posts to this topic have been deleted. They were wrong. . .
It doesn't matter how you say it, there is NO null value. . . A column may be nullable, but there is no null value
You can test whether a column IS NULL, but this does test for a null value in the column.
Suggest you concentrate on a more thorough understanding of the basics before posting contradictions. . .
d
-
dick scherrer - Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
- Has thanked: 3 times
- Been thanked: 93 times
Re: Pass the null values to db2 table
by RENGANATHAN » Mon Nov 29, 2010 6:26 am
in that post am just told a method of passing "null" to clomun(not null value), am just a learner only ,am tried those method to pass "null" in a coloumn so am posted..
if there is anythng wrong in that means regret me....
if there is anythng wrong in that means regret me....
learner(admin)
- RENGANATHAN
- Posts: 9
- Joined: Thu Jul 29, 2010 2:23 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: Pass the null values to db2 table
by dick scherrer » Mon Nov 29, 2010 6:34 am
Hello,
From your earlier post:
One of the things we (the old guys<g>) stress is the importance of using the correct terms. There are many, many things that are "interchanged" that convey incorrect information.
From your earlier post:
using load utility u can pass the null values
Yes, we understand this - we were learners once alsoam just a learner only
Not to worryif there is anythng wrong in that means regret me....
One of the things we (the old guys<g>) stress is the importance of using the correct terms. There are many, many things that are "interchanged" that convey incorrect information.
Hope this helps,
d.sch.
d.sch.
-
dick scherrer - Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
- Has thanked: 3 times
- Been thanked: 93 times
Previous topic • Next topic • 10 posts
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- How can u identify null values in a table?
by ragur.satheesh » Mon Dec 13, 2010 12:18 pm - 2 Replies
- 2164 Views
- Last post by dick scherrer
Tue Dec 14, 2010 1:20 am
- How can u identify null values in a table?
-
- DB2 date column has some null values
by sindhu_raghu » Mon Mar 30, 2009 10:49 pm - 1 Replies
- 2672 Views
- Last post by dick scherrer
Tue Mar 31, 2009 12:48 am
- DB2 date column has some null values
-
- How can u retrieve the null values in a field?
by ragur.satheesh » Mon Dec 13, 2010 12:21 pm - 4 Replies
- 2924 Views
- Last post by chandrababun
Wed Dec 29, 2010 3:32 pm
- How can u retrieve the null values in a field?
-
- how to eliminate records with null values in any of the cols
by dvramanad » Mon Sep 14, 2009 1:16 pm - 2 Replies
- 1953 Views
- Last post by momi sabag
Mon Sep 21, 2009 11:23 am
- how to eliminate records with null values in any of the cols
-
- how to eliminate records with null values in any of the cols
by dvramanad » Tue Sep 15, 2009 9:10 pm - 1 Replies
- 1996 Views
- Last post by dick scherrer
Wed Sep 16, 2009 12:07 am
- how to eliminate records with null values in any of the cols