Parsing a file in Unix or DataStage

[AngelMady]

Hello,

I have a curiosity:

I have a script ksh which launches a job control which launches a job sequencer.

Before launching the job sequencer I want to parse a file and verify its structure. If the structure is ok then I should launch the job sequencer else nothing should happen.
Parsing of the file can be done with script ksh or the job control.
Do you know which is the best method?


Thank you in advance for your return.

Madalina

[chulett]

Welcome. :D

There really is no 'best' method, do whatever works and is maintainable by the crew you have there. I would think something of this nature would be better handled in a script, depending on exactly how much of the 'structure' of the file you are attempting to verify. However, like most things DataStage, there are usually multiple ways to solve any given problem.

[bkumar103]

for parsing i would prefer to go for the shell script because of its performance. Using the awk command the the format can be vefied easily in the Ksh.

[jdmiceli]

Perl is also quite fast for this type of activity and a little less cryptic (in my humble opinion).

Bestest!

[AngelMady]

Hy,

In my opinion the fastest method to parse a file ( for exemple testing the length of the lines ) is to do it in a script.

I wanted to see if my opinion was right.

So, thank you all for your answers

Madalina

[turash]

Perl is a good option according to me anything to do with file handling or file manipulation.

Hello,

I have a curiosity:

I have a script ksh which launches a job control which launches a job sequencer.

Before launching the job sequencer I want to parse a file and verify its structure. If the structure is ok then I should launch the job sequencer else nothing should happen.
Parsing of the file can be done with script ksh or the job control.
Do you know which is the best method?


Thank you in advance for your return.

Madalina