datastage script(basic)

[ravindrag]

I want to extract records from a flat file using datastage script(basic).Can anyone PLease Post The Script?

[Kirtikumar]

You can use the normal basic functions like OpenSeq, ReadSeq which can be used to read the data from the seq file.

I doubt if you will get the whole code for doing this from someone. You may have to try certain things on your own and if you get stuck, you can post here.
HTH.

[ArndW]

Ravindrag,

Are you sure you want to do this? The DataStage Sequential file stage does this in a quick, simple and understandable manner. If you really wish to write a script you will find many examples in this forum using search.
The main components will be:
- OPENSEQ to open the sequential file
- READSEQ to read a record on an opened file
- CLOSESEQ to close the file handle when finished
- A "FOR / NEXT" or "LOOP / UNTIL" construct or {I don't like this way} using "IF / GOTO".

[rameshrr3]

Code: Select all

OpenSeq PathName To F.Var Then
Loop
ReadSeq Dummy From F.Var Else Exit ;* at end-of-file
Repeat
WriteSeq ReportText To F.Var Else
Call DSLogFatal("Cannot write to ":PathName, "MyRoutine")
End
End Else
Call DSLogFatal("Cannot open file ":PathName, "MyRoutine")
End

Above code fragment is to write to seq file a string
in append mode.
Why dont you use a sequential file stage to read from file?

[rameshrr3]

Reminds me of a seemingly crazy requirement to write a custom 'log file', apparantly for 'easy readability', as if the data stage director log is in hex.

[ravindrag]

Thank you very much guys...