Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
What is null indicator variable

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
karthi_ind

Active User


Joined: 24 Feb 2004
Posts: 131
Location: Chennai

PostPosted: Thu Jul 08, 2004 3:41 pm    Post subject: What is null indicator variable
Reply with quote

hi

1) whatz null indicator variable?

2) whatz use of db2 utilities? (real time)

such as load, quisce, copy, check data

3) if not null with default is specified during an 'alter' command what will be the default values of date, time, timestamp ?

4) whatz timestamp mismatch error (-818) ?

5) can we use db2's 'like' operator for numeric values? or the operator is meant only for alphabetiv values?

can i give select * from acc-table where acc-no like '989%'

anbudan
karthi G.
Back to top
View user's profile Send private message

unna

New User


Joined: 15 Oct 2004
Posts: 17

PostPosted: Fri Oct 15, 2004 3:29 pm    Post subject:
Reply with quote

Hi Karthi,
I have some answers for your few questions.

1. Null Indicator:
used by DB2 to specify whether a column contains null or not null values. if the value of Null indicator is 0 then NOT NULL.
If -1 then Null and -2 Truncated.

If u need some more informations i can provide.


4. -818 - The Precompiler generated timestamp X in the load module is different from bind Time stamp Y in DBRM. Recompile it again to solve the problem.

5. Like operators can only be used for Alphabets I suppose.
eg:

1. select * from emp
where empname LIKE 'A%'

It will take the names of the employees starting with alphabet A .

2. Select * from emp
where empname LIKE '-AM%'

It will take the only employee names having 2nd and 3rd letter as AM .

Thanks,
Back to top
View user's profile Send private message
janardhana Reddy

New User


Joined: 20 Oct 2004
Posts: 17
Location: Bangalore

PostPosted: Wed Oct 20, 2004 4:35 pm    Post subject:
Reply with quote

For the fifth question the answer:

Yes, we can use numaric value in the like operator.

Thanks
Janardhan
Back to top
View user's profile Send private message
unna

New User


Joined: 15 Oct 2004
Posts: 17

PostPosted: Wed Oct 20, 2004 5:57 pm    Post subject:
Reply with quote

Hi,

Can u quote some examples where in Numeric values are used in Like operator?

Regards,
Back to top
View user's profile Send private message
janardhana Reddy

New User


Joined: 20 Oct 2004
Posts: 17
Location: Bangalore

PostPosted: Thu Oct 21, 2004 11:44 am    Post subject:
Reply with quote

Like operator will be performed on character data only.


select * from pr2.se_number where se_number_cd like '999%' ;
Back to top
View user's profile Send private message
janardhana Reddy

New User


Joined: 20 Oct 2004
Posts: 17
Location: Bangalore

PostPosted: Thu Oct 21, 2004 11:49 am    Post subject:
Reply with quote

Unna,

karthi's question is is it possible to use numaric values in the LIKE operator. He had give example select * from acc-table where acc-no like '989%' .. He is asking that above query is correct or not.


Have provided clear information
Back to top
View user's profile Send private message
unna

New User


Joined: 15 Oct 2004
Posts: 17

PostPosted: Thu Oct 21, 2004 6:15 pm    Post subject:
Reply with quote

Hi,

[quote]

can we use db2's 'like' operator for numeric values? or the operator is meant only for alphabetiv values?

The answer is only Alphabetic values.
for that i have given some examples.
which implies the example given by karthik goes not hold good.

Regards,
Back to top
View user's profile Send private message
unna

New User


Joined: 15 Oct 2004
Posts: 17

PostPosted: Thu Oct 21, 2004 6:22 pm    Post subject:
Reply with quote

hi,

I think iam on the right track from my first post to this Query onwards.
Anyhow, Thank you for ur reply.

Regards,
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 NULL Values display V S Amarendra Reddy DB2 3 Thu Sep 07, 2017 6:59 pm
No new posts Moving values to a variable of copybo... Vignesh Sid COBOL Programming 6 Wed Sep 06, 2017 1:04 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts Move from Comp3 variable to Edited Va... sreekusr COBOL Programming 8 Thu Aug 10, 2017 4:20 pm
No new posts Can I traverse a STEM variable? chong.zhou CLIST & REXX 5 Wed May 31, 2017 3:54 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us