Job control Awk issue

Ashish · Post by **Ashish** » Fri Mar 06, 2009 8:27 am

Hi,

When I am running the below script in Job control, File1 is created but no records ideally it should have 1000 records, I don't know why awk script is not taking parameters.

A =1
B =1000
when I am passing this parameter to below
FileBack = "awk 'NR==A,NR==B'":" ":FileName:">":FileName:"1"
Call DSExecute('UNIX', FileBack, out,Return)

Please suggest the solution
Thanks
A

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Mar 06, 2009 8:33 am

A and B within quotes may be taken a literal.

Display the FileBack before executing.

What are the resulting values for out and Return?

Ashish · Post by **Ashish** » Fri Mar 06, 2009 8:38 am

Return code is 0 which means script ran fine
out is blank

chulett · Post by **chulett** » Fri Mar 06, 2009 8:41 am

What does the log show as the actual command that was executed?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Mar 06, 2009 9:53 am

Does the source file have any record in it?

Ashish · Post by **Ashish** » Sun Mar 08, 2009 11:08 pm

Yes, src file got 3000 records but I want to create 1000 record file but i don't want to hard code the values for NR, i wanted to pass it through paraemeter only.

Kryt0n · Post by **Kryt0n** » Sun Mar 08, 2009 11:27 pm

You concatenate FileName in to it, but don't do the same for A and B

FileBack = "awk 'NR==" : A : ",NR==" : B : "' ":FileName:">":FileName:"1"

Ashish · Post by **Ashish** » Mon Mar 09, 2009 1:29 am

Thanks for the solution :)