Sequence execution contrl based on file data value

mrvsr · Post by **mrvsr** » Mon Apr 14, 2008 11:51 am

Hi,

Please help me creating a sequence that will execute based on the value of the file generated in the process.

We have 3 jobs. job1, job2 and job3.

Job1 will read source and write to a sequence file. sequence file will have one field called TYPE. It will containe 1 or 2 for all the records in the file.
It will be input for job2 and job3. We have to execute the job2 or job3 based on the TYPE fileld value in the file generated by job1.

---------- job2
:
Job1 -------------
:
----------- job3

Pleaes let me know how to design the sequence for this flow.
How to assign Type field value to job/sequence parameter in the job1.
or
Without using any unix script inbet ween sequences

Thanks

chulett · Post by **chulett** » Mon Apr 14, 2008 12:30 pm

Create a routine to read/cat the file, use a Routine Activity stage to run and return this TYPE value. Then triggers or a Nested Condition stage can handle the branching based on the value returned.

mrvsr · Post by **mrvsr** » Mon Apr 14, 2008 3:32 pm

Hi Craig,

Thanks for the Solution.
Could you please tell me Is it possible to assign a value to the job parameter in job and use that parameter later in other job or sequence.
Also Please let me know is there any sample routine to read the file and return some value.

ray.wurlod · Post by **ray.wurlod** » Mon Apr 14, 2008 4:29 pm

For every record, you say?

Sounds like the easiest approach would be to use this file as the reference input to a Lookup stage at the start of Job2 and Job3 to determine whether to process that record. Run both Job2 and Job3 at the same time, if you have the resources.

chulett · Post by **chulett** » Mon Apr 14, 2008 5:30 pm

Ah, missed the "for every record" part. I'd suggest a Sequence job with a looping construct, in that case. Read the file into a UserVariables stage, feed that into a loop that runs one of the two jobs. Lather, rinse, repeat.

mrvsr · Post by **mrvsr** » Tue Apr 15, 2008 9:27 am

Hi Craig,

Could you please tell me how to write a parallel routine to Read the below file \data\outfile.txt and "field 2" value of the first line.

outfile.txt file contents:
Craig,2,91883
Roy,2,909-88
john ckenix,2,23411
smith,2,12142

chulett · Post by **chulett** » Tue Apr 15, 2008 9:38 am

Parallel routine? Nope, not my bag baby. However, you don't need one - just some piped OS commands using DSExecute will work: "head -1" and "cut" for example.

mrvsr · Post by **mrvsr** » Tue Apr 15, 2008 10:13 am

Hi Craig,

Thanks for solution.
I got one problem in comapring the script out put. The out put of th script is not matching with my condition though the output is same as I have given in the condition.

It is not executing the link with condition which should be true but executing other link(DSLink2).

I tried without UpCase and trim also.

Please see below the output of script and my condtions.

/data/TYPECHK.SH
Reply=0
Output from command ====>
xml

DSLink1:
UpCase(trim(Execute_Command_16.$CommandOutput)) = 'XML'

DSLink2
UpCase(trim(Execute_Command_16.$CommandOutput)) <> 'XML'

Please let me know if I need to do any other formating before checking the values.

chulett · Post by **chulett** » Tue Apr 15, 2008 10:21 am

Output like that is returned in a dynamic array, so you need to either remove any Field Marks (@FM) or just reference the first element. Try:

Code: Select all

UpCase(trim(Execute_Command_16.$CommandOutput<1>)) = 'XML'

For example.

mrvsr · Post by **mrvsr** » Wed Apr 16, 2008 8:50 am

Hi,

I tried In execute_command stage and Nested_condition stage.
giving below conditions but still its not working.

UpCase(Trim( Execute_Command_16.$CommandOutput[1]))="XML"
Execute_Command_16.$CommandOutput[1]="xml"
UpCase(Trim( Execute_Command_16.$CommandOutput[1]))='XML'
Execute_Command_16.$CommandOutput[1]='xml'
Execute_Command_16.$ReturnValue='xml'

Execute_Command_16.$ReturnValue=0

I dont understant why it is not able to compare the value which i am giving same as output from script.
Output from command ====>
xml

mrvsr · Post by **mrvsr** » Wed Apr 16, 2008 8:51 am

Hi,

I tried In execute_command stage and Nested_condition stage.
giving below conditions but still its not working.

UpCase(Trim( Execute_Command_16.$CommandOutput[1]))="XML"
Execute_Command_16.$CommandOutput[1]="xml"
UpCase(Trim( Execute_Command_16.$CommandOutput[1]))='XML'
Execute_Command_16.$CommandOutput[1]='xml'
Execute_Command_16.$ReturnValue='xml'

Execute_Command_16.$ReturnValue=0

I dont understand why it is not able to compare the value which i am giving as same as output from script.
Output from command ====>
xml[/quote]

chulett · Post by **chulett** » Wed Apr 16, 2008 9:03 am

Check what I posted and what you implemented - they ain't the same.

mrvsr · Post by **mrvsr** » Wed Apr 16, 2008 9:15 am

Hi Craig,

I tried this one also but its giving error at compile as Exprected:expression
Then I replaced <> with [] and compiled. ( I am using Version '8')

UpCase(trim(Execute_Command_16.$CommandOutput<1>)) = 'XML'

also tried

Substrings(UpCase(Trim(Execute_Command_0.$CommandOutput )),1,1)
= 'X'

Substrings(UpCase(Trim(Execute_Command_0.$CommandOutput[1])),1,1) = 'X'

Please let me know if I am still missing any thing.
or is there any way to print Execute_Command_0.$CommandOutput and see the contents

chulett · Post by **chulett** » Wed Apr 16, 2008 9:31 am

Odd, I do that here under 7.x.

Try:

Code: Select all

Convert(@FM,"",Execute_Command_16.$CommandOutput)="xml"

and see if that works.

mrvsr · Post by **mrvsr** » Wed Apr 16, 2008 9:43 am

Thanks a lot Craig,

Its Worked :D You mentioned to remove @FM in your first reply only But concentrated more on [1] and troubled you.

Once again Thanks for your time and sharing your immense knowledge with us.

DSXchange

Sequence execution contrl based on file data value

Sequence execution contrl based on file data value

Routine to read file and return value