Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Query with SFF in ICETOOL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
ap_mainframes

Active User


Joined: 29 Dec 2005
Posts: 181
Location: Canada

PostPosted: Tue Jun 06, 2006 5:09 pm    Post subject: Query with SFF in ICETOOL
Reply with quote

Hi,
I am trying to use SFF, but getting maxcc 12.
I am new to ICETOOL.
Can anybody help ??

The sort card I am using is
Quote:
//TOOLIN DD *
OPTION COPY
INREC OVERLAY=(30,5,SFF,TO=PD,LENGTH=5)
/*
Back to top
View user's profile Send private message

sunnyk

New User


Joined: 20 Oct 2004
Posts: 59

PostPosted: Tue Jun 06, 2006 5:29 pm    Post subject:
Reply with quote

You can convert SFF to ZD format only and then in further step/s you can convert ZD to PD.

Correct me if i am wrong.

Regds
Sunny
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Jun 06, 2006 9:33 pm    Post subject:
Reply with quote

Again, you're mixing up an ICETOOL job with a DFSORT job. You can use a DFSORT job like this:

Code:

//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=...  input file
//SORTOUT DD DSN=...   output file
//SYSIN DD *
   OPTION COPY
   INREC OVERLAY=(30:30,5,SFF,TO=PD,LENGTH=5)
/*   


or you can use an ICETOOL job like this:

Code:

//S2 EXEC PGM=ICETOOL
//TOOLMSG  DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=...  input file
//OUT DD DSN=...   output file
//TOOLIN DD *
COPY FROM(IN) TO(OUT) USING(CTL1)
//CTL1CNTL DD *
   INREC OVERLAY=(30:30,5,SFF,TO=PD,LENGTH=5)
/*   
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Jun 06, 2006 9:51 pm    Post subject:
Reply with quote

Sunny wrote
Quote:
You can convert SFF to ZD format only and then in further step/s you can convert ZD to PD.

Correct me if i am wrong.


Well, yes, you could but there's no need to, and it has nothing to do with the original poster's problem. You can convert SFF directly to PD. The problem here is with the JCL.
Back to top
View user's profile Send private message
ap_mainframes

Active User


Joined: 29 Dec 2005
Posts: 181
Location: Canada

PostPosted: Wed Jun 07, 2006 9:09 am    Post subject: Re: Query with SFF
Reply with quote

Hi Frank,
I did try using the JCL provided by you.
However it still is giving me syntax errors.

The error is

Code:
CTL1CNTL :                                                     
  INREC OVERLAY=(30:30,5,SFF,TO=PD,LENGTH=5)                   
        *                                                       
WER428I  CALLER-PROVIDED IDENTIFIER IS "0001"                   
WER268A  INREC STATEMENT   : SYNTAX ERROR                       
WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000                   
WER449I  SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE                   


The JCL i am using looks like this

Quote:
//S3 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=XXXXXXXXXXXXXXX,DISP=SHR
//OUT DD SYSOUT=*
//TOOLIN DD *
COPY FROM(IN) TO(OUT) USING(CTL1)
//CTL1CNTL DD *
INREC OVERLAY=(30:30,5,SFF,TO=PD,LENGTH=5)
/*
Back to top
View user's profile Send private message
sunnyk

New User


Joined: 20 Oct 2004
Posts: 59

PostPosted: Wed Jun 07, 2006 10:12 am    Post subject:
Reply with quote

Well against a BOND like Frank Yaeger, i can't comment anything. But i remember reading it somewhere that you can convert SFF to ZD so that we can use summation on it and then further convert it to other format/s.
I guess i misread the statement.

Regds
Sunny
Back to top
View user's profile Send private message
sunnyk

New User


Joined: 20 Oct 2004
Posts: 59

PostPosted: Wed Jun 07, 2006 10:18 am    Post subject:
Reply with quote

At what column you are starting ur "INREC" statement. I guess that may a probable cause of the problem.Just check it.

Regds
Sunny
Back to top
View user's profile Send private message
ap_mainframes

Active User


Joined: 29 Dec 2005
Posts: 181
Location: Canada

PostPosted: Wed Jun 07, 2006 10:27 am    Post subject: Re: Query with SFF
Reply with quote

well..I have checked that..
Position is not a problem here ..I guess.
Back to top
View user's profile Send private message
ap_mainframes

Active User


Joined: 29 Dec 2005
Posts: 181
Location: Canada

PostPosted: Wed Jun 07, 2006 4:26 pm    Post subject: Re: Query with SFF
Reply with quote

Somebody please answer!!
Frank , can you please help???
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Jun 07, 2006 9:11 pm    Post subject:
Reply with quote

Quote:
Somebody please answer!!
Frank , can you please help???


I'm on the West Coast of the U.S. I just got into work.

The WER messages indicate you're using Syncsort, not DFSORT. DFSORT supports OVERLAY and SFF, so the job works fine with DFSORT. Syncsort does not support OVERLAY or SFF.

I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.
Back to top
View user's profile Send private message
ap_mainframes

Active User


Joined: 29 Dec 2005
Posts: 181
Location: Canada

PostPosted: Wed Jun 07, 2006 9:16 pm    Post subject: Re: Query with SFF
Reply with quote

Ok ,
But are there any remedies ???
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Jun 07, 2006 9:18 pm    Post subject:
Reply with quote

Sunny wrote
Quote:
Well against a BOND like Frank Yaeger, i can't comment anything. But i remember reading it somewhere that you can convert SFF to ZD so that we can use summation on it and then further convert it to other format/s.
I guess i misread the statement.


What's a BOND?

You made two different statements. Both are true, but only the second one makes sense to do.

1) The statement you made that I corrected was:

Quote:
You can convert SFF to ZD format only and then in further step/s you can convert ZD to PD.


As I said, there's no reason to convert from SFF to ZD to PD since you can go directly from SFF to PD.

2) The statement you say you read somewhere is a different statement:

Quote:
you can convert SFF to ZD so that we can use summation on it and then further convert it to other format/s.


That makes sense because SFF cannot be used with SUM. So in that case, you would convert from SFF to ZD, SUM the ZD field, and then convert again.

The difference here is a direct conversion vs using SUM.
Back to top
View user's profile Send private message
ap_mainframes

Active User


Joined: 29 Dec 2005
Posts: 181
Location: Canada

PostPosted: Fri Jun 09, 2006 8:45 am    Post subject: Re: Query with SFF in ICETOOL
Reply with quote

Ok ,
But are there any remedies ???
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Using ICETOOL, how we can seperate th... bshkris SYNCSORT 5 Tue May 09, 2017 8:33 pm
No new posts Group elements using ICETOOL Learncoholic DFSORT/ICETOOL 2 Fri Apr 14, 2017 11:01 am
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Omegamon for DB2 query ashek15 DB2 0 Wed Feb 15, 2017 11:25 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us