Search found 8 matches

by Karthik12
Thu Jul 17, 2008 1:31 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Copy the fields from more than one DS to one DS
Replies: 3
Views: 8015

ok Frank. For example i have 3 input datasets. All datasets have the same recfm and lrecl. Those datasets have the numeric fields which starting postion is 8. In my output dataset, i want to consolidate the all fields from 3 input datasets. In Output dataset, the numeric field should be started from...
by Karthik12
Wed Jul 16, 2008 11:15 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Copy the fields from more than one DS to one DS
Replies: 3
Views: 8015

Copy the fields from more than one DS to one DS

How to copy the all fields from more one input dataset to one output dataset.
by Karthik12
Thu Jul 03, 2008 9:52 am
Forum: JCL
Topic: Error in Spool
Replies: 1
Views: 8445

Error in Spool

I am getting the follwing error in spool, what i have to do, pls help me INREC FIELDS=(40,2,BI,EDIT=(SIIIT),SIGNS=(,-)) SORT FIELDS=COPY ALTSEQ CODE=(0040) OUTREC BUILD=(1,12,C'|', X 13,26,C'|', X 39,1,C'|', X 40,2,TRAN=ALTSEQ,C'|', X 43,3,PD,EDIT=(ST.IIII),SIGNS=(,-),C'|',3X) SYSDIAG= 7416055, 1010...
by Karthik12
Wed Jul 02, 2008 5:02 pm
Forum: JCL
Topic: conversion by using SORT
Replies: 4
Views: 13581

We have the following scenario: Input file: contains value unloaded from a table. The given column is of the format: Packed decimal(Comp-3) values and a Nullable field. Input File format: 7994052604901996-03-08-12.45.52.938604 ..?...? 7994061415221996-01-05-20.15.42.822969S....?.. 7994091513521996-0...
by Karthik12
Wed Jul 02, 2008 4:31 pm
Forum: JCL
Topic: Sort conversion
Replies: 2
Views: 8690

Sort conversion

I have an ? mark input, i want to replace that one to @
for example
input
?
output
@
by Karthik12
Wed Jul 02, 2008 2:43 pm
Forum: JCL
Topic: conversion by using SORT
Replies: 4
Views: 13581

ok... can u tell me the output if the sort card has ALTSEQ code = (7C6F)?
by Karthik12
Wed Jul 02, 2008 2:18 pm
Forum: JCL
Topic: conversion by using SORT
Replies: 4
Views: 13581

conversion by using SORT

The following line is showing the syntax error while submitting the jcl

43,3,PD,TRAN=ALTSEQ,EDIT=(ST.TTTT),SIGNS=(,-),C'|',3X

Can you pls tell whether the code is right? If not, what is the remedy?
by Karthik12
Tue Jun 24, 2008 3:20 pm
Forum: JCL
Topic: Sum by SORT
Replies: 1
Views: 8987

Sum by SORT

How to prevent the overflow when adding the two fields by using SORT?