DSXchange

snassimr,

I am assuming that you have used parameters in jobs before, so you cannot be asking how to declare and utilize them in job design and at runtime, so you must be asking something else; could you please explain where you are encountering difficulties?

Ray - the code part is a new one to me, I recall having to FNUXI ported code (after the runtime engine tells you to; so at least the interpreter noticed that something was wrong with the magic number). I guess the enhancement isn't technically difficult, but as you stated it would slow down the proc...

Vmcburney, Thanks for the update on your performance testing, which was more rigorous than my quickie attempt. My tests were on a pretty hefty 8 CPU AIX box and I was using a 4-node configuration; so it is likely that I had enough memory in the system to not get into swap mode, so the differences in...

Nope, no standard routine exists, the complexities of which places switch when to and from daylight savings time were beyond the scope of the team that put together the utilities - but they did put in Swatch time

Mohan,

please try it and tell us if it works.

Vinodlakshmanan, a deadlock process is one which looks for orphaned locks and or processes associated with a program system. Usually this type of program can be found with Databases, since they use a lot of locks and do suffer from orphaned processes, but other types of applications require the same...

sathyanveshi,

it is used to establish additional options for the connection to Oracle. At my current site, we add in OracleArraySize to increase the Oracle array size. Other attributes that are session specific can also be put into this space.

Good morning Ran, there are actually two parts to your question - the first is getting rid of the symptom of an orphan job and the other is finding out how it happened so that you can avoid the issue in the future. Most likely your repository has some messed up pointers, you can repair this by going...

bapajju, The number of columns is irrelevant to lookup speed, the number of bytes of data in those columns is. It will always take longer to transfer 10 columns filled with 1000 character per column than it will to transfer 10 columns of only 1 character per column. That said, it is always best to r...

Perwezakh, if you define a datastage job that takes the .csv file and outputs to another sequential file, but in this file's definition you specify "fixed length" DataStage will pad out any varchar or numeric columns to their maximum length per the metadata and you don't have to do any manual transf...

pandu80, I think your approach is lacking a bit. For instance, the string 'Hello World' would be considered a number, as would any non-empty string (for different reasons). I don't have a ds system to check right now, but I would use the NUM(<value>) function to start with. If you want a detailed ch...

Yes, just specify the #DSNIdentifier# in the appropriate field in the ODBC stage.

Paul, that was in interesting question, I'd always wondered about it but never really looked into it. The answer is: Characters 1-31, and 127, and 129-159 are unprintable. I did a quickie function in datastage to test this that you can use as well: FOR i = 1 to 255 IF (OCONV(CHAR(i),...

Damn - should have checked about the DELETE.DF before posting. Ray is right, it doesn't exist. What you need to do is DEFINE.DF <distfile> REMOVING <partfile> for all of your partfiles, when the last valid partfile is removed the system will remove your master file definition. The partfiles can then...

There are some really interesting OPCODES out there It is actually possible to decompile the program and get almost everything back out except for variable names in common blocks. Plus a CASE won't go back because DS actually treats it as a IF-THEN-ELSE construct. I wrote a decompiler a while back -...