conversion of date format



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Re: conversion of date format

Postby raghuvanshi » Fri Feb 17, 2012 4:41 pm

Frank Yaeger wrote:raghuvanshi,

If that's not working for you, then there's something you're not telling us. When I run this job with DFSORT:

//S1 EXEC PGM=SORT                             
//SYSOUT DD SYSOUT=*                           
//SORTIN DD *                                   
31-01-2011                                     
25-05-2012                                     
//SORTOUT DD SYSOUT=*                           
//SYSIN DD *                                   
  SORT FIELDS=COPY                             
  OUTREC FIELDS=(4,2,C'/',1,2,C'/',7,4)         
/*


I get this output which is what you seem to be expecting:

01/31/2011   
05/25/2012   

.



When I am coding this jcl I am getting AbendU0016 and following are the details-:
You do not have the required permissions to view the files attached to this post.
raghuvanshi
 
Posts: 43
Joined: Tue Dec 07, 2010 5:32 pm
Has thanked: 3 times
Been thanked: 0 time

Re: conversion of date format

Postby Frank Yaeger » Sat Feb 18, 2012 12:15 am

Boy, this is difficult to follow.

My job has:

  SORT FIELDS=COPY                             
  OUTREC FIELDS=(4,2,C'/',1,2,C'/',7,4) 


In a previous post, you showed the complete messages for a job that just had:

   OPTION COPY


and no other statements. Without the OUTREC statement, the output will indeed match the input.

Now you are showing part of the messages for some job you ran that got U0016. That means there's some kind of error in your job. Once again, you didn't show the DFSORT messages, so I don't know what you were running or what error message you received. Look for an ICExxxA message.

If you can't figure out what you're doing wrong from the error message, then post ALL of the DFSORT (ICE) messages so I can see what you're doing wrong.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: conversion of date format

Postby raghuvanshi » Sat Feb 18, 2012 1:07 pm

Frank this msg from spool is for the job you coded, one again let me post mine.
Unfortunately there are no ICE messages comming up the onle ICE message that came was in the 12th line from top of my previous post
ICEEXIN

her is the job which abended with u0016
You do not have the required permissions to view the files attached to this post.
raghuvanshi
 
Posts: 43
Joined: Tue Dec 07, 2010 5:32 pm
Has thanked: 3 times
Been thanked: 0 time

Re: conversion of date format

Postby BillyBoyo » Sat Feb 18, 2012 5:32 pm

Are you incredibly stupid?

You registered over a year ago, so presumably you have at least "some" experience.

The level of incompetence you are demonstrating is equal to that of our usual trolls. You produce fake after fake and expect us to follow along.

You are either so stupid as to not to be able to follow the most simple of instruction accurately, or you are so stupid as to attempt deliberate confusion.

You say you ran Frank's job, but Frank's job wouldn't have JES messages for SORTIN and SORTOUT. You showed us one that does. You showed JCL with no SYSOUT DD statement, but JES output showing two DDs assigned to SYSOUT (which the SORTOUT is assigned to, allegedly). Without SYSOUT DD you'll get a 20. You earlier showed the referenced to "SYSOUS", which disappeared with no explanation. Everything you show is littered with stuff we could complain about (space allocated being huge for a single record, sortwork datasets huge for the amount of data, sortwork datasets not allocated dynamically. Errors/stupidities on job cards. Unmentioned error messages, Almost like you want us to complain?

You claim to have attempted Frank's JCL/cards twice. You have failed even in this most simple of tasks, and shown us different outputs to what could have genuinely been produced.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: conversion of date format

Postby raghuvanshi » Mon Feb 20, 2012 10:51 am

Amazingly as I included
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSDUMP DD SYSOUT =*

BETWEEN //S1 EXEC PGM=SORT AND //SORTIN DD * in the code of my previous post I got the required output as

01/31/2011
02/25/2012
raghuvanshi
 
Posts: 43
Joined: Tue Dec 07, 2010 5:32 pm
Has thanked: 3 times
Been thanked: 0 time

Re: conversion of date format

Postby raghuvanshi » Mon Feb 20, 2012 11:00 am

Thank you Frank
raghuvanshi
 
Posts: 43
Joined: Tue Dec 07, 2010 5:32 pm
Has thanked: 3 times
Been thanked: 0 time

Re: conversion of date format

Postby raghuvanshi » Mon Feb 20, 2012 11:19 am

I now know my mistake I was using //SYSDUMP DD SYSOUT=* instead of //SYSOUT DD SYSOUT=*
Here is the code which works fine.
You do not have the required permissions to view the files attached to this post.
raghuvanshi
 
Posts: 43
Joined: Tue Dec 07, 2010 5:32 pm
Has thanked: 3 times
Been thanked: 0 time

Re: conversion of date format

Postby dick scherrer » Sun Feb 26, 2012 7:11 am

Good to hear it is working - thank you for posting what caused the problem :)

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Previous

Return to JCL

 


  • Related topics
    Replies
    Views
    Last post