DSXchange

I would like to allow a DB2 UDB API stage to create out target table but I don't see any way to tell the stage that I need the indexes created in an index space separate from the table. I did notice there is a User-defined DDL option and I was able to add an INDEX IN line successfully. It still crea...

To have the default repeat in a project I at first made the change in a table definition and clicked on "make default" for all new table definitions. After which I found that in the Admin tool you can set the default format for the timestamp in the parallel tab. It asks you to uncheck &quo...

Are you setting microseconds on table definition of source and target? Also, you say you are looking for (YYYY-DD-MM HH:MI:SS.SSSSSS) I was able to get timestamp with milliseconds by having it converted to %yyyy-%mm-%dd %hh:%nn:%ss.6 in the format.

ray.wurlod wrote:Try %ss.6 in the seconds position. ...

Fantastic! That worked. Thanks so much. I plan to set this as default in the table definitions defaults. Sorry I posted to wrong section.

Has this been fixed in DS 7.5.2 ?[/b] I don't get the microseconds with the options mentioned in the manual %yyyy-%mm-%dd %hh:%nn:%ss.x where x is a no between 0 and 6 for the microseconds. I have the Job Parameter override for Timestamp to be %yyyy-%mm-%dd %hh:%nn:%ss.6 Compile goes thru, but the ...

Pulled the timestamp from a DB2 API stage and chose microseconds from the pull down in the extended options in order to get the milliseconds (2006-01-21-02.03.09.111111). I was wondering since it's a DB2 stage and it should always have milliseconds is there a way to at a project level or even server...