DSXchange

I think Craig has a valid point. I prefer sequences because it is easier to maintain after I am gone. I think Hester, Ken Bland and others have similar methods as Craig because it gives them control. They have had restart capabilities for a long time because of this. At some point maybe they need to...

I really don't like this style. What happens when you want to reorder your jobs? Do you rename them? I prefer the name to have the target table in it somewhere. I like E to be somewhere in the name of a job that goes against the source. I think the order is the least important feature. I think the t...

http://www.dsxchange.com/viewtopic.php?t=89234 is where it is.

Do an exact search for DS_METADATA where Ray is the poster. Modify his code.

Ray posted code to take DS_METADATA and save it as XML. That should get you close. Either that or you could save as comma delimited and import that into Excel.

Mr. Craig

Come to think of it memory leak could not be your problem because of your error message. Something in a hash file blew up. Was your hash file over 2GB? Another thing might be a char(255) or 254 in your data or key. Is that possible?

Craig We had a memory leak which caused problems like this. It had nothing to do with the hash file. It was running out of process memory. Do a ps command to see if the process is growing. I would try a type 18 file as well. Maybe type 2 is the problem. Eliminate any possiblity. Just a couple of ide...

There was some SQL posted which listed the hash file names. You need to do this in a program and see if a hash file is still being used.

This may be a feature in the next release of Parameter Manager where you could set all the parameter defaults. This would be called a Data Set. So if you have 3 Data Sets for Dev, Test and Production. When you promote your jobs from Dev to Test then you apply the Test Data Set. This would for exampl...

This topic should be in the Server Forum.

You have a couple issues which it maybe erroring out on. If you use it as a number and it is @NULL. You maybe doing substrings [] on @NULL. I would also change this into a case statement. Begin Case Case Num(Arg1) Begin Case Case Arg1 < 100 some code... Case @TRUE default code... End Case Ca...

Please format your code and the do alt-c before and after pasting it. This will save the indentation. This is unreadable.

You cannot use the return value in a routine activity because it should return @TRUE or @FALSE. You have to return the value in an argument.

Does the sequence have mutiple instances checked in job properties?

Please post a new topic to ask a new question. ReadHashFile(HashFileName, KeyValue, HashRec) Ans = 1 open HashFileName to HashFile then read HashRec from HashFile, KeyValue else Ans = 0 end end else Ans = 0 end return(Ans) Where HashFileName, KeyValue, HashRec are the argument names ...