View previous topic :: View next topic
|
Author |
Message |
rkpyla
New User
Joined: 22 Mar 2007 Posts: 5 Location: Bangalore
|
|
|
|
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 |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
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 |
|
|
rkpyla
New User
Joined: 22 Mar 2007 Posts: 5 Location: Bangalore
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|