on one hand I'm relieved that you understand the doc's exactly as I did.
On the other hand that doesn't help to resolve this issue, so please forgive me my follow-up question:
if I understand the doc right, there's a certain parameter in the Db2 instance setup which controls the string format for TIME attribute values. Do you happen to know which parameter this is? I would like to have our DBA look it up so that I can adapt the string value accordingly, but he doesn't know off the top of his head which parameter to look for.
Thanks and regards,
You can look at
However, DB2 stores Date/Time values in an internal format, not in character strings, so I would not expect the default format to matter.
yes, I understand that, and indeed I do not care for the internal format. I just hope (according to the documentation link that you have posted) that this format will tell me how I have to format a string so that I can write it to a CHAR attribute.
Thanks for your help (as always ) and cheers,
sorry for the follow-up question:
In PowerCenter you can enter so-called "environment SQL" statements for relational connections to be executed when a DB session is established. In Oracle, for example, you could set some NLS parameters that way for a particular DB session.
Is it possible to set the TIME FORMAT (which, BTW, is set to "ISO" for the affected Db2 instance) to some specific value using such an environment SQL?
For example, let's suppose I would send the following SQL script to a Db2 instance using a CLI client (the target table DEF under TLQ ABC has three columns of which the third is defined as a TIME attribute):
INSERT INTO abc.def VALUES( 1, 1, '08.37.50');
INSERT INTO abc.def VALUES( 1, 2, '14:58:23');
If I want to use a "standard" PowerCenter mapping, I would send the two records to a simple relational Db2 target and would insert the SET CURRENT_TIME_FORMAT='ISO' statement as the "Environment SQL" of the respective Db2 connection.
Is that possible? Does such a statement exist? If so, do you happen to know the correct syntax?
Our DBA is really trying to be helpful, but this is outside his area of expertise. Also he just knows that two software packets PowerCenter and PowerExchange are used here, but he doesn't know anything about these software products. :-)
Thanks and regards,
1 of 1 people found this helpful
If that works for other PC relational connectors, then I would expect it to work for PWX DB2 relational connector (not CDC).
However, I don't have an environment to check that at the moment.
I would suggest asking the customer to raise a case with Support.
Thanks a million, will do so.
Cheers and have a good day,