DSXchange

Thanks Ray, much appreciated. -----Original Message----- From: Ray Wurlod [mailto:rayw@mindless.com] Sent: Friday, March 14, 2003 6:15 AM To: datastage-users@oliver.com Subject: RE: redbrick ODBC No, its not really a bug with Red Brick ODBC. Remember that one of the things that makes Red Brick go fa...

unsubscribe

This is a topic for an orphaned message.

Hi All, Problem found. It had nothing to do with datastage. Problem found with our login process - specifically our "jumpstart" server was not responding at all as it was not configured to LDAP. Effectively all our connections were being slowed down irrespective of where they came from. I think that...

Hi Fabrizio, if Ive understood what you need, I think that the best way (quickly) to update a field description is by editing your table definition via Datastage Manager. But you can also import ErWin metadata directly from Datastage by installing ErWin35 LinkObjects API. In that way youd be able to...

Just my 2 cents worth. Use ODBC only if you have to extract simple table scans worth of data from Redbrick. In the case of loading, ALWAYS use TMU. This is one slick database, with the fastest loading and most multi-functional bulkloader. Dont even go down the road of ODBC for loading. I beat my hea...

No, its not really a bug with Red Brick ODBC. Remember that one of the things that makes Red Brick go fast for queries is that it is NOT a transactional database, nor a relational database. It implements the star schema directly and has a lot of smarts for getting queries to be slick. Because Red Br...

We manage this by setting up a structure where: Each load job has a load_key parameter set by the calling job that is unique. The load is run and load_key written with the data to the target table. The control job then checks the number of records that went down the link, and compared this to the nu...

Hi people! i have one question: Someone kown the faster way to update the description column of the attributes of a COBOL FD set I have one folder on TABLE DEFINITION with loaded table description from ERWIN 3.5 (loaded via metabroker) I want update the atrribute on FD (COBOL) updating only the desc...

Thanks Chris, I will check the setting. If however, you say it is not good practice to set this, then how does one know if the rows are acceptable to the database or not. I want to avoid having to check the database. I would like to determine this from DataStage. -----Original Message----- From: Chr...

Hi Ray Thats my delima, usually other databases like Oracle, Sql Server etc generate these messages which DataStage can test for. Redbrick did not. Therefore, as far as me the user is concerned, the rows that went down the link were accepted by the database. Are you saying that if I define a reject ...

Setting "DISABLE_INFO=YES" in the rbodbc32.ini will cause Redbrick warnings, etc. to be disabled. Perhaps you have this set. Having said that, its usually a good idea to have this set as Redbrick can return warnings that cause your DataStage job to abort even when they shouldnt. Chris. www.altis.com...

m -craig udo.neumann@eds.com wrote: > Hi Ken, > > could you please send the complete link for your tools, because I > doesnt find it on www.datastagexchange.com. > > Regards, > Udo > > > > > Kenneth Bland > 12.03.03 21:03 > Bitte antworten an datastage-users > > > An: datastage-users@oliver.com > Ko...

When you use ODBC stage, what DataStage is reporting is the number of rows sent out the link. It is not necessarily the same thing as the number of rows accepted by the database (or ODBC driver). Rows that are rejected do generate warning messages, and can be captured in the preceding Transformer st...

Sounds like it could be. Perhaps you should log it with tech support? Maybe they have information we could use. -----Original Message----- From: Mark Ewart-Phipps [mailto:mark@centerfieldsoftware.co.za] Sent: 13 March 2003 11:46 To: datastage-users@oliver.com Subject: RE: redbrick ODBC Hi Denzil I r...