 |
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 45 matches |
| Author | Message |
|---|---|
 Topic: Reading a ISPF TABLE |
|
| Rama_Prayaga Replies: 2 Views: 3041 |
 Forum: TSO and ISPF Posted: Thu Nov 29, 2007 11:05 am Subject: Reading a ISPF TABLE |
| Hi Vivek,
Thank you for you help .Acuallty i was not looping properly. It is fixed.Thank you for your help Rama |
|
| Topic: Reading a ISPF TABLE |
|
| Rama_Prayaga Replies: 2 Views: 3041 |
Forum: TSO and ISPF Posted: Wed Nov 28, 2007 7:22 am Subject: Reading a ISPF TABLE |
| Hi ,
How should i read a ISPF table . Followlling is my required I have a table by name TABLI which has data , i have to read .There are no keys to this table .I need to read the table sequent ... |
|
| Topic: ISPF services in Batch rexx using LIBDEF |
|
| Rama_Prayaga Replies: 3 Views: 2659 |
Forum: TSO and ISPF Posted: Wed Nov 21, 2007 11:41 am Subject: ISPF services in Batch rexx using LIBDEF |
| Hi Kolusu,
Thanks a lot man.The problem got resolved . But One thing I am still not clear I used ISPSSTART. Probably I was not using the right profile. For three days this small thing beat he ... |
|
| Topic: ISPF services in Batch rexx using LIBDEF |
|
| Rama_Prayaga Replies: 3 Views: 2659 |
Forum: TSO and ISPF Posted: Wed Nov 21, 2007 8:43 am Subject: ISPF services in Batch rexx using LIBDEF |
| Hi ,
I am trying to do the following thing in batch mode in rexx program and I am getting the following issues. In the following step i trying use TABLIB for accessing table *-* "LIBDEF ... |
|
| Topic: select WITH ORDER BY expresion |
|
| Rama_Prayaga Replies: 3 Views: 1911 |
Forum: Database Posted: Wed Jan 11, 2006 7:30 am Subject: select WITH ORDER BY expresion |
| Hi Kolusu,
Thanks for your LINK. I shall go thru it.But Program is a online program , so cannot unload the data. Hi Manas, There are Nearly three million rows in a three Tables combined which ... |
|
| Topic: select WITH ORDER BY expresion |
|
| Rama_Prayaga Replies: 3 Views: 1911 |
Forum: Database Posted: Mon Jan 09, 2006 2:36 pm Subject: select WITH ORDER BY expresion |
| Hi ,
Following is a Similar Qurey which I am writing in a PL/1 application program. Select ID, Name, Place from Table_name Order by Name Fetch first 2000 rows only; The above query ... |
|
| Topic: VSAM Write Error 90 |
|
| Rama_Prayaga Replies: 2 Views: 2198 |
Forum: Application Programming Posted: Tue Aug 02, 2005 7:29 am Subject: VSAM Write Error 90 |
| Vaasavi,
May be you are trying to close a file witout opening it. Check the logical flow of the program on when the file is being close without performing open statement. Regards, Rama |
|
| Topic: Mass update Ignoring deadlock |
|
| Rama_Prayaga Replies: 9 Views: 4435 |
Forum: Database Posted: Thu Jul 21, 2005 3:19 am Subject: Mass update Ignoring deadlock |
| Hi Manas,
Thank you.I shall do it by using a Cursor. Regards, Rama Krishnna Prayaga |
|
| Topic: Embedded SQL select with ORDER BY and FETCH FIRST |
|
| Rama_Prayaga Replies: 8 Views: 3412 |
Forum: Database Posted: Wed Jul 20, 2005 2:06 pm Subject: Embedded SQL select with ORDER BY and FETCH FIRST |
| Pavani Donepudi,
One of the reason of for DSNH109I is Embedded SELECT statements cannot include ORDER BY, because the result cannot be more than a single row. ... |
|
| Topic: Embedded SQL select with ORDER BY and FETCH FIRST |
|
| Rama_Prayaga Replies: 8 Views: 3412 |
Forum: Database Posted: Wed Jul 20, 2005 2:01 pm Subject: Embedded SQL select with ORDER BY and FETCH FIRST |
| Hi Pavani Donepudi,
I have couple of questions. 1) does your SQL sytnax start with EXEC SQL statement and end with Semicolon (  .
2) are you using DCLGEN variable are your own working stora ... |
|
| Topic: sql code -518 as the string contains quotes |
|
| Rama_Prayaga Replies: 3 Views: 3311 |
Forum: Database Posted: Wed Jul 20, 2005 1:32 pm Subject: sql code -518 as the string contains quotes |
| Hi schintala,
Yes My EXECUTE STATEMENT is not PREPARED because of the the strings which have quotes( ' ) (EXample: MC Donald's resturant ) in them.How should I handle such situations is my prob ... |
|
| Topic: sql code -518 as the string contains quotes |
|
| Rama_Prayaga Replies: 3 Views: 3311 |
Forum: Database Posted: Wed Jul 20, 2005 10:08 am Subject: sql code -518 as the string contains quotes |
| Hi,
My program has Dynamic SQLs. I am receiving SQL code -518 sometimes, The reason while passing the string contains quotes, in between them. like MC Donald's resturant As the data w ... |
|
| Topic: Mass update Ignoring deadlock |
|
| Rama_Prayaga Replies: 9 Views: 4435 |
Forum: Database Posted: Wed Jul 20, 2005 7:02 am Subject: Mass update Ignoring deadlock |
| Hi Kolusu,
executed the above stament and receive SQLCODE -911 , But it did not run as I exepected it to be.I mean "none of the records" got updated.I shall show by example my requierement. r ... |
|
| Topic: REOPT(ONCE) for a DYNAMIC SQL program, effect on performance |
|
| Rama_Prayaga Replies: 2 Views: 2151 |
Forum: Database Posted: Wed Jul 20, 2005 4:11 am Subject: REOPT(ONCE) for a DYNAMIC SQL program, effect on performance |
| Hi Koulusu,
Thank you, Regards, Rama Krishna |
|
| Topic: REOPT(ONCE) for a DYNAMIC SQL program, effect on performance |
|
| Rama_Prayaga Replies: 2 Views: 2151 |
Forum: Database Posted: Mon Jul 11, 2005 9:42 am Subject: REOPT(ONCE) for a DYNAMIC SQL program, effect on performance |
| Hello,
I need to improve the peroformance of a DYNAMIC sql application prgram.I have checked the Bind options the program which are below. DSNT255I -DAF2 DSNTBCM2 BIND OPTIONS FOR ... |
|
All times are GMT - 5 Hours |