 |
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 68 matches |
| Author | Message |
|---|---|
 Topic: Insert multiple rows through INSERT statement |
|
| psridhar Replies: 1 Views: 1406 |
 Forum: Database Posted: Tue Mar 14, 2006 7:21 am Subject: Insert multiple rows through INSERT statement |
| Hi
My table has 3 columns and I have some rows in a flat file as follows. 1 aaa xxx 2 bbb yyy 3 ccc zzz . ... ... Shall I insert all those rows in to my table with a single ... |
|
| Topic: Manipulating time in REXX |
|
| psridhar Replies: 3 Views: 1467 |
Forum: TSO and ISPF Posted: Fri Feb 17, 2006 10:17 am Subject: Manipulating time in REXX |
| Hi
Thank you for such a simple, wise idea. Great........ Thanks again Sridhar P |
|
| Topic: Manipulating time in REXX |
|
| psridhar Replies: 3 Views: 1467 |
Forum: TSO and ISPF Posted: Fri Feb 17, 2006 8:37 am Subject: Manipulating time in REXX |
| Hi
I have two times with me (ex: 21:45 and 22:05). Is there a way to find its difference in REXX and display it. The result for the above example should be 00:20. Simillarly, a way for adding two t ... |
|
| Topic: Conversion of date format using REXX... |
|
| psridhar Replies: 7 Views: 8389 |
Forum: TSO and ISPF Posted: Mon Feb 06, 2006 12:56 pm Subject: Conversion of date format using REXX... |
| Hi Friend,
Thanks for the info. It solved my purpose. Regards Sridhar P |
|
| Topic: Conversion of date format using REXX... |
|
| psridhar Replies: 7 Views: 8389 |
Forum: TSO and ISPF Posted: Mon Feb 06, 2006 6:36 am Subject: Conversion of date format using REXX... |
| Hi
I have my date as year and no of days in that year as below. Year : 2005 No of days in that year : 306 Is there a way to convert this in to DD.MM.YYYY format... ... |
|
| Topic: Batch utility to write PDS member list to sequential file |
|
| psridhar Replies: 10 Views: 43133 |
Forum: Job Control Language(JCL) Posted: Thu Feb 02, 2006 10:20 am Subject: Batch utility to write PDS member list to sequential file |
| Hi Kolusu,
In my REXX tool, I need to find out the change date and user of a member in a PDS. I am using the Rexx routine written by DOUG NADEL. But the problem here is my PDS has around 10000 mem ... |
|
| Topic: Sample practise test papers for DB2 certification |
|
| psridhar Replies: 5 Views: 2863 |
Forum: Database Posted: Mon Jan 09, 2006 12:36 am Subject: Sample practise test papers for DB2 certification |
| Hi Manas,
Thank you very much for the help. I have gone through the "ibm.com/certify" link. It leads to "https://ibmtesting.prime.prometric.com" which is also unfortunately a pay site. Sridh ... |
|
| Topic: Sample practise test papers for DB2 certification |
|
| psridhar Replies: 5 Views: 2863 |
Forum: Database Posted: Wed Jan 04, 2006 5:10 am Subject: Sample practise test papers for DB2 certification |
| Hi Manas,
Thank you very much for the help. I will go through that link. Sridhar P |
|
| Topic: Sample practise test papers for DB2 certification |
|
| psridhar Replies: 5 Views: 2863 |
Forum: Database Posted: Tue Jan 03, 2006 1:29 pm Subject: Sample practise test papers for DB2 certification |
| Hi Shekar,
I am exactly in the situation where you were few days ago. I am going to appear for the DB2 UDB 700 Family Fundamentals exam on 16.01.2006. My preparation is going on and I am searching ... |
|
| Topic: Set Return Code of previous step to 0 |
|
| psridhar Replies: 3 Views: 3343 |
Forum: Job Control Language(JCL) Posted: Wed Dec 14, 2005 12:30 pm Subject: Set Return Code of previous step to 0 |
| Hi
I need to set one step's return code to zero after executing one SQL. JCL I am trying is given below. //T5MP413X JOB (00511200,MFA),'TCPIP',MSGCLASS=X,REGION=4096K, // ... |
|
| Topic: Finding number of records in a PS / PDS member through JCL |
|
| psridhar Replies: 7 Views: 6912 |
Forum: Job Control Language(JCL) Posted: Thu Nov 10, 2005 4:52 am Subject: Finding number of records in a PS / PDS member through JCL |
| Hi,
Thanks for the reply. Now my job became much more simple. Kolusu, You said just search before posting. I did it with the key words "find record count jcl" in JCL topic. I found 175 result ... |
|
| Topic: Finding number of records in a PS / PDS member through JCL |
|
| psridhar Replies: 7 Views: 6912 |
Forum: Job Control Language(JCL) Posted: Wed Nov 09, 2005 1:25 pm Subject: Finding number of records in a PS / PDS member through JCL |
| Hi
Can anybody help me in finding out number of records in a PS / PDS member through JCL or REXX etc... I have very big PS files which contain around 2000000 records. I need to make a note of the n ... |
|
| Topic: Allocation of PDS space in mega bytes |
|
| psridhar Replies: 2 Views: 1672 |
Forum: Job Control Language(JCL) Posted: Wed Nov 09, 2005 5:57 am Subject: Allocation of PDS space in mega bytes |
| Hi
It works fine. Thank you... Cheers Sridhar P |
|
| Topic: Allocation of PDS space in mega bytes |
|
| psridhar Replies: 2 Views: 1672 |
Forum: Job Control Language(JCL) Posted: Wed Nov 09, 2005 4:40 am Subject: Allocation of PDS space in mega bytes |
| Hi
Can anybody tell me the key word for allocation of a PS file in mega bytes through JCL. I tried the folowing options but noting worked out. SPACE=(MEGABYTE,(1,1),RLSE) SPA ... |
|
| Topic: Passing a variable to COBOL program using SYSIN in a JCL |
|
| psridhar Replies: 13 Views: 15534 |
Forum: Job Control Language(JCL) Posted: Wed Oct 26, 2005 9:27 am Subject: Passing a variable to COBOL program using SYSIN in a JCL |
| Hi Kolusu,
Lets have a look at the below JCL. //TCPIP ......EXEC PGM=..... // // ... //EXECPGM ......EXEC PGM=..... // // ... //SYSIN DD * TCPIP.RC /* //SYSTSIN DD * DSN ... |
|
All times are GMT - 5 Hours |