11-16-2011
Hi,
The syntax you reference below and the functional description of each syntax option are all documented in the syncsort unix reference guide. If you are licensed customer you are entitled to a product manual. If you do not have access to one I can certainly assist you with this if you provide me with your contact information(full name, company name, support site contact)
Also, I wanted to let you know that the Syncsort syntax is proprietary and confidential and may not be posted on public forums such as this per the Syncsort License agreement. So if you have any specific product questions about syncsort unix product syntax I highly recommend you email our product support group directly. Our support email address is posted on our website.
I can describe at a high level what each of these options functional provide. These options are really documented well in the syncsort unix reference manual.
/CONDITION - allow for conditional field level or record level processing
/SUMMARIZE - removes duplicate records based on key values
/INCLUDE - allows for record selection and inclusion in the target output used with /condition
/REFORMAT - reformats and reorders fields with a record. This can be used with the /condition statement to logically include or not include data fie
/STATISTICS - produces operation metadata about the transformation, for example records read, records sorted, records output, elapsed time, cpu time.
/DERIVEDFIELD - derives new data, can be done conditionally as well based on other field values.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am getting the error
Syncsort: (INERR) an internal error has occurred (11 in SSTRPHDL)
when i run a syncsort. The manual does not give any explanation for this.
Could anyone please give what the error is like.
Thanks in advance (1 Reply)
Discussion started by: vinod.thayil
1 Replies
2. UNIX for Advanced & Expert Users
we use syncsort only as a sorting tool .
Does anyone know about a free option for sort large binary files ?
Thanks
Golan (0 Replies)
Discussion started by: ghadad
0 Replies
3. Shell Programming and Scripting
Hi All,
I am running synsort utility via unix scripts.
As soon as the control reaches the syncsort command,Its getting killed.
The error message is
/proj/cdw/syncsort/dev/copay/CdwWkRvrslFileReformat.syn: 8339696 Killed
. Please suggest to overcome this issue. (5 Replies)
Discussion started by: prashantnandi
5 Replies
4. Shell Programming and Scripting
I have got the following error messahe in the log file while running the syncsort process in a unix script.
Starting the Syncsort Process
SyncSort : (KEYEXPWARN) the license key (43966) will expire on Feb 28, 2011
(TECHSVC) please contact Syncsort Technical Support
SyncSort... (3 Replies)
Discussion started by: mady135
3 Replies
5. Shell Programming and Scripting
I've searched previous forums but could not find the answer to my question.
What determines how the "Work space used (bytes)" line item in the SyncSort Statistics appears? For instance I have some that show:
Records read: 3,273,645 Data read (bytes): ... (2 Replies)
Discussion started by: mango
2 Replies
6. UNIX for Dummies Questions & Answers
Hi,
pls, tell me how to use syncsort in shell script? if i have to sort a file, what are the syncsort commands i hav to use ? say abc.dat is my file and dt, Id are my key columns. (0 Replies)
Discussion started by: captain haddock
0 Replies
7. Shell Programming and Scripting
Hi,
pls, tell me how to use syncsort in shell script? if i have to sort a file, what are the syncsort commands i hav to use ? say abc.dat is my file and dt, Id are my key columns. (0 Replies)
Discussion started by: captain haddock
0 Replies
8. UNIX for Advanced & Expert Users
Hi,
I am looking for an opensource alternate to replace syncsort. Can you please suggest ? (8 Replies)
Discussion started by: AmbikaValagonda
8 Replies
9. How to Post in the The UNIX and Linux Forums
I have to do some arithmetic operation on Field 8 which is calculated by Field 9/Field 7
Suppose i have data like :
0800123456|JAN|2017|JAN|2018|0800123456|0|0.0000|0.00|
0800234567|JAN|2017|JAN|2018|0800234567|4|2.5812|10.32|
0800666666|JAN|2017|JAN|2018|0800666666|2|1.7255|3.45|... (0 Replies)
Discussion started by: pumrao
0 Replies
newinv(1) General Commands Manual newinv(1)
NAME
newinv - Updates distribution kit master inventory
SYNOPSIS
/usr/bin/newinv mi-file input-path...
OPERANDS
The pathname of the master inventory file to be processed. If no master inventory file exists, you must create an empty one before using
the newinv command. The name of the product hierarchy to be scanned for files belonging in the inventory. All files and directories found
below the input-path are processed as belonging in the inventory.
DESCRIPTION
The newinv command interactively maintains the master inventory files used for producing distribution kits in setld format. The program
updates the master inventory for a product when changes are made to the hierarchy of files that are to be packaged in the subsets which
constitute the product.
The product hierarchy is scanned to produce a list of component path names relative to input-path. The list of pathnames is processed
against the mi-file to produce a list of files that have been removed from the product hierarchy and a list of files that have been added.
The user is then given an opportunity to intervene and direct the inventory maintenance by editing these lists. The user is placed in the
editor with each list available for editing. The editor used is the one specified by the EDITOR environment variable. If EDITOR is not
set, vi is used. When editing the list of files that have been removed from the product, the user is expected to verify that the removals
were intentional and confirm the intent by removing the associated records from the file. When editing the list of added files, the user
is expected to provide options and subset information for each new file, transforming the elements of the list into master inventory
records.
To produce a new copy of the master inventory file, both of these lists are merged with the records for the files which existed in the pre-
vious version and are still included.
RESTRICTIONS
The default text editor, if not specified in $EDITOR, is /usr/ucb/vi.
Files in the product hierarchy cannot be excluded from the master inventory. Files can be blocked from being kitted in the final distribu-
tion kit by setting the subset field of the master inventory record to a minus sign (-).
ERRORS
The mi-file specified on the command line cannot be found. The input-path directory specified on the command line does not exist.
EXAMPLES
To update the hypothetical master inventory file OAT100.mi from the hierarchy beginning at /var/kits/input, type:
newinv OAT100.mi /var/kits/input
FILES
Backup copy of master inventory The list of files missing from the product The list of files new to the product Intermediate join file List
of all files in the product
SEE ALSO
invcutter(1), kits(1), vi(1), setld(8) stl_mi(4) environ(5) Guide to Preparing Product Kits
newinv(1)