MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 31 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Co-related subquery
arshadh

Replies: 8
Views: 3842

PostForum: Database   Posted: Wed Sep 01, 2010 2:14 am   Subject: Co-related subquery
Hi White,

This page has a better explanation of correlated subqueries.

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.apsg/db2z_correlatedsubqueries.htm
  Topic: Interview questions
arshadh

Replies: 5
Views: 15377

PostForum: Interview Q & A   Posted: Tue Aug 31, 2010 2:03 am   Subject: Interview questions
Thanks Kolusu.
  Topic: Interview questions
arshadh

Replies: 5
Views: 15377

PostForum: Interview Q & A   Posted: Mon Aug 30, 2010 2:20 am   Subject: Interview questions
Hello Phantom,

Reg question 9,

I tried a program and found that we can use numeric/integer data type in the Linkage section, but the maximum size is limited to 9(18 ) .

Pls correct me if I a ...
  Topic: Can a USER with no special rights create a table..?
arshadh

Replies: 4
Views: 2180

PostForum: Database   Posted: Thu Sep 27, 2007 11:59 pm   Subject: Can a USER with no special rights create a table..?
Thanks for your suggestions,,,,,
  Topic: Database Deadlock causing program abend.....
arshadh

Replies: 7
Views: 5109

PostForum: Database   Posted: Thu Sep 27, 2007 11:58 pm   Subject: Database Deadlock causing program abend.....
Thanks for your Suggestions....
  Topic: Database Deadlock causing program abend.....
arshadh

Replies: 7
Views: 5109

PostForum: Database   Posted: Mon Sep 24, 2007 10:53 pm   Subject: Database Deadlock causing program abend.....
Thanks for ur comments..

Can you explain in detail the things I need to done..?I really can't understand your third and fourth point...

Our table space is divided based on the products. Both PRD ...
  Topic: Database Deadlock causing program abend.....
arshadh

Replies: 7
Views: 5109

PostForum: Database   Posted: Mon Sep 24, 2007 9:05 am   Subject: Database Deadlock causing program abend.....
Dear All,

In our database we have segmented tablespaces (i.e The table spaces are partitioned based on the Product type the partition can hold..)

Now the Problem is when we run a maintenance job ...
  Topic: Can a USER with no special rights create a table..?
arshadh

Replies: 4
Views: 2180

PostForum: Database   Posted: Mon Sep 24, 2007 6:59 am   Subject: Can a USER with no special rights create a table..?
Thanks Videlord,

I ran the Check DAta and got the Row id 's of troubling rows...

But How to associate the particular ROW ID with the row...Please help me..
  Topic: Can a USER with no special rights create a table..?
arshadh

Replies: 4
Views: 2180

PostForum: Database   Posted: Wed Sep 12, 2007 10:51 am   Subject: Can a USER with no special rights create a table..?
Is there any Tablespace in a particular Database into which an USER with no SYSADM or DBADM rights can create a table for test purpose?

Because one of tables have gone to CHKP state and I need to ...
  Topic: Help needed in Query using Count & max together
arshadh

Replies: 3
Views: 1913

PostForum: Database   Posted: Wed Jul 11, 2007 11:51 pm   Subject: Help needed in Query using Count & max together
Dear Kolusu,

Now I have posted the feedback for most of my queries..
  Topic: NEED help in a query...
arshadh

Replies: 2
Views: 1763

PostForum: Database   Posted: Wed Jul 11, 2007 11:50 pm   Subject: NEED help in a query...
Thanks Kolusu, the query works fine..
  Topic: COBOL Version Support
arshadh

Replies: 5
Views: 2846

PostForum: Application Programming   Posted: Wed Jul 11, 2007 11:49 pm   Subject: COBOL Version Support
The migration plan was dropped because of funding issues in the project...Will get back to u all if i face such problem in future.

Thanks for your help...
  Topic: DB2 Stored Procedure - NULL Indicator issue.
arshadh

Replies: 4
Views: 2892

PostForum: Database   Posted: Wed Jul 11, 2007 11:47 pm   Subject: DB2 Stored Procedure - NULL Indicator issue.
Dear All,

The Problem was with myself. I declared all the linkage section variables under one 01 level. But my seniors told me to decalre them as indivdual 01 level variables.. Then the problem was ...
  Topic: Table loading... Unable to meet Requirement
arshadh

Replies: 5
Views: 2340

PostForum: Database   Posted: Wed Jul 11, 2007 11:45 pm   Subject: Table loading... Unable to meet Requirement
The problem is soved by going for insert update delete logic . The yesterdays and current days file are compared based on sorted primary keys.

The following logic was used to solve this... Here TOD ...
  Topic: SORT does not really sorting...
arshadh

Replies: 11
Views: 4260

PostForum: Job Control Language(JCL)   Posted: Wed Jul 11, 2007 11:41 pm   Subject: SORT does not really sorting...
Dear All,
The Problem is solved . I used +4 bytes logic (File type VB) and it worked well.Thnks for all who helped in this...
 
Page 1 of 3 Goto page 1, 2, 3  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group