Search found 3 matches

by pclarebu
Thu Aug 21, 2008 11:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MYSQL - ODBC -windows xp under VMware - will only load 1 row
Replies: 2
Views: 1445

Thanks Ray. What happens is if I use "Write" mode it will only load the first row. The rest just disappear into the ether? There are no errors in the log - from a datastage perspective all rows are sent in. From a mysql perspective there is only one sent in. I don't know mysql well enough ...
by pclarebu
Thu Aug 21, 2008 2:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MYSQL - ODBC -windows xp under VMware - will only load 1 row
Replies: 2
Views: 1445

MYSQL - ODBC -windows xp under VMware - will only load 1 row

Hi, getting a little frustrated. I am using the mysql odbc 5.1 driver and the 3.1 driver for that matter and I am just doing a simple test job loading in 10 rows with a couple of fields and it will only load 1 row. The datastage job runs fine - no errors - monitor shows 10 rows passing through all s...
by pclarebu
Sun Jan 07, 2007 7:00 pm
Forum: General
Topic: Automatic Job Generator - does one exist??
Replies: 39
Views: 22998

Hi on my current project we are playing with using the propogate facility. It is at an initial stage but using this we can generate from a file of metadata OSH schema files. Then we create one datastage job that specifies the Osh Schema file as a parameter as well as all the other parameters fro dat...