When do the Project and Job property defaults take effect?
Posted: Tue Feb 13, 2007 2:47 pm
using Parallel job, converting timestamp from Sybase format to Oracle format.
At the project level and at the job level, one can use the system-provided timestamp format, or change it to a user-defined format.
I used the system-default, and I used multiple format attempts of my own
in both levels.
Nothing seem to be affected. I always got the same errors in the log.
I assume that the system format is used unless the job format is different, in which case, the job format takes precedence?
When do these format get used?
Also, where are the format elements defined (I couldn't find them in the docs on in the Help)?
For example: %mm = 12, or %MM = 12, or %mmm = DEC or Dec, or %MMM = DEC or Dec, or %M = DEC or Dec, or etc, etc, and etc. ???
-- john
P.S. if you are wondering why I'm asking about the timestamp since I have already converted it using my own 'C' program object file (creating my own function) [see my other post]. The reason is that all of us here on the project believe that converting a Timestamp should be one of the most basic elements of DataStage, especially from Sybase to Oracle. But, we don't see any such capability.
PLUS, after converting to the precise expected Oracle format, using the 'C' function, it still did not go into the Oracle table. So, there is still much yet to understand: For example: I used VarChar as input. But, what should I use as output: VarChar or Timestamp? Neither worked.
This simply should not be this hard. There is something very basic we all are missing here.
At the project level and at the job level, one can use the system-provided timestamp format, or change it to a user-defined format.
I used the system-default, and I used multiple format attempts of my own
in both levels.
Nothing seem to be affected. I always got the same errors in the log.
I assume that the system format is used unless the job format is different, in which case, the job format takes precedence?
When do these format get used?
Also, where are the format elements defined (I couldn't find them in the docs on in the Help)?
For example: %mm = 12, or %MM = 12, or %mmm = DEC or Dec, or %MMM = DEC or Dec, or %M = DEC or Dec, or etc, etc, and etc. ???
-- john
P.S. if you are wondering why I'm asking about the timestamp since I have already converted it using my own 'C' program object file (creating my own function) [see my other post]. The reason is that all of us here on the project believe that converting a Timestamp should be one of the most basic elements of DataStage, especially from Sybase to Oracle. But, we don't see any such capability.
PLUS, after converting to the precise expected Oracle format, using the 'C' function, it still did not go into the Oracle table. So, there is still much yet to understand: For example: I used VarChar as input. But, what should I use as output: VarChar or Timestamp? Neither worked.
This simply should not be this hard. There is something very basic we all are missing here.