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

Can we use SYNCTOOL for VBA format files


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rkpyla

New User


Joined: 22 Mar 2007
Posts: 5
Location: Bangalore

PostPosted: Wed Jul 16, 2008 11:08 pm
Reply with quote

Hi,

I have a file which is VBA formatted. Can we use SYNCTOOL to get the records from this file using a search criteria.

Can you please provide an example JCL for this.

Thanks,
RK
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: Thu Jul 17, 2008 12:43 am
Reply with quote

DFSORT's ICETOOL can operate on a VBA file in the same way it operates on any other variable-length file. A VBA file just has an ANSI carriage control character (cc) after the RDW, so a record looks like this:

|RDW|cc|data|

The data starts in position 6 after the 4-byte RDW and 1-byte cc.

Quote:
Can we use ICETOOL to get the records from this file using a search criteria.

Can you please provide an example JCL for this.


Not until you give a clearer description of what you want to do. What exactly do you mean by "get the records from this file using a search criteria"? Are you talking about using INCLUDE? Or something else. What are the search criteria exactly? An example of the input records and what you expect for output, along with an explanation of the "rules" for getting from input to output would help.
Back to top
View user's profile Send private message
rkpyla

New User


Joined: 22 Mar 2007
Posts: 5
Location: Bangalore

PostPosted: Thu Jul 17, 2008 10:26 am
Reply with quote

Thanks Frank,

Please find below my requirement:

Input PS file: ID.INP1

I want all the records that are having a common string ":00" in the column position 25.

I have used ICETOOL job with INCLUDE statement but the job failed with Max-CC 16 with the following error message "INCLUDE/OMIT FIELD BEYOND RECORD".

Please let me know if any further information is required.

Regards,
RK
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Jul 17, 2008 7:29 pm
Reply with quote

Hello,

Please post your jcl, sort control statements, and the complete diagnostic information presented by the problem run (this includes all of the message numbers/ids along with the message text).
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: Thu Jul 17, 2008 9:26 pm
Reply with quote

RK,

That message indicates you're using Syncsort, not DFSORT.

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.

This is the DFSORT Forum for DFSORT questions. Please ask Syncsort questions in the JCL Forum.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Jul 17, 2008 10:20 pm
Reply with quote

Hello,

Quote:
"INCLUDE/OMIT FIELD BEYOND RECORD".
Your error is self-explanitory.

For someone here to help, you need to post the info requested earlier. . .
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Populate last day of the Month in MMD... SYNCSORT 2
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Need to convert date format DFSORT/ICETOOL 20
Search our Forums:

Back to Top