 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 31 matches |
| Author | Message |
|---|---|
 Topic: Co-related subquery |
|
| arshadh Replies: 8 Views: 4218 |
 Forum: 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: 17377 |
Forum: Interview Q & A Posted: Tue Aug 31, 2010 2:03 am Subject: Interview questions |
| Thanks Kolusu. | |
| Topic: Interview questions |
|
| arshadh Replies: 5 Views: 17377 |
Forum: 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: 2461 |
Forum: 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: 5509 |
Forum: 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: 5509 |
Forum: 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: 5509 |
Forum: 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: 2461 |
Forum: 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: 2461 |
Forum: 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: 2134 |
Forum: 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: 1958 |
Forum: 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: 3207 |
Forum: 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: 3186 |
Forum: 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: 2596 |
Forum: 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: 4811 |
Forum: 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... |
|
All times are GMT - 5 Hours |