DSXchange

There are a lot of jobs here. GenHtmlFromSql is a job which will turn a SQL statement into a html page and email it to you. GenHtmlFromSqlDriver is a driver job for the above job. It will give you a list of SQL statements already built and used by me. These SQL files are stored in a driectory called...

I posted a new EtlStats.zip. I added logic to email row counts and log files on failed jobs. I have a new process to report completeness on any dimension. The documentation is m All of this is available on my tips page. Sample row counts m Sample log reports m Sample completeness reports m I will al...

I think I posted code to do it using DsObjects. Do a search. That code is also posted in VB. This way you do not need dsjob loaded on all your clients. It maybe more difficult to code though.

You are using a named common. It also looks like you may be redimensioning the array that is in common. Not a good idea. The common should be the same size every time you access it.

You need to open the file you are writing to. Just like you opened the one you are reading.

There are no wrong answers to Q13. Right? Therefore I can answer it.

Even I have not been able to figure out the answer to Q13.

Geez, Ray could not answer a question. I am .

Vincent Do you have examples of this? I was also wondering if someone has done this on the DataStage xml exports. If so would they post the html code. I do not know anything about how xml is displayed in a html page. I learn html on an as needed basis. If it is not a lot of work to explain then plea...

Okay, I was in a good mood. No more Mr. Nice Guy. From now on I will follow the unwritten rule. Sorry.

Those macros. Isn't there some kind of macro built around job templates?

Mike Thanks. I know we really do not want to help people get jobs when they do not know these answers. Someone sent me a real nice email so I answered this. How do macros work by the way? (12) In my mind it is okay not to know it all. Only Ray knows it all at least when it concerns DataStage. Has Ra...

I hope these are not questions in a job interview. 1) I would use Version Control. 2) DataStage itself is a staging area including hash files and sequential files. 3) Syncsort is a third party tool that sorts flat files very fast. Cosort is a similar product. All of this use plugins. 4) Job paramete...

I do it all the time in a server job. On my tips page or on ADN you can download KgdGenHtml.zip. This generates html documentation on one or all your jobs and routines. It is free. Source code on most of it is included. I will post a new version soon. The new stuff was improved to be used with EtlSt...

Put one in a hash file and then look it up. You could also strip the first line with a UNIX command and do a cut command to cut out the fields you want to do it in UNIX.

You would probably need to run both in a command line mode. Then write a shell script or a DOS batch file to do both.