MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 222 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Adding Edited Fields
vivek1983

Replies: 13
Views: 7698

PostForum: Utilities   Posted: Fri Aug 29, 2008 7:33 am   Subject: Adding Edited Fields
Hi,

I was wondering if we can do this in Sort using a single step. Below is the scenario:

Input data:

AAAAA 151,864.74
AAAAA 149,573.09


Out ...
  Topic: Changing the subsystem - DSNREXX
vivek1983

Replies: 4
Views: 2942

PostForum: TSO and ISPF   Posted: Wed Jan 09, 2008 12:02 am   Subject: Changing the subsystem - DSNREXX
Nic Clouston,

Thanks... It worked perfect..

I agree ... I should have looked into the manual.. My regrets ...
  Topic: Changing the subsystem - DSNREXX
vivek1983

Replies: 4
Views: 2942

PostForum: TSO and ISPF   Posted: Tue Jan 08, 2008 6:20 am   Subject: Changing the subsystem - DSNREXX
acevedo,

Thanks for your response..


AFAIK... you should disconnect and connect to the new subsystem.



Can you tell me the syntax for disconnecting from a subsystem?

I am getting -1 ...
  Topic: Changing the subsystem - DSNREXX
vivek1983

Replies: 4
Views: 2942

PostForum: TSO and ISPF   Posted: Tue Jan 08, 2008 1:31 am   Subject: Changing the subsystem - DSNREXX
Hi,

I am currently using DSNREXX to execute queries via REXX.



ADDRESS TSO
SQL_STMT = "SELECT * FROM GA8A.T1 FETCH FIRST 2 ...
  Topic: execute insert query through REXX
vivek1983

Replies: 4
Views: 2875

PostForum: TSO and ISPF   Posted: Fri Jan 04, 2008 1:26 am   Subject: execute insert query through REXX
Packi,

Can you post an excerpt of your rexx code where this query is prepared and declared?
  Topic: Multiply and add using sort
vivek1983

Replies: 4
Views: 3049

PostForum: Utilities   Posted: Fri Jan 04, 2008 1:12 am   Subject: Multiply and add using sort
tattva,


P.S: I had written to Alissa and looks like there is no solution to this with the version of syncsort mentioned above.

Is there a way to crack this?



How abt EZT instead of ...
  Topic: Need to insert variable values in the record
vivek1983

Replies: 16
Views: 6812

PostForum: Utilities   Posted: Wed Dec 26, 2007 5:01 am   Subject: Need to insert variable values in the record
sivafdms,

Contact your system programmer to install DFSORT.


http://www.ibm.com/storage/dfsort/
  Topic: information about SORT-RETURN=20 error in cobol sort program
vivek1983

Replies: 2
Views: 3893

PostForum: Application Programming   Posted: Mon Dec 24, 2007 4:02 am   Subject: information about SORT-RETURN=20 error in cobol sort program
rahullimaye780@yahoo.com,

Well... the reasons may not be vivid unless u post the error messages and the piece of code that performs the sort.
  Topic: Vertical merge of first record with second record
vivek1983

Replies: 16
Views: 8143

PostForum: Utilities   Posted: Fri Dec 21, 2007 4:22 am   Subject: Vertical merge of first record with second record
vkphani,

The code above works perfect...
I am just wondering why it had thrown an error for u... Something strange.. Confused
  Topic: Vertical merge of first record with second record
vivek1983

Replies: 16
Views: 8143

PostForum: Utilities   Posted: Fri Dec 21, 2007 2:31 am   Subject: Vertical merge of first record with second record
Hi,


krisprems,
Your job gave me the error.


I didnt get any error. It ran fine and gave the desired output. Rolling Eyes
  Topic: Need to insert variable values in the record
vivek1983

Replies: 16
Views: 6812

PostForum: Utilities   Posted: Thu Dec 20, 2007 4:25 am   Subject: Need to insert variable values in the record
sivafdms,

Is it that your requirement needs to be done only thru sort?

If no, then few lines of REXX will do what you are looking for.
  Topic: to identify last record in SORTIN
vivek1983

Replies: 8
Views: 3181

PostForum: Job Control Language(JCL)   Posted: Wed Dec 19, 2007 4:17 am   Subject: to identify last record in SORTIN
kframes,


May I know whether this can be done using single SORT step.....


Well... The first step is to identify the last record.
I am not able to think of a single step solution.. M ...
  Topic: to identify last record in SORTIN
vivek1983

Replies: 8
Views: 3181

PostForum: Job Control Language(JCL)   Posted: Wed Dec 19, 2007 2:29 am   Subject: to identify last record in SORTIN
kframes,


Here if we observe.....there is no comma(,) for last record '5555'


The following job will give u the desired results.




//S1 EXEC PGM= ...
  Topic: How to pass a current date
vivek1983

Replies: 9
Views: 7505

PostForum: Job Control Language(JCL)   Posted: Thu Dec 13, 2007 12:34 am   Subject: How to pass a current date
Mouli,

I feel you can get the current date inside the pgm itself than resorting to tougher methods.


I know, we can directly use the current date in the program and process instead of pas ...
  Topic: Fixed length file to CSV file - using easytrieve
vivek1983

Replies: 3
Views: 6208

PostForum: Application Programming   Posted: Thu Dec 13, 2007 12:23 am   Subject: Fixed length file to CSV file - using easytrieve
Dip,

If u have DFSORT, following will do what u asked for:



//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD * ...
 
Page 1 of 15 Goto page 1, 2, 3 ... 13, 14, 15  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group