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
LEARN ABOUT FREEBSD
atf-sh
ATF-SH(1) BSD General Commands Manual ATF-SH(1)
NAME
atf-sh [-s shell] -- interpreter for shell-based test programs
SYNOPSIS
atf-sh script
DESCRIPTION
atf-sh is an interpreter that runs the test program given in script after loading the atf-sh(3) library.
atf-sh is not a real interpreter though: it is just a wrapper around the system-wide shell defined by ATF_SHELL. atf-sh executes the inter-
preter, loads the atf-sh(3) library and then runs the script. You must consider atf-sh to be a POSIX shell by default and thus should not
use any non-standard extensions.
The following options are available:
-s shell Specifies the shell to use instead of the value provided by ATF_SHELL.
ENVIRONMENT
ATF_LIBEXECDIR Overrides the builtin directory where atf-sh is located. Should not be overridden other than for testing purposes.
ATF_PKGDATADIR Overrides the builtin directory where libatf-sh.subr is located. Should not be overridden other than for testing purposes.
ATF_SHELL Path to the system shell to be used in the generated scripts. Scripts must not rely on this variable being set to select a
specific interpreter.
EXAMPLES
Scripts using atf-sh(3) should start with:
#! /usr/bin/env atf-sh
Alternatively, if you want to explicitly choose a shell interpreter, you cannot rely on env(1) to find atf-sh. Instead, you have to hardcode
the path to atf-sh in the script and then use the -s option afterwards as a single parameter:
#! /path/to/bin/atf-sh -s/bin/bash
ENVIRONMENT
ATF_SHELL Path to the system shell to be used in the generated scripts.
SEE ALSO
atf-sh(3)
BSD
September 27, 2014 BSD