DSXchange

This was posted in my user group: * ------------------------------------------------------------ * KgdMakeDir(DirName) * Decription: This routine will make all the dirs in DirName * Written by: Kim Duke * Notes: * ------------------------------------------------------------ * $INCLUDE DSINCL...

I learn from examples. That is why I looked at the SDK. It is also why I post code all the time. There are lots of routines for free on my tips page. Look through these and try to figure out what they do. Ask when something does not make sense.

I posted a routine which can be used as a routine activity. Any routine activity can take parameters.

If you are using column generated or fully generated then the columns can be in any order. I have a routine which will sort the column names in DS_METADATA. I am looking for it now. When I find it then I will post it if you ask for it. I thought I already had. Updating DS_METADATA and other IBM hash...

That is really odd. You fixed it in DEV and TEST but not PROD? Did you change your Oracle client? If you did then I would suggest that you have different versions on the different machines. Maybe you have a memory leak in your Oracle client.

The FAQ are a lot of work to put together. In this case there are too many answers to pull it together into one FAQ.

I prefer making each if then a complete statement:

Get an evaluation copy of DwNav from my web site. That is what it was designed for besides a few more things. It will generate similar documentation plus document all jobs and routines in a project. It can now save any report as a html document. What else do you need. There are also other free solut...

If you do that then you need to recompile the job. I am sure Ray will give us the full Wurlod. If you look at the IDs in the RT_STATUS file then you can tell what is a instance id. If you delete those records then you need to disconnect from the project and reconnect to refresh this list. I think th...

Arnd

Create the projects on another box and copy the file at the OS level. I would just create one or two projects then copy this file to another file name. Fix the VOC to point to this copy. Update it. Copy to the other machine.

If your hash file is over 2GB then you need to add the 64bit option. Look at the OS level and add the sizes of DATA.30 and OVER.30. I wouild say make it 64 bit no matter what. This is a large hash file and why worry about it. If it does it on all 3 boxes then it has to be too big for 32 bit hash file.

Srikanth What is the size of the file? Usually this is a hash file which is corrupted. This usually happens when you have a system crash or run out of disk space. If your hash file is created in the account then at TCL do DELETE.FILE MyHashFile or CLEAR.FILE MyHashFile If it is a respoitory file lik...

The problem that the table name can be all lower case, all upper case or a mixture. You need to change :1 into your table name in upper case. This SQL is a part of EtlStats. It is called DsSearch1.sql. It is executed by job GenHtmlFromSqlDriver. Put your tablename in parameter named Replacements. It...

If a parameter is a list type and not a string or some other type then this is used as a drop down list to start a job. I do not think all these values are available at run time. Only one value is active. Arnd's code would work if all these values were available. You might be able to use something t...

Web master

It would be nice to see my responses after I send a private message. Unless they quote it back to you it is hard to remember what you said. Maybe because I am too old but still it would help.