DSXchange

Can you build the insert statements into a .bat or .sh file? If so, you can execute the file from a job sequence using the ExecDOS or ExecSH routines.

Could you build a stored procedure based on the commands? Then you could run the stored procedure as before or after sql.

Try my List all files and tables used by jobs in a dsx file utility. It reads a dsx file of your job designs and routine sources, and creates a csv file of category, job name, input/output, and table name/file name/user defined sql. You will find it and other tools on the DataStage Tools page of www...

Try my List all files and tables used by jobs in a dsx file tool. It produces a csv file that you can use with tools like excel to answer your question.

This, and other tools, can be found on the DataStage Tools page of www.anotheritco.com.

Although I do not know if this is the final solution, I am still waiting for IBM to call me back, I edited the Log On properties of each of the three DataStage services, checking the Allow service to interact with desktop checkbox. Now my clients can connect to my Windows Server 2003 DataStage server.

Within a job, you can use a routine that uses looping statements. Look in your online Basic manual at the LOOP and FOR statements.

We are running 7.5.2 on free VMware server hosted on a Windows 2003 Server 64 bit HP DL385. It appears to be working fine. We moved into production last Wednesday. Our old server was out of horse power. Based upon faster hardware, performance has almost doubled. However, free VMware Server is limite...

I have had problems with the client tools (designer, director, and manager) running on 64 bit. Let me know how the server goes.

If your ETL process builds a sequential file for the complete reload of the table, you can use the unix COMM command to return to you the unique rows from your current and you previous load files. Load these unique rows into two hashed files. Read from the first and lookup in the second to determine...

Hi Brad, I am not sure why you are seeing CHashedFileStage. Although you say the tool is reporting a table name, when you look at the specific job in designer, what stage is it using? CHashedFileStage is a hashed file stage, but the tool has not determined if it is being used for input or output, ye...

We have had issues with Designer 7.5.1.A deciding to crash usually when working with sequences. Reading the release notes for 7.5.2, some of these problems may be corrected there, and the 7.5.2 clients are compatible with the 7.5+ servers. You may want to test this too.

Take a look at the Index() function. It will return a non-zero value if the substring you are searching for is found in the string.

I post my DataStage tools on www.anotheritco.com.

You can use my List all files and tables used by jobs in a dsx file to create an inventory of your files and tables by job. You can use the resulting csv file to track jobs that use a file. To best use the tool, create a dsx file with just job designs and routines (including source). You will find t...

My List all files and tables used by jobs in a dsx file tool can help you identify impacts at a file and table level. Since it works with a dsx file, it does not require that you followed best practices with your metadata repository. You will find it on the DataStage Tools page of www.anotheritco.co...

99.999% of the time, I have found the benefit from moving to a visual approach to job control is priceless. I think this even applies to putting RoutineActivity stages around each JobActivity stage. You can convey your intent visually with proper naming conventions. In traditional JCL, we called the...