How to find EOF using DataStage

[parag.s.27]

Hello All,

Can you please tell me, whether there is any inbuilt function or routine in DS to find the end-of-file. Currently I am not able to find an economical way.

I am using ExecDOS before stage subroutine and calling a batch file that finds the EOF, also it is doing same in Command Stage, but the problem is, how can I use the output of this DOS command in my transformer.

For e.g. I have to find the EOF and then in the next line I have to insert some identification flag. so that when next time the data gets appended to this file, I'll be using the flag to define the constraints in the transformer.

[ArndW]

The normal method of reading a sequential file in a DataStage job does not let you append a row easily using that methodology.
This can be done with a simple command at DOS or UNIX, you can also open and append data to a sequential file from inside a DataStage routine (using OPENSEQ and SEEK)

[DSguru2B]

Run the OS level command using DSExecute() in a routine. Reference that routine inside the transformer.

[kumar_s]

You are appending a flag to a file. Like
Cat 'Flag' >> File.
You can use tail command to read the last line in CommandActivity and use the CommandOutput to pass the value as parameter to the job.

[parag.s.27]

Run the OS level command using DSExecute() in a routine. Reference that routine inside the transformer.

I have tried a similar approach like calling the command in command stage and then the COMMANT.OUTPUT value of command stage is fed to transformer directly.

It is throwing an error of Command not recognized as internal or external command. But when i run the same command from DOS prompt, it works fine. Is it like DS supports a particular version of DOS

[chulett]

Is it like DS supports a particular version of DOS

No, it just leverages whatever it is you got. Post your command.

[parag.s.27]

Is it like DS supports a particular version of DOS

No, it just leverages whatever it is you got. Post your command. ...

Hi,

I am using the command as

Code: Select all

cd\

FIND /N /C "WRI001" c:\Parag\sage_dovegate_inddata_sales_ledger.rpt >> c:\Parag\cmdout.txt

here WRIoo1 is the flag value.

[DSguru2B]

Can you wrap that command in a .cmd or .bat file and execute that bat file from DSExecute()?

[asitagrawal]

Open the file using OpenSeq.
Use SEEK to move the pointer to EOF.

Refer BASIC guide for more details.

[ray.wurlod]

Not a good solution, because the file variable that you SEEK to eof only has scope within the routine. The OP's requirement was to "find" eof (whatever that means - I have no idea). You could get the size of the file (from DIR) and use that, I guess, as the address of EOF. But what purpose will it serve?