DSXchange

How to read a file record in data stage ROUTINE ?

Please avoid posting interview questions.

If you want answer, search here or in the documents.

Raising questions like this and expecting answers without any effort will irritate people who are putting real effort.

Why not post what it is you are trying to accomplish, instead? For example, what is this routine meant to do?

Oh, and there's always this but you'll need a Premium Account to see all of it.

i want to pass the records in a file as a parameter to a job

Not exactly a beginner's task you've taken on. What exactly do you mean by what you posted? You will be doing this "passing" from the command line using dsjob, or inside a Sequence job to a Job Activity stage or what? Do these files have a single record in them or multiple records? Do you literally need to pass the contents in as a parameter value or does the file contain "name value pairs" (like "jpDateToday=11/13/2009") and you need to not only read the file but also parse the lines, locate any parameters with those names in the job and assign that value to them?

Details are wonderful things and we're a little short on wonderful at the moment.