IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Query with SFF in ICETOOL


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
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
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
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 Developer


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

PostPosted: Tue Jun 06, 2006 9:33 pm
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 Developer


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

PostPosted: Tue Jun 06, 2006 9:51 pm
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
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
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
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
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
Reply with quote

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

DFSORT Developer


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

PostPosted: Wed Jun 07, 2006 9:11 pm
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
Reply with quote

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

DFSORT Developer


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

PostPosted: Wed Jun 07, 2006 9:18 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts RC query -Time column CA Products 3
No new posts Shift left VB record without x00 endi... DFSORT/ICETOOL 11
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
No new posts how to calculate SUM for VB file usin... JCL & VSAM 1
No new posts Dynamically pass table name to a sele... DB2 2
Search our Forums:

Back to Top