Sponsored Content
Full Discussion: syncsort in shell script
Top Forums Shell Programming and Scripting syncsort in shell script Post 302574189 by ArnieFarrelly on Wednesday 16th of November 2011 07:18:38 PM
Old 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

syncsort error

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

alternative open source to syncsort/dfsort ?

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

Syncsort is getting killed

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

syncsort

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

Syncsort Statistics - Work space used sometimes zero

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

calling syncsort in shell script

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

calling syncsort in shell script

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

Alternative open source to syncsort

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

How to get defined precision after arithmetic operation using syncsort?

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)
All times are GMT -4. The time now is 02:13 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy