DSXchange

Have you imported the table definitions for these tables? If so, how are these column names represented in the table definition? The short answer is that, whatever this is, that's the name that you ... Hi Ray, I have imported the table definitions and they appear simply as Schemaname.Tablename. I c...

Ray, Thanks for the quick response. I was able to connect to the database using both DRS and ODBC stages. Just that I am unable to use the member name in my query to extract data from the table. I am still trying to figure this out. Does the DB2/API stage give me any advantage over these stages when...

Hi All, The IBM support got back saying that there was an IDMS connector for the Classis Federation for oz/390 which could be used with DataStage to connect to IDMS. On browsing through the net, it seemed that this connector supports only versions 14.1 and 15.0, while the IDMS system at our end is 1...

Hi All, I have to pull data out of a DB2 database residing on AS/400. We have defined 3 members for most of the tables in the same schema, so as to point out to 3 different vendors. Can I use the ODBC or DRS stages to extract the data from a table for each of these vendors? If so what would be the s...

Hi Ray, We don't have the license for the MVS edition, but only the Enterprise Edition (PX). I am trying to find out how I can use PX to connect to an IDMS. The IBM folks said that you can connect using an IDMS connector, but I wanted to know if there was a limitation on the IDMS version that this c...

Hi All, Has anyone connected to an IDMS through DataStage? Can you share the details of how this was done, as to - 1) what connector used 2) the version of the connector It would also be good if someone can tell me upto what versions of IDMS does the connectors support. The requirement is to connect...

I have set all the library paths but now I am trying to view the data from a server job, I am getting the following error. Any guess how can I resolve this issue? TestDB2Connectivity..DB2_UDB_API_0: SQLAllocHandle: Failed to allocate environment handle 'ENV'. TestDB2Connectivity..DB2_UDB_API_0.DSLin...

Which library I need to reference Actully Datastage server and DB2 server are separate boxes. In my datastage server I have db2 connect installed. I can see the libraries in both the servers Do you mean to say I should specify the library paths of the DB2 database server or I should specify the Libr...

Hi, Check with environment variable settings to the dsenv script in the DataStage Engine directory. This is from pervious post: DB2DIR=/usr/opt/db2_08_01; export DB2DIR DB2INSTANCE=db2epm1; export DB2INSTANCE INSTHOME=/db2/home/db2epm1; export INSTHOME #export DB2PATH=/usr/opt/db2_08_01 LIBPATH=$DB...

I need to connect Datastage with DB2 UDB 8.2 through DB2 wire protocol 5.0. I set the dsn in odbc.ini and I added the entry in the uvodbc.config file in the Project directory and tested connection through Datastage manager, I am able to connect and select the tables view data everything possible. Bu...

Hi Daniel, You should be able to do this by pivoting your input (TYPE and level_type). By this you would get your input as - TYPE,level_type C,1 AC,2 As you need the output as - <Product_class> _<name>C</name> _<level_type>1</level_type> </Product_class> <Product_class> _<name>AC</name> _<level_type...

Check your partitioning. The join stage needs data to be pre-sorted and hash partitioned on the Keys.

Bird.

Hi Vincent, Looks like you are right! I tested out a job as you had mentioned and the entire set of input records got rejected. If I had DataStage running I would run a quick test to see. I am assuming that transforms are run first followed by constraints. You could test it by creating a transformer...

Hi Brad, The only question left is more of a curiosity question of why can't I use 2 variables? I was wondering if this could be an intermittent issue. I am using to 2 parameters like - #TempFilePath#/#SourceFilePattern# - in my job and it seems to be working fine, except when there are no files tha...

Hi Brad, I have seen this error before while using the APT_IMPORT_PATTERN_USES_FILESET. In my case, this error was thrown out when ever there were no files that matched the file pattern value provided. The job was a simple - Seq File -------->Copy-------------->Dataset But whenever, there came a sit...