IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Need information about not equal condition in DB2.


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sivasaras

New User


Joined: 29 Sep 2007
Posts: 93
Location: chenna/i-

PostPosted: Tue Jun 21, 2011 10:27 pm
Reply with quote

Please dont comment like this
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10888
Location: italy

PostPosted: Tue Jun 21, 2011 10:44 pm
Reply with quote

Quote:
Please dont comment like this

Quote:
when i ran the query through the job, it is taking more CPU time to process.

if You want better comments learn to post better comments/questions/concerns yourself icon_evil.gif
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India

PostPosted: Wed Jun 22, 2011 3:47 pm
Reply with quote

sivasaras wrote:
please dont be angry yaar
Please avoid to use such words on a professional forum like this and where people from diverse background log-in. Showing the requested attitude will add to your own character.

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

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Jun 22, 2011 4:30 pm
Reply with quote

well, the TS has posted his performance problem with the IN List example,
in another forum.
it appears he was offended by poster here.
I don't really think we have trashed him enough.
i mentioned trying to use the EXISTS format,
and his response was 'HOW DO YOU DO IT WITH EXISTS?'

The TS is a typical non-reader, non-thinker, only a poor little lamb that
has no ability to think laterally.

the exists format was posted by GUYC immediately before Marso provided the IN List logic.

I doubt that he will be back, though I hope he will,
I have many more disparaging adjetives that I want to use.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix

PostPosted: Wed Jun 22, 2011 6:28 pm
Reply with quote

Hello,

Quote:
Please dont comment like this
Please do not provide dialog that demands comments like this be posted in reply.

You should be thankful that some of us seniors are willing to help with the asking of the question in addition to providing technical suggestions.

Keep in mind - you took the reply personal. No reason to do that - no one (or very few) even knows who you are.
Back to top
View user's profile Send private message
Phrzby Phil

Senior Member


Joined: 31 Oct 2006
Posts: 1050
Location: Richmond, Virginia

PostPosted: Wed Jun 22, 2011 8:20 pm
Reply with quote

Nor where you are nor how fast you are going.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Wed Jun 22, 2011 8:39 pm
Reply with quote

Phrzby Phil wrote:
Nor where you are nor how fast you are going.

heisenberg uncertainty principle ?

stupid joke :
Heisenberg was pulled over by the police and asked : "Do you know how fast you were going?'
Heisenberg answered : 'No, but i know where I am.'
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Wed Jun 22, 2011 8:44 pm
Reply with quote

Heisenberg was a German. One of the thinnest books in the world is :
100 years German humor.
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1787
Location: Bloomington, IL

PostPosted: Wed Jun 22, 2011 8:52 pm
Reply with quote

GuyC wrote:
stupid joke :
Heisenberg was pulled over by the police and asked : "Do you know how fast you were going?'
Heisenberg answered : 'No, but i know where I am.'

Dirac and Heisenberg were out for a drive. Heisenberg warned Dirac, "Be careful about speeding; the local police are always looking for speeders to ticket".

"Don't worry", said Dirac, "I'm going exactly sixty miles per hour".

"Oh, great", grumbled Heisenberg, "now we're lost!"
Back to top
View user's profile Send private message
Phrzby Phil

Senior Member


Joined: 31 Oct 2006
Posts: 1050
Location: Richmond, Virginia

PostPosted: Wed Jun 22, 2011 11:04 pm
Reply with quote

Einstein goes to the station to take a trip. Unsure of which platform, he asks the conductor: "Sir, does Berlin stop at this train?"
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2 Goto page Previous  1, 2

 


Similar Topics
Topic Forum Replies
No new posts Add condition to a FINDREP SORT card DFSORT/ICETOOL 4
No new posts To Omit records based n SORT condition DFSORT/ICETOOL 6
No new posts Using Multiple IFTHEN and WHEN condit... SYNCSORT 12
No new posts VSAM LISTCAT INFORMATION JCL & VSAM 2
No new posts Capturing Job Execution Information All Other Mainframe Topics 3
Search our Forums:

Back to Top