DSXchange

Hi,

how to take the back up the log files for n days

thanks,
sudhakar

This query may help you Where nn is the jobnumber.

Better to take the 'dsjob' approach as it is more 'future proof'. IMHO.

hi loveojha2 ,

how can i execute this Code in unix

SELECT TIMESTAMP FROM RT_LOGnn WHERE TIMESTAMP >='1900-01-01' AND TIMESTAMP<='2006-01-01'

thanks,sudhakar

You cannot, this is a command that needs to be executed in TCL or from the ADMINistrator command.

You can, by invoking TCL from the command line. But, as Arnd suggests, this is not future proof. In the next release ("Hawk"), job logs are not stored in this fashion.

Hi ray.wurlod and ArndW ,

Thanku.I want to store the result in unix file.how can i do that.


thanks,
sudhakar

how about a command like dsjob -logsum MyProjectName MyJobName > MyUnixTextFileName.txt from UNIX.

hi ArndW ,

i want to execute this query in unix
SELECT TIMESTAMP FROM RT_LOGnn WHERE TIMESTAMP >='1900-01-01' AND TIMESTAMP<='2006-01-01'

and i should store this result into one text file in unix.

how to do that?

thanks,
sudhakar

Simply redirect output into your file using the ">" redirection operator.

Note, however, that SQL can not be executed from UNIX, no matter how much you may want to do so, because UNIX is not a database environment. You need some kind of wrapper, such as exemplified in earlier posts.