Writing into a text file

dstage443 · Post by **dstage443** » Tue Jun 03, 2008 9:34 am

I need to write some predefined/static text and also some variables such as DSgetlinkinfo and someother parameter values into the File.

what are the functions to write into a sequential file. .... how can this be done

chulett · Post by **chulett** » Tue Jun 03, 2008 9:46 am

Why not just create a job to do this for you?

Krazykoolrohit · Post by **Krazykoolrohit** » Tue Jun 03, 2008 9:47 am

Craig,

I think he wants information on how to create that job. I was about to write "read the manuals" but i held myself up.

chulett · Post by **chulett** » Tue Jun 03, 2008 9:52 am

Well, there are functions (OPENSEQ,WRITESEQ,etc) but wondering if that's really what is wanted here or if a simple job would do the trick.

dstage443 · Post by **dstage443** » Tue Jun 03, 2008 10:04 am

well thanks for the replies .... i am reading the books but i am not even half way through ....

chulett · Post by **chulett** » Tue Jun 03, 2008 10:10 am

Ok. What exactly do you need help with, where are you stuck? Building the job? Hand coding something in BASIC using functions?

dstage443 · Post by **dstage443** » Tue Jun 03, 2008 7:17 pm

but wher do you actually write the code so that i can execute this code in datastage so that it will write into my file

OpenSeq "c:\TEST\TEMP.TXT" To TestVar Then
WeofSeq TestVar ;
WriteSeq "test line -- writing a line into file" To TestVar;

ray.wurlod · Post by **ray.wurlod** » Tue Jun 03, 2008 7:21 pm

In a Routine. Probably in a before/after or job control routine.

DataStage BASIC Notes
1. Lines do not require a ";" terminator.
2. "Then" or "Else" on the end of a line open a block of statements that must be terminated by an "End" statement.

Tip
Track down the OpenSequentialFile() function (search DSXchange) which covers some of the issues that your code doesn't, such as opening a file for writing when the file does not yet exist.