Author |
Message |
Topic: Adding Edited Fields |
vivek1983
Replies: 13
Views: 7698
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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.. |
Topic: Vertical merge of first record with second record |
vivek1983
Replies: 16
Views: 8143
|
Forum: 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. |
Topic: Need to insert variable values in the record |
vivek1983
Replies: 16
Views: 6812
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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 * ... |
|