characters in the db2 interview question guide

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
bbxrider
Member
Posts: 2
Joined: Wed Mar 03, 2010 12:53 am

characters in the db2 interview question guide

Post by bbxrider » Wed Mar 03, 2010 1:05 am

In the db2 interview questions, on this site, there are these characters, ?_? i've googled around and am not finding what they resolve to? sometimes they would be appear to be & and other times * and they always appear at the end of a question, just after the question mark, ie, '?'
bob
BBX

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

Post by Natarajan » Wed Mar 03, 2010 10:31 am

Yes. you are correct.
I dont think those are part of questions. Might be copy paste error occured while moving from data source to to web.
Natarajan
Chennai

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Fri Mar 05, 2010 2:34 pm

Pardon my ignorance - but what are we talking about here?
Regards,
Anuj

bbxrider
Member
Posts: 2
Joined: Wed Mar 03, 2010 12:53 am

Post by bbxrider » Sat Mar 06, 2010 12:46 am

its not much, here is a sample:

9) How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?
SELECT FIRSTNAME || � � || LASTNAME FROM EMP;

15) What is 'LIKE' used for in WHERE clause? What are the wildcard characters? �
LIKE is used for partial string matches. �%� ( for a string of any character ) and �_� (for any single character ) are the two wild card characters.

those question marks translate out to ?_? in a text editor, i was trying to figure out what they were, no biggy
BBX

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Sat Mar 06, 2010 1:54 pm

I see...
Regards,
Anuj

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others