DSXchange

Hi, You have two approaches you can use. 1. Use the supplied Reporting Assistant, can be found in DS Manager - under the tool menu. Or for a more comprehensive Metadata Management environment covering the Enterprise Data Integration requirements. 2. MetaStage. Cheers Stewart -----Original Message---...

Hi,

how we can extract the information about the Datastage jobs ? we would like to build a report of all Datastage jobs. So we are try to know, how to get the information of the sources / targets and the process of transformation.

best regards
Rui Soares

In the transformer that sends the link to the ODBC stage, simply delete the columns from the output link. Therefore, only those columns defined in the link go to the ODBC stage. The auto-generated SQL re-writes itself to be only those columns defined in the output link. -Ken --- "Pelletier, Christia...

Hi All Heres the situation: I have a ODBC stage with all the columns defined from a specific table. (lets say ID,FirstName,LastName,Number) I am using the "Update Existing Rows only" as the Update Action (drop-down list menu). I just know the information for the key column of the table and the colum...

Denzil, this is a long standing issue with the way ODBC and OCI stages handle dates. You need to forward your comments/complaints to Ascential. The short answer is this: Some OCI stages (InformixCLI, DB2, ORABULK) convert or need DATE datatype columns into/in an internal DS integer format. For examp...

We are using the same VMinf15.so driver for ODBC. But its not working for Informix CLI. Thank you Denzil. Leonid Denzil Sander on 07/25/2002 05:56:31 AM Please respond to To: datastage-users@oliver.com cc: Subject: RE: InfmxCLI Peter is right, you will need to install the informix connect. We use th...

Thanks Peter! "Peter H. Reich" on 07/25/2002 01:22:30 AM Please respond to To: cc: Subject: RE: InfmxCLI Hi Leonid If you will use the CLI-Stages you have to install the Informix-Client on your DataStage Server. The native stages (OCI, CLI etc.) allway use the client functionality. regards Peter ---...

I had a similar problem when I tried to do what youre doing and its because the before section is executed in its own session. Ascential Tech support suggested executing the set transaction in the user-defined sql section followed by the a copy and paste of the generate sql. However, this may still ...

Hi all, does anyone know if is possible to load record to ORACLE (with OCI8 3.0) using a specified rollback segment? I have 10 rollback segment and Id like to use only one of them. I tried to execute the following command in the before section of the OCI8 stage: SET TRANSACTION USE ROLLBACK SEGMENT ...

Peter is right, you will need to install the informix connect. We use the vminf##.so shared object in the branded_odbc/lib/ directory. I found this in the manual, hope it helps: Releases before DataStage 5.2 for Solaris and AIX platforms using the Merant 3.6 ODBC drivers: The driver field in the dat...

Hi all We have a few developers here who came upon an interesting scenario - hope you can help. Datastage 5.2r1 Server: Solaris 8 Source database: Informix Destination database: Redbrick Problem definition: Why do we get the error in scenario 2, when the date looks like a date. Scenario 1: Using a C...

Can you be more specific about what you mean by "hosing"? What symptoms occur? Is there any predictability to the "occasions" on which this occurs? The FTP stage does work differently from those stage types that use SQL, but so do a lot of other stage types. Mardi cc: Subject: Datastage FTP Problem ...

I need to get some information from a file in a routine for subsequent processing. As the routine could be called simultaneously from several jobs (executed in parallel) I wonder if its better to put my data in a hash or a sequential file - is there any locks put on the file after Readseq or read (f...

Hi Leonid If you will use the CLI-Stages you have to install the Informix-Client on your DataStage Server. The native stages (OCI, CLI etc.) allway use the client functionality. regards Peter -----Original Message----- From: lfrumke@sears.com [mailto:lfrumke@sears.com] Sent: Wed 24.07.2002 17:23 To:...

Martin

I have tried twice to respond to your e-mail at datawarehouse.com. However it is rejecting it as you have exceeded your mail box limit.

Please advise.

Regards

Adam