 |
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 9 matches |
| Author | Message |
|---|---|
 Topic: need help in forward & backward scroll cursor |
|
| rameshb Replies: 6 Views: 3153 |
 Forum: Database Posted: Wed Feb 18, 2009 10:18 pm Subject: need help in forward & backward scroll cursor |
| hi kolusu,
i mean i need sql query select from a,b,c from xyz where (x = :tempx and y>:tempy) or (x>:tempx) whether this query will work to fetch next set of records in forwaard curso ... |
|
| Topic: need help in forward & backward scroll cursor |
|
| rameshb Replies: 6 Views: 3153 |
Forum: Database Posted: Wed Feb 18, 2009 1:58 pm Subject: need help in forward & backward scroll cursor |
| hi
i am using the following cursor for displaying the values in my online screen for the first time SELECT A,B,C FROM XYZ ORDER BY A,B any one can help me how to write forward and backward ... |
|
| Topic: Need to know the child segment present or not |
|
| rameshb Replies: 1 Views: 2543 |
Forum: IMS Posted: Mon Dec 08, 2008 2:23 pm Subject: Need to know the child segment present or not |
| Hi
I need one clarification In my application, I have one root segment xxx under root one child segment yyy under that child segment one more child zzz I have a key for the xxx segment i do ... |
|
| Topic: Maximum length of string we can give in IN predicate |
|
| rameshb Replies: 3 Views: 5022 |
Forum: Database Posted: Wed Sep 19, 2007 1:28 pm Subject: Maximum length of string we can give in IN predicate |
| i am passing through host variable
IN(ASN_STRG) like this where ASN_STRG is host variable this host variable is coming like ABCDE,QBC,WER,....... LIKE THIS |
|
| Topic: Maximum length of string we can give in IN predicate |
|
| rameshb Replies: 3 Views: 5022 |
Forum: Database Posted: Wed Sep 19, 2007 11:50 am Subject: Maximum length of string we can give in IN predicate |
| hi,
i have a scenario where i need to pass the String of length 2000 bytes in IN predicate of the SELECT statement when i am doing the same i am getting SQLCODE = -134 can anyone tell me wha ... |
|
| Topic: performance issue in DB2 Stored procedure |
|
| rameshb Replies: 1 Views: 4201 |
Forum: Database Posted: Tue Sep 11, 2007 1:37 pm Subject: performance issue in DB2 Stored procedure |
| After tesing the SP DBA saying that
SP hold locks on the global temp table and that |
|
| Topic: performance tuning for sql query |
|
| rameshb Replies: 9 Views: 4914 |
Forum: Database Posted: Mon Aug 27, 2007 4:29 pm Subject: performance tuning for sql query |
| Hi kolusu,
V_I_TO_ASN , V_T_CUTOFF_DATE input variables to the Stored procedure we are trying to insert using this sql into temporary table there are no indexes on any ... |
|
| Topic: performance tuning for sql query |
|
| rameshb Replies: 9 Views: 4914 |
Forum: Database Posted: Mon Aug 27, 2007 2:48 pm Subject: performance tuning for sql query |
| i am sorry the query looks like this
SELECT I_REQ_SRV ,I_TYP_REQ_SRV ,T_CTE_TRG ... |
|
| Topic: performance tuning for sql query |
|
| rameshb Replies: 9 Views: 4914 |
Forum: Database Posted: Mon Aug 27, 2007 1:40 pm Subject: performance tuning for sql query |
| hi
i have one Sql query i need to improve the performance of the query SELECT I_REQ_SRV, I_TYP_REQ_SRV, T_CTE_TRG, T008 . I_RSN, T004 . I_STA, I_PRI, I_TO_ASN, I_LCK, T004 . ... |
|
All times are GMT - 5 Hours |