DSXchange

>>> Ray Wurlod writes: What follows is best viewed using a non-proportional font... * DataStage BASIC does not have a ForEach construct, so we fake it, * for example with a dynamic array of job names. * David Barham writes The next level of complexity is to be able to control more than one job at th...

First guess is that youre running into a limit on the length of a row (in characters) in a result set. By default this limit is 8192. Are some of your VarChar fields very long, or contain many multi-values? You can set a larger limit in the uvodbc.config file in the project directory. For example: M...

The next level of complexity is to be able to control more than one job at the same time, that is, run jobs in parallel. Firstly, you do not wait for a job to finish - you have other jobs to manage as well. We keep an array of all the jobs to be run and what the current status of each job is. This a...

> ---------- > From: Scott Brooks[SMTP:SBROOKS@psu.edu] > Sent: Thursday, 31 August 2000 03:42 > To: ray.wurlod@informix.com > Subject: Re: RE: Number of Items in Job > > Hi Ray, > > I saw your note to the DataStage Listserv list. Would you have some > sample code that I could leverage for the "...

Need more information! release level? operating system? ************************************************************* Rick Schirm Application Performart Ltd. Vice President of Engineering mailto:rick.schirm@performart.com web: www.performart.com phone: 817.291.6177 **********************************...

DSBrowser1.DSLink1: DSD.BCIGetNext call to SQLFetch failed. SQL statement:SELECT TG_TERRITORY.ADDR1, TG_TERRITORY.ADDR2, TG_TERRITORY.TERRITORY, TG_TERRITORY.NAME, TG_TERRITORY.ADDRESS, TG_TERRITORY.CITY, TG_TERRITORY.STATE, TG_TERRITORY.ZIP_CODE, TG_TERRITORY.PHONE_NO, TG_TERRITORY.SPARE, TG_TERRIT...

This is a topic for an orphaned message.

There is a MAJOR performance benefit to be had when UniVerse and Oracle are on the same hardware, and that is to use what Oracle calls "bequeath" drivers. These use named pipes as the conduit to TNS listeners. Contact your Oracle support folk for more info, and push the issue if they plead...

There is a limit of (IIRC) 128 links per stage instance, and a limit of (IIRC again) 8192 links in a job. This wont affect the numbers youre talking about. You can use one job (presumable with parallel paths) or multiple jobs (possibly run by a controlling job). Its your call. My personal preference...

I have about 25 files that I need to move from universe to SQL Server 7.0. Is there any limit that I should be aware of as far as how many I can do in one job. Should I break this into multiple jobs or just one big one?

Thanks,
Mike Roosa
Getronics

Youve got my attention too, as I was under the impression that fix to the job hanging problem was a patch to 4.01 or part of the soon to be released 4.02. It is possible we are talking about different problems. The patch I am referring to fixes a couple of problems to do with naming the files in &am...

Sorry to get your hopes up, its 3.6.3r2. > ---------- > From: Vincent, Brad[SMTP:BVincent@dmc.org] > Reply To: informix-datastage@oliver.com > Sent: Saturday, 26 August 2000 00:25 > To: DataStage Mailing List > Subject: Jobs Lock Patch > > Hi Ray, > > Youve gotten my curiousity up. In reference to &...

I need to subscribe the Sybase DBA mail list, anyone also on that list and know the email adress? Thanks in advance ThomasCook LTD IT Sydney ********************************************************************** NOTICE: This message contains information intended only for the use of addressee named a...

Hi Ray, Youve gotten my curiousity up. In reference to "jobs hanging", you and others have mentioned a patch that can be applied to DS 3.6+ to fix it. I notice in your email to Avinash that its available for release 3.6.3r2 and above. Did you mean to say 3.6.2r2? Not 3.6.3r2? The reason Im...

Hi Ray, This problem is different from hanging, which is not yat resolved. Once the job locks , means it becomes dead, not usable. Thanks & Regards Avinash Tadwalkar GTS/APHOIT - DataWarehouse/CA$H/IDMS Ph : (65) 423-8206 ---------------------------------------- Message History -----------------...