cancel
Showing results for 
Search instead for 
Did you mean: 

First 10 records from flat file using windows batch script

naveen_vuppala2
Explorer
0 Kudos

Hi Folks,

I need a windows batch script for

How to First 10 records from flat file using windows batch script

How to process recent file in the windows folder using batch script.

Thanks,

Naveen

Accepted Solutions (1)

Accepted Solutions (1)

former_member198401
Active Contributor
0 Kudos

Google

What are you trying to achieve.

Regards

Arun Sasi

naveen_vuppala2
Explorer
0 Kudos

Hi ,

I want to retrive only first 10 records from flat file and should be filtered out at operating system level or in the BODS designer.

Using head -n command we can ahieve in unix but how in windows?

Thanks,

Naveen

Former Member
0 Kudos

In BODS, open flat file properties ( Double click on flat file ).

and set Rows to read as 10. Done...

former_member187605
Active Contributor
0 Kudos

There exists a more generic solution (that also applies to tables).

Include a where-clause in the Query transform: gen_row_num <= 10.

naveen_vuppala2
Explorer
0 Kudos

Hi Shailesh,

Which version of BODS designer it is?

I didn't see this in my designer..

Naveen

former_member187605
Active Contributor
0 Kudos

This option exists in all versions. But it is not available in the File Format definition, only in its usage.

Navigate to the data flow where you use the file format as a source. Open it and... there you go.

Answers (0)