 |
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 42 matches |
| Author | Message |
|---|---|
 Topic: Can we check DB2 table in sort |
|
| shyamsaravan Replies: 4 Views: 3993 |
 Forum: Utilities Posted: Thu Apr 12, 2012 7:40 am Subject: Can we check DB2 table in sort |
| Hi;
I have a question like.. We have to match two PS files and the unmatching records should be wriiten in another file,before that we have to check the data existence in the DB2 table.. Is ... |
|
| Topic: How to refine the query to make faster |
|
| shyamsaravan Replies: 2 Views: 2842 |
Forum: Database Posted: Mon Feb 06, 2012 8:42 am Subject: How to refine the query to make faster |
| Hi;
Facing the performance issue..it takes more time to execute the below query on real system and got time expired...error SELECT t1.p_la , t1.p1_nn , t1.p2_nn , t1.p_dd ... |
|
| Topic: Deleted rows needs to insert into the table |
|
| shyamsaravan Replies: 5 Views: 3742 |
Forum: Database Posted: Tue Nov 15, 2011 2:54 am Subject: Deleted rows needs to insert into the table |
| Thank you so much..
I am performing the INSERT query first and performing the DELETE query in the program..like below.. PERFORM INSERT-PARA. PERFORM DELETE-PARA. INSERT-PARA. EXEC SQL IN ... |
|
| Topic: Deleted rows needs to insert into the table |
|
| shyamsaravan Replies: 5 Views: 3742 |
Forum: Database Posted: Mon Nov 14, 2011 7:28 am Subject: Deleted rows needs to insert into the table |
| Hi;
Thanks for the response; Both table having almost similar columns along with distinct columns P_TABLE column details P_LOC ,P_NO ,H_NAME ,H_AGE ,M_TXT ,L_NAME ,P_ID ,INV_DT ,CRE_ ... |
|
| Topic: Deleted rows needs to insert into the table |
|
| shyamsaravan Replies: 5 Views: 3742 |
Forum: Database Posted: Fri Nov 11, 2011 2:44 am Subject: Deleted rows needs to insert into the table |
| Hi
I need to insert the multiple rows to the another table(A_TABLE) whatever row deleted in the below query DELETE FROM P_TABLE T1 WHERE T1.PO_LC = 'AA' ... |
|
| Topic: SOC4 Error in MOVE |
|
| shyamsaravan Replies: 4 Views: 5162 |
Forum: Application Programming Posted: Wed Nov 09, 2011 8:58 am Subject: SOC4 Error in MOVE |
| Thanks for the reply..
I checked once..already,intialized the WS table values.. I will try with the MOVE statement changes and let you know.. Thanks again.. |
|
| Topic: SOC4 Error in MOVE |
|
| shyamsaravan Replies: 4 Views: 5162 |
Forum: Application Programming Posted: Wed Nov 09, 2011 5:21 am Subject: SOC4 Error in MOVE |
| Hi;
I am receiving the SOC04 error.Please find the details 01 WS-RECV-PARM-FULL PIC X(51775). 01 WS-RECV-PARM-NEXT REDEFINES WS-RECV-PARM-FULL. 05 ... |
|
| Topic: Sql 901 error |
|
| shyamsaravan Replies: 3 Views: 3901 |
Forum: Database Posted: Tue Nov 01, 2011 2:42 am Subject: Sql 901 error |
| Thanks for the reply...
But,If the StoredProc has been compiled again means that Error would not come.. So that every time ,Has to compile the Proc again and again |
|
| Topic: Sql 901 error |
|
| shyamsaravan Replies: 3 Views: 3901 |
Forum: Database Posted: Mon Oct 31, 2011 5:51 am Subject: Sql 901 error |
| Hi;
Please help me on that below error.. UNSUCCESSFUL EXECUTION CAUSED BY A SYSTEM ERROR THAT DOES NOT PRECLUDE THE SUCCESSFUL EXECUTION OF SUBSEQUENT SQL STATEMENTS. SQLCODE=-901, SQLSTATE= ... |
|
| Topic: Format in year |
|
| shyamsaravan Replies: 2 Views: 2489 |
Forum: Database Posted: Wed Oct 19, 2011 6:01 am Subject: Format in year |
| Hi;
Given query gives the result like SELECT T1.* , YEAR(current_date) + 1 + SIGN( YEAR(DT_INP) ... |
|
| Topic: How to modify the query |
|
| shyamsaravan Replies: 19 Views: 14519 |
Forum: Database Posted: Thu Oct 06, 2011 6:02 am Subject: How to modify the query |
| Hi;
The posted code(Kolusu) is ok with us,the only thing is we have some issues of row returns to the result set..I just explained in the previous post The query missed some of the records wh ... |
|
| Topic: How to modify the query |
|
| shyamsaravan Replies: 19 Views: 14519 |
Forum: Database Posted: Tue Oct 04, 2011 4:10 am Subject: How to modify the query |
| Hi;
No one helped me..They did not have the answer..so that i came again to Forum |
|
| Topic: How to modify the query |
|
| shyamsaravan Replies: 19 Views: 14519 |
Forum: Database Posted: Mon Oct 03, 2011 8:12 am Subject: How to modify the query |
| Hi
Here i have copied the code as per the direction..it doesnt give the prober output SELECT DISTINCT C.IN_LOC ,C.PART_NO ,C.MATT_DE ,C.CALEN_YEAR ,C ... |
|
| Topic: How to modify the query |
|
| shyamsaravan Replies: 19 Views: 14519 |
Forum: Database Posted: Wed Sep 21, 2011 8:54 am Subject: How to modify the query |
| Many Thanks Kolusu;
As part of your suggestion is good for me..It never happens again...I am trying my level best to solve it. Thank you very much for the kind co-operation.  |
|
| Topic: How to modify the query |
|
| shyamsaravan Replies: 19 Views: 14519 |
Forum: Database Posted: Tue Sep 20, 2011 6:42 am Subject: How to modify the query |
| Hi Kolusu;
CASE WHEN C.EFF_DT IS NULL THEN NULL ELSE C.WKLY_PR END ,C.EFF_DT ,CASE WHEN C.EFF_DT IS NULL THEN NULL ELSE C.USER_NAME END the above CASE statement eleminates the ent ... |
|
All times are GMT - 5 Hours |