SORT & FAID python sort

1. SORT-summary1(pls refer to latest summay-summary2)

FUNTIONSYSIN(Control statement)DescReference

SORTSORT FIELDS=(1,3,CH,A)SERS.MSI.RABIL.JCL(NELSRT05)

SORT-OMIT recordsSORT FIELDS=(1,3,CH,A)

OMIT COND=(7,1,CH,EQ,C'S',AND,8,1,CH,EQ,C'G')Omit records

SORT-INCLUDE recordsSORT FIELDS=(1,3,CH,A)

INCLUDE COND=(7,1,CH,EQ,C'S')include records

COPYSORT FIELDS=COPY

COPY- OIMIT recordsSORT FIELDS=COPY

OMIT COND=(7,1,CH,EQ,C'S')Omit records

COPY- INCLUDE recordsSORT FIELDS=COPY

INCLUDE COND=(7,1,CH,EQ,C'S')include records

COPY -Several FieldsSORT FIELDS=COPY

OUTREC FIELDS=(1,3,C' RMB ',10,2)1. GET FIELDS START FROM 1, LENGTH IS 3

2. ADD NEW columns value ' RMB '

3. Get fileds start from 10, length is 2

COPY -Several Fields-OMITSORT FIELDS=COPY

OUTREC FIELDS=(1,3,C' RMB ',10,2)

OMIT COND=(1,3,CH,GT,C'333')

COPY -Several Fields-INCLUDESORT FIELDS=COPY

OUTREC FIELDS=(1,3,C' RMB ',10,2)

INCLUDE COND=(1,3,CH,LT,C'333')

COPY - GET FIRST N REOCRDSSORT FIELDS=COPY,STOPAFT=2

COPY-FROM RECORD M TO NSORT FIELDS=COPY,SKIPREC=2,STOPAFT=2

COPY-REPLACESORT FIELDS=COPY

OUTFIL FNAMES=SORTOUT,

OUTREC=(1,3,4,2,CHANGE(2,C'FD',C'FF'),NOMATCH=(4,2))1.OUTPU FILE IN example. The length must be 6.

COPY-REFORMATSORT FIELDS=COPY

OUTFIL FNAMES=SORTOUT,

OUTREC=(1:1,3, -

4:6,2, -

6:8,5)1.4:6,2(input start 6 length 2 output from 4)

2.file length in example is 10

SPLIT 1 TO SEVERAL FILESSORT FIELDS=COPY

OUTFIL FNAMES=SORTOUT1,

INCLUDE=(1,3,CH,EQ,C'AAA')

OUTFIL FNAMES=SORTOUT2,

INCLUDE=(1,3,CH,EQ,C'BBB')

OUTFIL FNAMES=SORTOUT3,SAVE1.It is include, not 'include cond'

2.save->indicate left records put in sortout3 file

MERGEMERGE FIELDS=(1,3,CH,A)1. FILE MUST be sorted by FIELDS=(1,3,CH,A)

MERGE -INCLUDE CONDMERGE FIELDS=(1,3,CH,A)

INCLUDE COND=(1,3,CH,EQ,C'AAA',OR,1,3,CH,EQ,C'BBB')

MERGE -OMIT CONDMERGE FIELDS=(1,3,CH,A)

OMIT COND=(1,3,CH,EQ,C'AAA')

2.FILEAID

//PSTN0030 EXEC PGM=FILEAID,REGION=9M

//SYSPRINT DD SYSOUT=*

//SYSLIST DD SYSOUT=*

//DD01 DD DSN=&HLQN1.EL&HLQN2..EL.&GRP1..ISAR.DATA.UNLOAD,

// DISP=SHR

//DD01O DD DSN=&HLQN1.EL&HLQN2..EL.&GRP1..ISAR.DATA.FILEAID,

// DISP=OLD

//SYSIN DD *

$$DD01 COPY PADCHAR=X'00' -> DD01 is inut, copy to dd010 . PADCHAR-> THE VALUE FOR PADDING->把vb文件后面补充x‘00’转换成FB文件

3. Sort summary2

SORT /MEAREG

Specify output fileINCUDE ROWSOMIT ROWS

SORT FIELDS =(1,2,CH,A)INCLUDE COND=(1,2,CH,EQ,C'AA',OR,1,2,CH,EQ,C'BB')OMMIT COND=(1,2,CH,EQ,C'AA')

MERGE FIELDS =(1,2,CH,A)INCLUDE COND=(1,2,CH,EQ,C'AA',OR,1,2,CH,EQ,C'BB')OMMIT COND=(1,2,CH,EQ,C'AA')

COPY ROWSSpecify output fileINCUDE ROWSOMIT ROWS

SORT FIELDS=COPYSORT FIELDS=COPY

OUTFILE FNAMES=SORTOUTINCLUDE COND=(1,2,CH,EQ,C'AA',OR,1,2,CH,EQ,C'BB')OMMIT COND=(1,2,CH,EQ,C'AA')

COPY COLUMNSSpecify output fileINCUDE ROWSOMIT ROWS

SORT FIELDS=COPY

OUTREC FIELDS=(1,2,C'RMB',4,3)SORT FIELDS=COPY

OUTFILE FNAMES=SORTOUT,

OUTREC=(1,2,C'RMB',4,3)INCLUDE COND=(1,2,CH,EQ,C'AA',OR,1,2,CH,EQ,C'BB')OMMIT COND=(1,2,CH,EQ,C'AA')

COPY COLUMNS REPLACESpecify output fileINCUDE ROWSOMIT ROWS

SORT FIELDS=COPY

OUTREC FIELDS=(1,2,3,2,CHANGE(2,C'AA',C'FF'),

NOMATCH=(3,2))OUTFILE FNAMES=SORTOUT,

OUTREC=(1,2,3,2,CHANGE(2,C'AA',C'FF'),

NOMATCH=(3,2))INCLUDE COND=(1,2,CH,EQ,C'AA',OR,1,2,CH,EQ,C'BB')OMMIT COND=(1,2,CH,EQ,C'AA')

SORT FIELDS=COPY
SORT & FAID python sort

COPY COLUMNS REFORMATSpecify outputfileINCUDE ROWSOMIT ROWS

SORT FIELDS=COPY

OUTREC FIELDS=(1:1,2, -

3:4,3, -

6:8,2)SORT FIELDS=COPY

OUTFIL FNAMES=SORTOUT,

OUTREC=(1:1,2, -

3:4,3, -

6:8,2)INCLUDE COND=(1,2,CH,EQ,C'AA',OR,1,2,CH,EQ,C'BB')OMMIT COND=(1,2,CH,EQ,C'AA')

COPY N ROWSSpecify outputfileINCUDE ROWSOMIT ROWS

SORT FIELDS=COPY,SKIPREC=2,STOPAFT=2SORT FIELDS=COPY,SKIPREC=2,STOPAFT=2

OUTFIL FNAMES=SORTOUTINCLUDE COND=(1,2,CH,EQ,C'11',OR,1,2,CH,EQ,C'22')OMMIT COND=(1,2,CH,EQ,C'AA')

SPLIT FILESSplit by rowsSplit by columns

SORT FIELDS=COPY

OUTFIL FNAMES=SORTOUT1,

INCLUDE=(1,3,CH,EQ,C'AAA')

OUTFIL FNAMES=SORTOUT2,

INCLUDE=(1,3,CH,EQ,C'BBB')

OUTFIL FNAMES=SORTOUT3,SAVESORT FIELDS=COPY

OUTFIL FNAMES=SORTOUT1,

OUTREC=(1,2)

OUTFIL FNAMES=SORTOUT2,

OUTREC=(3,2) /*sortout1 lenght must be 2

  

爱华网本文地址 » http://www.aihuau.com/a/25101013/148763.html

更多阅读

pythonwith关键字用法 python with用法

本人尚未理解,暂贴于此,待日后慢慢咀嚼。with从Python 2.5就有,需要from __future__ importwith_statement。自python2.6开始,成为默认关键字。在What's new in python2.6/3.0中,明确提到:The 'with'statement is a control-flowstructure

学好Python的十种境界 学生最喜欢的十种教师

1)学好python的第一步,就是马上到www.python.org网站上下载一个python版本。我建议初学者,不要下载具有IDE功能的集成开发环境,比如Eclipse插件等。2)下载完毕后,就可以开始学习了。学习过程中,我建议可

perl和python各自擅长什么领域? 简历擅长领域怎么写

设计一个语言的初始目的决定了该语言将会内建什么功能perl初始是Larry为了格式化处理文本而创建的所以内建了正则看python居然内建一个复数型别,我猜测Guido最初一定是为了数值计算而创建了pythonso,perl擅长文字处理,python擅长数值处

vector用法 vector中的sort

vector的用法关键概念: vector 容器可动态动态地添加元素个数.vector 是同一种类型的对象的集合,每个对象都有一个对应的整数索引值。和 string对象一样,标准库负责管理存储元素的相关内存。我们把vector称为容器,是因为它可以包含其

Python中的高级数据结构 python的数据结构

本文由 伯乐在线 - 熊崽Kevin 翻译自 pypix.com。欢迎加入技术翻译小组。转载请参见文章末尾处的要求。数据结构数据结构的概念很好理解,就是用来将数据组织在一起的结构。换句话说,数据结构是用来存储一系列关联数据的东西。在Python

声明:《SORT & FAID python sort》为网友无色无味分享!如侵犯到您的合法权益请联系我们删除