DSXchange

James, if this is flat files youre going to read you could test the existing of the files or the number of rows (e.g. if theres more then 0 rows) by simply coding openseq/readseq/closeseq statmentes in your job control. This is much quicker then running a whole DS-Job with 0 records processing. Depe...

Thanks Don, Can I ask what is the version of the Ingres ODBC driver you are using? We are having some difficulties and I believe it to be the driver. Damien Kavney Technical Consultant Dialog Pty Ltd Contact Details (DNR) MIS Application Support Group (07) 3896 3989 Damien.Kavney@dnr.qld.gov.au ----...

Damien, We are only just testing DS 5.1 (with Solaris against Ingres II at the moment. We have been using DS 4.1 (with Solaris 7) for some time with only the occasional hiccup. We only use ODBC stages to access the data. The testing we have done so far has shown no problems but it has been limited t...

Is there anyone out there who also uses Datastage against Ingres II? If so are you encountering any problems with DS 5 and above? Thanks, Damien Kavney Technical Consultant Dialog Pty Ltd Contact Details (DNR) MIS Application Support Group (07) 3896 3989 Damien.Kavney@dnr.qld.gov.au ****************...

MONTHLY POSTING - DataStage Users List As of 1 May 2002 the DataStage Users discussion list had 596 subscriber addresses. A few of the addresses are to organizations who then redistribute the postings to more than one reader. ================== Posting Guidelines ================== 1) Non-moderated ...

No, in each individual job when extracting data from source base(Sybase) if o row was extracted from source table then bypass the loading process into target database(NCR Teradata). -----Original Message----- From: Craig_Hulett@rsausa.com [mailto:Craig_Hulett@rsausa.com] Sent: Wednesday, May 01, 200...

If the job runs, and extracts 0 rows, it will not output any rows to be loaded. The place to detect this is in an after-stage subroutine, where you can interrogate the number of rows loaded and elect to stop the job. If you absolutely want to do it in job control, you need two controlled jobs (one t...

If you mean - can you check the results from one job and, if that job processed zero rows, skip certain following jobs - the answer is definately yes. Check out the "DSGetLinkInfo" function and use the DSJ.LINKROWCOUNT info type. -craig James Lin cc: 05/01/02 Subject: RE: Batch job control 03:03 PM ...

I dont know. Here is what Im trying to accomplish. Im extracting data from source which uses Sybase base stage but when 0 row was extracting from Sybase then I dont even want to perform loading data to target. Is it doable? -----Original Message----- From: David Barham [mailto:david@barham.hm] Sent:...

Im wondering how you are going to know the job is processing 0 rows before running the job? -----Original Message----- From: James Lin [mailto:JCLin@vartec.net] Sent: Thursday, 2 May 2002 6:43 AM To: datastage-users@oliver.com Subject: Batch job control Hi, Ive set up a few batch jobs each contains ...

Hi,

Ive set up a few batch jobs each contains more than 300 individual job to run. In order to save as much time as we can, I wonder if there is a way to skip those jobs with 0 row in it. Is it something I can do in job control? Please advice, thanks!

James

Hi everyone,

Does anybody know if its possible to use ODBC stage to connect to DB2 7.2 CRM in DS version 4.0? Where I can find the drivers?

Thank you,
Leonid

Ive used it. You have to go into the Access database, figure out the data model and create your own custom reports. If not, your stuck with 200 page reports that are NOT helpful at all. The DSProperties table has all the derivation code. Tim The database is located in c:Program FilesArdentDocumentat...

Ahh... F11. I couldnt for the life of me remember which key did that. Its been so long Im surprised I even remembered that there was a key to get into design/edit mode, or whatever it is called. Thanks, Ray. -craig "Raymond Wurlod" To: Subject: Re: Documentation Tool 04/30/02 03:45 PM Please respond...

The Reporting Assistant runs a start-up macro in Access. You can break into Access (F11, or hold the Shift key when double-clicking on the mdb file), and create your own queries and reports there. Ray Wurlod Trainer, Asia-Pacific Region IBM Informix Education Department Level 22, 60 City Road Southb...