SEQ_FILE

pandu80 · Post by **pandu80** » Mon Apr 18, 2005 6:04 pm

HI, I HAVE A SEQFILE

X008999999999999999999
Y008999999999999999999
Z008999999999999999999
Z008999999999999999999
X008999999999999999999
Y008999999999999999999
Z008999999999999999999
Y008999999999999999999
Z008999999999999999999
Z008999999999999999999
X008999999999999999999
Y008999999999999999999
Z008999999999999999999

HERE I WANT TO CHECK FOR THE EXISTANCE OF 'Y' AND 'Z' RECORDS IN BETWEEN TWO 'X' RECORDS.
IN BETWEEN TWO 'X' RELEASTCORDS I CAN HAVE MULTIPLE 'Y' AND 'Z' RECORDS. AND IN BETWEEN TWO 'Y' RECORDS
I CAN HAVE MULTIPLE 'Z' RECORDS.

BUT ATLEAST ONE 'Y' AND ONE 'Z' INBETWEEN TWO 'X' RECORDS.

HOW DO I CHECK THIS?

PLEASE THROW SOME LIGHT ON THIS.

TIA.

ray.wurlod · Post by **ray.wurlod** » Mon Apr 18, 2005 6:20 pm

Be more precise with your requirement.

What, exactly, is your required output for each line processed? For example, for each X record, do you need the number of preceding Y and Z records (separate counts or combined count)? What is the output for Y and Z records?

The solution will certainly make use of stage variables, and maybe an aggregator stage, but the actual solution would depend on the precise requirement.

pandu80 · Post by **pandu80** » Mon Apr 18, 2005 6:29 pm

Hi,
After 'x' record there should be atleast one 'Y' and one 'Z" record.If there is no 'Y' and 'Z' records for the corresponding 'X' record i want to reject the file.

TIA

ray.wurlod · Post by **ray.wurlod** » Mon Apr 18, 2005 6:36 pm

Keep counts of Y and Z records. Detect these values when an X record shows up. If either is zero, reject the file (stop the job?).
Otherwise reset counts to 0 for X record after making the test (for example in another stage variable).

pandu80 · Post by **pandu80** » Mon Apr 18, 2005 6:43 pm

Ray,
Iam not able to make that logic.
could yo please explain me bit more.

TIA.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 19, 2005 12:52 am

Stage variables
svRecType init @NULL derivation Left(InLink.Column, 1)
svTest init 0 derivation If (svRecType = "X") And (@INROWNUM > 1) Then (svYCount = 0) Or (svZCount = 0) Else @FALSE
svYCount init 0 derivation If svRecType = "X" Then 0 Else svYCount + 1
svZCount init 0 derivation If svRecType = "X" Then 0 Else svZCount + 1

Constraint expression
svTest

pandu80 · Post by **pandu80** » Tue Apr 19, 2005 9:26 am

sorry. ray

let me put my requirement in right way.

my requirement is,

X--->Y---->Z
'X' IS PARENT FOR 'Y' AND 'Y' IS PARENT FOR 'Z'
SO IN VALID COMBINTAIONS ARE

X
Z-------> THERE IS NO PARENT RECORD FOR 'Z'

Y
Z-------> THERE IS NO PARENT RECORD FOR 'Y'

Z-------> THERE IS NO PARENT RECORD FOR 'Z'

IN THE ABOVE CASES I WANT TO REJECT THE FILE.

TIA

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Apr 19, 2005 10:26 am

You can try this,

stgFirstChar <- (default) ' '
stgXFound <- (default) 'N'
stgYFound <- (default) 'N'
stgZFound <- (default) 'N'
stgErrFound <- (default) 'N'

stgFirstChar <- left(link.record, 1)
stgErrFound <-
If (stgFirstChar = 'Z' and stgYFound = 'N') Or
(stgFirstChar = 'Y' and stgXFound = 'N') Then 'Y' Else 'N'
stgXFound <- if stgFirstChar = 'X' Then 'Y' Else stgXFound
stgYFound <- if stgFirstChar = 'Y' Then 'Y' Else stgYFound
stgZFound <- if stgFirstChar = 'Z' Then 'Y' Else stgZFound

Have the rows written to the output on the constraint that
(stgErrFound = 'Y')

stgZFound is optional for further processing. Also make the error message more meaningful to your requirement.