DSXchange

Just wondering whether u can have this condition in your SQL itself during selection of records in the Ingress DBStage. U can have something like "where empno >=567000 and empno

If there is a log file created, you can search the log file for a succesful status and then only carry on with the next job. In our environment we search for "ERROR" in the log file, which means the command didnt complete, and the batchjob stops. -----Original Message----- From: Rachel Pedreschi [ma...

Hi All, I have a table called emp in the ingress data base which contains the following values EMP empno ename 567123 kris 567444 ravi 567888 scott 123456 thomas We want the details of employees where empno starts with 567. Do we have any function in DataStage5.2 for solving the above Problem? Any h...

Hi Ray, Thanks for ur imm. response. It is just that I forgot to CC dsuserslist. 1. Job 3 is aborted as part of validation, hence this is OK. 2. When Job 3 aborts part of validation, Job 2 crashes(Status = Running, Return Code= 96 - CRASHED). 3. When job 3 aborts due to other reasons, Job 2 aborts (...

This is a topic for an orphaned message.

Carlos, I am on vacation in November, and definitely do not have a mainframe with me! So I am posting this reply to the list in the hope that someone else can help you faster than I would be able to. I am not in a position to send you other peoples email addresses; this is actually illegal in Austra...

I am in the process of upgrading from DS 4.2.1r8 to DS 6.0 on AIX. I have had a number of difficulties with the upgrade process. After consultation with Ascential, I have decided to upgrade by exporting all the DS jobs, removing my 4.2.1 DS Engine, completing a "fresh" install of DS 6.0, and then im...

Try Day Month Year or Month Day Year format (any delimiter) where the month is alpha. E.g.: ValidDate = 28 NOV 2002 ValidDate = 28/nov/02 ValidDate = nov 28 2002 Etc. Hope this helps. John Campbell Ascential Software -----Original Message----- From: Riccardo Tani [mailto:riccardo.tani@datamat.it] Se...

It really depends on whats in the Word document (whether an ODBC driver for JET can cope with it), but the safest answer is probably no. Effectively anything in it needs to be in a table. There is no Metabroker for MS Office. You can, of course, save as a text file, which both DataStage and MetaStag...

This is a topic for an orphaned message.

First, a couple of points. 1. I am currently on vacation so do not have access to all my usual resources. 2. Please direct questions through the list. Education and consultancy services are how I make my living; I am happy to provide individual advice but only in exchange for payment! 3. A meaningfu...

We have metadata file in MS Word format and data file in variable length flat file format. How should we approach it? Can MetaStage or DataStage handle word file?

Thanks...Kamal

For version 5.1.1 it was 31438. May be it is same for version 5.2. -----Original Message----- From: Rui Soares [mailto:rui.soares@novabase.pt] Sent: Friday, November 08, 2002 12:30 PM To: datastage-users@oliver.com Subject: RE: DataStage port And in version 5.2 ? Rui -----Original Message----- From:...

Hello, I am trying to create a batch job that uses a mix of DataStage jobs, SQL Server Stored Procedures, and some plain ol SQL. Is there anyway I could run the SP and SQL from the DataStage job in an After Stage routine? Or is there some way to have datastage return a value after the job is FINISHE...

And in version 5.2 ? Rui -----Original Message----- From: Patel, Dharmendra [mailto:dharmendra.patel@experian.com] Sent: sexta-feira, 8 de Novembro de 2002 20:25 To: datastage-users@oliver.com Subject: RE: DataStage port RPC Port for DataStage 6.0 on UNIX is 31538 -----Original Message----- From: Ru...