Regarding FILE SIZE...ANY IN BUILD FUNCTION THERE

devaraj4u · Post by **devaraj4u** » Wed Oct 08, 2003 1:01 am

Hi All,

I am Opening a text file("Rates.txt") using the
openseq to and we had Error handling routine also like On Error etc etc... and closing the file can be handled by Close

Pollfilename = "D:RatesfilesRates.txt"

eg Openseq pollfilename to pollfilevar

If i able to open the file successfully i want to check the for file size should not be "Zero" then i want to proceed with otherwise warning stating "File size is Zeri"...is there any built in Routine like fsize(filevar) available in Datastage....

Please guide me...

Ray please help me...how to find a filesize in
(low level file handling) and command / file handling function...

Thanks & Regards,
K.S.Rajan.
SCB,Singapore.

kduke · Post by **kduke** » Wed Oct 08, 2003 9:04 am

K.S.Rajan

file = "KDBPOpenSeqSize.uvb"
openseq file to SeqFile else stop
status FileInfo from SeqFile else stop
FileSize = FileInfo
print FileSize

Kim.

Kim Duke
DsWebMon - Monitor DataStage over the web
www.Duke-Consulting.com

ray.wurlod · Post by **ray.wurlod** » Wed Oct 08, 2003 9:51 pm

Can't help any more than that!
Kim's is exactly the answer I'd have given. [8D]
Except, maybe, the STOP statements.

Check out the STATUS statement (not the STATUS function) in the BASIC manual (in the Docs folder where you installed DatatStage clients).

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

kduke · Post by **kduke** » Thu Oct 09, 2003 8:25 am

K.S.Rajan

Ray is right. Please don't leave the stops in the code. I make my code brief and to the point so it is easy to understand. In no way would I implement simple code like that.

Kim.

Kim Duke
DsWebMon - Monitor DataStage over the web
www.Duke-Consulting.com

devaraj4u · Post by **devaraj4u** » Fri Oct 10, 2003 1:12 am

Dear Kim & Ray,

Thanks a lot for your help...Exactly the Code is very much useful...i used it in my program....Thanks a lot...Have a nice weekend...

Thanks & Regards,
K.S.Rajan.