DSXchange

The job name is stored in DS_JOBS.NAME. The link name is stored in DS_JOBOBJCTS.NAME. You need to search for a query which joins these two tables together.

It depends on if it is cached. Records are processed a block at a time. Most OS will cache a filesystem outside of an application. So if your UNIX filesystem is a 4K filesystem then 4K is read into a buffer and UNIX only goes out to read another block when the pointer goes past 4K bytes. Windows doe...

I agree but we may need more categories whether we like it or not. Got to train more people to use the correct category. I try to ignore categories and topics that I know others will answer better. Hester seems to answer crc32 questions and a few others. That is cool. I avoid date questions, PX, TX,...

Guys

I doubt if they can store which ones we have read. Too many combinations. All this query is doing is > last connect time. Last connect is stored once for each of us. I think you are asking for something impossible.

I think the easiest way is to compile all jobs. Enable job adminstration in Director. Delete all jobs which do not compile. After a normal job run then all jobs in compile status are targets to be deleted. Routines are another issue.

Backup all jobs first.

KBA = Kenneth Bland Associates like his web site.

http://www.kennethbland.com/

Yes, use a UV stage in a server job.

Look at this http://www.dsxchange.com/viewtopic.php? ... TTIMESTAMP

Look here http://www.dsxchange.com/viewtopic.php? ... light=CSeq

That what I tried to explain that SaveAsBmp only saves as .bmp. You can force it to make the filename .jpg but it is still a .bmp underneath. You need a third party tool to convert the .bmp to a true .jpg. There are lots of them.

What is the internal command for running the jobreport from the designer. Like as in the case for getting a picture using DSDesign SaveAsBmp parameter. I understand that the KgdGenHtml does generate the report too. But I curious that wether I can call it from the DOS. The job report in Designer is ...

I would do it with an update on DS_JOBS. I would do this in a new project so if you mess it up then just delete the project.

My personal preference is to save a job in \Save\OriginalCategory with JobNameYYYYMMDD. I prefer to have all jobs grouped by target table. So the category is target table name like CustomerDim for CUSTOMER_DIM. I like Pascal names. Job names should maybe start with Src, Tgt or Stg for Source, Target...

This post http://www.dsxchange.com/viewtopic.php? ... highlight= will show you how to make a read only object to read write.

If your code is read only then post again and I will post it here. Besides you should of had a file named GenHtmlPicDiv.rtn in the zip file. It is a text file. Change it to GenHtmlPicDiv.txt and edit it. The same for all the routines.