DSXchange

Because that's the only way Oracle stores dates.
Even though the data type is DATE in Oracle, you can specify a date picture of 'YYYY-MM-DD HH24:MI:SS' for example, and it's all OK.

Set your rule to "clear file before writing" on the Hashed File stage's Input link.

In every computer I've ever encountered (and we're going WAY back here!) addition and subtraction have required fewer machine cycles than multiplication and division. With today's fast processors the difference is unlikely to be noticeable until you get to very large numbers of arithmetic operations...

Hi All, us and our large hash files again.... We are taking the approach of squeezing our lookup tables in under the 999MB limit for each table so we are doing our best to take everything out of hash tables that we can to minimise the #bytes. We thought we had got there. For example I have now a 21...

This is outside my BAT file skills too, so here's a custom routine that you can call instead of ExecDOS. Create the routine making its type "Before/After Subroutine" (this is vitally important). Place the base name of your file (that is, the parameter we've already been discussing, #FileName#) in th...

You don't need a stored procedure for that particular task; it's an ordinary update. Set your "rule" to "update existing rows only", specify that Field2 and Field3 are "Key" (it's OK to lie here), deliver the values "A" for Field 1, 10 for Field 2 and 20 for Field 3. If you really must call a stored...

Setting project-wide defaults for things like log purging and national language support. Setting security - which groups can be developers, which groups can run only (operators), which groups have no access to DataStage. Re-building indexes in the Repository. Managing locking and processes within th...

Assuming that you are referring here to two text files, the answer is no. This is not a DataStage restriction, it is an operating system restriction. The operating system will not permit simultaneous writers to a file. In theory you could add a second Transformer stage to add the extra lines to the ...

What stage type inside the shared container contains the "dynamic SQL" statement? What you seem to be trying to accomplish here is to have the following architecture run at no cost; that is, to run at the same speed as if it weren't there. The layers are: UNIX osh (several processes) DataStage job p...

Calling C functions from server (= DataStage BASIC) is possible, but not for the faint hearted. It's done through a mechanism called the General Call Interface (GCI) and, among other things, requires that you statically link the function library into the DataStage executable. That is, you have to bu...

"Phantom" simply means "background process" in DataStage terminology. The message you're getting indicates that somewhere in your job design a variable is not being assigned. This could be in a stage variable not being initialized, or it may be in a Routine invoked from an expression in the Transfor...

What exactly do you want to debug? What condition is occurring that you feel to be abnormal? Am I correct to assume that you're using TmpFileDirectory_PHSCO as the first (input) argument, and ErrorCode as the second (output) argument? The main problem I can see in the design is that it keeps going e...

The option is on the General page of the Inputs tab. Better design is to segregate the rows to be inserted and updated so that one link can handle "insert new rows only" and the other link can handle "update existing rows only". In this case, preserve the original value in a column simply by not del...

The answer to the question is NO. The hashing algorithm can only be used (and only makes sense) if the exact value of the key is being sought. It is the value of the key that is processed by the hashing algorithm to determine the location of the record. You can improve performance markedly by indexi...

Private message: Hi Ray, I am attempting to secure a routine with the guidelines you suggested but as I spend more time coding in SQL, I will need more clarification. When you wrote about creating the routine separate from DataStage, were you referring to creating a VB module? Then, I can use the co...