DSODB - List details of files written from host

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
tbtcust
Premium Member
Premium Member
Posts: 228
Joined: Tue Mar 04, 2008 9:07 am

DSODB - List details of files written from host

Post by tbtcust »

I have task to find all files being written from a given DataStage host along with the start write, end write times, and other details. I'm hoping I can pull this information from DSODB. Is it possible to query for the following result set?:

HostName
ProjectName
FolderName
SeqName
JobName
StageType
StageName
FilePath
FileName
StartWriteTime
EndWriteTime
NumberOfBytes

Any direction or help would be greatly appreciated
Post Reply