DSXchange

Hi,
I'd like to know more details regarding the configuration Vincent.
Can you please post them (OS of DS and DB2 and versions)?

Thanks,

Hi All, What should be the format of the schema file if one uses Column Method=Schema File. What should this schema file contain? I have to generate sequence number from a given number for each record. currently i am using combination o f lookup, transformer nd row generator for this. as the sequnc...

Hi, I wonder what a date looks like when yo have a 2 digit hours? Is it still having the .0 in the fraction or not? Things like that might be also configured on the DB server or ODBC configuration side rather then DS. For finding work-arounds for Data Direct odbc drivers explore the branded_odbc dir...

Hi, In general there are no logical limitations what so ever. since you can build and incorporate missing functionality potentially there are no connectivity limits (what you lack today can be provided tomorrow) where processing is concerned you have (AFAIK) a liniar growth comitment in processing v...

Hi, Last time I checked it was Oracel. recently I heard some one got it for another DB (was it TD?? ). I guess you can ask your support provider, or try finding it out over at the ascential site. The docs do imply it is intended to be available for more DB versions along time. p.s. there are usually...

Hi, On top of what was already said and keeping in mind a lookup is performed using a transformer stage ... do you have complex derivations/stage variables? are you using any routines in the transformer (before/after stage as well)? the above also effects your performance since it depends on the slo...

Hi, try to first figure out what causes the abnormal termination. I'd start with removing the after job routine. then the routines generating the dates and compare the generated date with the data type you use and the column's data type in the actual table. If none of the above works try rebuilding ...

Well, After failing I asked to try it on the prod system (V5R2 till this week end) to make a support call... (using the data direct drivers) I was amazed to see it working . 7.5.1a release notes mention a bind20 that needs to be done (never successfully did it) So tried again on the V5R3 using again...

Hi, What are the warnings you get ??? while your answering that also think of the following points: 1. are you using any used defined routines in the job? (also check the transformer properties for before/after routines) 2. check beofre/after sql if any exists. 3. go over the &PH& directory ...

Forgot to mention as400 is V5R3.
I know docs and branded_odbc states V5R2 latest supported.
I'll try to find out if I can find a newer version or use the iSeries client access driver.

Hi,
The stage you need is PxSurrogateKeyGenerator not column generator, column generator is a dev/debug tool.

schema file is a substitute for the table definition in the stage itself.

IHTH,

Hi yall, I'm trying to get a data direct odbc working with as400/db2. when trying to bind20 the odbc name I get 1213 error (same when running the odbcdemo supplied by data direct) Does anyone have any idea as to requirements for establishing a working connection in the mentioned configuration? both ...

Hi, Usually being unable to use a plugin means it is not installed on the server side, hence not usable in your job design. Go over the plugins manual to find out how to install plugins after DS is already installed. p.s. you can go over your install log (if still existing) to verify which plugins w...

Hi,
Phantom is the name asociated with DS job processes.
So your simply getting an error in your job's process.

you might want to expand regarding any particular issue your experiancing for more specific answers.

IHTH,

Hi,
that is mentioned in the docs regarding routines not jobs