Author |
Message |
Topic: Getting absolute value in Sort. |
aashish.paul
Replies: 2
Views: 2177
|
Forum: Utilities Posted: Tue Jun 21, 2011 12:05 pm Subject: Getting absolute value in Sort. |
Thanks Kolusu, I am not sure hos i missed the post.
I was able to customize your first suggestion to suite my need. |
Topic: Getting absolute value in Sort. |
aashish.paul
Replies: 2
Views: 2177
|
Forum: Utilities Posted: Tue Jun 21, 2011 9:59 am Subject: Getting absolute value in Sort. |
I am trying to convert a -ve PD field to its absolute value in PD format but have not had any luck.
I am hoping this could be somehow done in SYNCSORT. Greately appreciate any help. |
Topic: Binding a program to 2 differnt subsystems |
aashish.paul
Replies: 10
Views: 5578
|
Forum: Database Posted: Fri Jan 14, 2011 12:22 pm Subject: Binding a program to 2 differnt subsystems |
Changed the VALIDATE(BIND) to VALIDATE(RUN) and got a -805  |
Topic: Binding a program to 2 differnt subsystems |
aashish.paul
Replies: 10
Views: 5578
|
Forum: Database Posted: Tue Jan 11, 2011 10:32 am Subject: Binding a program to 2 differnt subsystems |
the table to check the connection is sysibm.locations, i did check that the subsystem i wanted to connect to is available.
My facility uses DRDA access, according to the manual I have to do a loca ... |
Topic: Binding a program to 2 differnt subsystems |
aashish.paul
Replies: 10
Views: 5578
|
Forum: Database Posted: Mon Jan 10, 2011 10:47 am Subject: Binding a program to 2 differnt subsystems |
Svghk,
I have a similiar requirement, a program that has sqls running against 2 Db2 susbsytems at different points in the program. my pkg binds are failing when binding against the second susytem. ... |
Topic: Merge the records based on the Span-date |
aashish.paul
Replies: 4
Views: 3074
|
Forum: Utilities Posted: Thu Jul 15, 2010 2:07 pm Subject: Merge the records based on the Span-date |
Hi,
Is there a way that the above can be acomplished using syncsort?
Thanks. |
Topic: Gather list of datasets and space used |
aashish.paul
Replies: 12
Views: 7852
|
Forum: Job Control Language(JCL) Posted: Mon Mar 23, 2009 2:23 pm Subject: Gather list of datasets and space used |
Thanks Terry, Kolusu I have about 50K datasets for which I need to get the space utilization. Recalling that many datasets was not a reasonable solution. When I contacted the system administer he was ... |
Topic: Gather list of datasets and space used |
aashish.paul
Replies: 12
Views: 7852
|
Forum: Job Control Language(JCL) Posted: Fri Mar 13, 2009 11:42 am Subject: Gather list of datasets and space used |
Hi tallyman I am missing migrated datasets information. |
Topic: Gather list of datasets and space used |
aashish.paul
Replies: 12
Views: 7852
|
Forum: Job Control Language(JCL) Posted: Fri Mar 13, 2009 11:15 am Subject: Gather list of datasets and space used |
Thank you tallyman. Your idea works perfectly.
I never thought of that but was looking for the JCL way from the word go.  |
Topic: Gather list of datasets and space used |
aashish.paul
Replies: 12
Views: 7852
|
Forum: Job Control Language(JCL) Posted: Thu Mar 12, 2009 3:15 pm Subject: Gather list of datasets and space used |
I would like to get a list of all the datset with a HLQ like ABCD.* with the amount of space it is using.
Output could be like
ABCD.EFGH1 123 tracks
ABCD.EFGH2 234 tracks
.
.
.
ABCD ... |
|