Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Mixed queries on DB2 and SQL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
Gousiya Mulla

New User


Joined: 02 Jun 2008
Posts: 87
Location: Bangalore

PostPosted: Wed May 19, 2010 9:07 pm    Post subject: Mixed queries on DB2 and SQL
Reply with quote

1. How can we increase the length of column .

Me : If it is in production we need to take the back up of the existing data (with complete plan to re-process that data back to production) , and modify the table using alter option .

2. How can we add columns in middlle of the table .

Me : If it is in production we need to take the back up of the existing data (with complete plan to re-process that data back to production) , and redefine the table (probably REORG)

3. Without using 'WHERE' condition , how can we retrieve colums having NULL values ??

4. How to retrieve yesterday's date ?

Me : We can do this using currentdate-1 . This might be saved in the predefined tables .
But I am not sure which table . SQL for this please ?

It would be great if you could provide your comments on this .
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed May 19, 2010 9:13 pm    Post subject:
Reply with quote

Hi Gousiya ,

I would suggest you to read the manual. It seems that you need to brush up your skills.
Back to top
View user's profile Send private message
Gousiya Mulla

New User


Joined: 02 Jun 2008
Posts: 87
Location: Bangalore

PostPosted: Wed May 19, 2010 9:20 pm    Post subject:
Reply with quote

Sure ... thanks !!
Back to top
View user's profile Send private message
ms0033436

New User


Joined: 20 Nov 2008
Posts: 15
Location: Pune

PostPosted: Mon May 31, 2010 5:28 pm    Post subject:
Reply with quote

thanks
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need help with below queries ashek15 DB2 3 Thu Mar 23, 2017 1:38 am
No new posts Summing on Mixed Case Literals Roy Ware SYNCSORT 3 Tue Jan 03, 2017 10:18 pm
No new posts A not very Christmassy PL/I tale, wit... prino PL/I & Assembler 3 Mon Dec 26, 2016 1:01 am
No new posts Running queries against OLTP Database A_programmers DB2 3 Tue Jul 14, 2015 4:51 pm
No new posts Selective execution of a queries Delip DB2 9 Fri Jan 16, 2015 3:51 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us