DSXchange

In our case we are using DS to convert from Sybase to Oracle. The Sybase text fields and the Oracle column are both defined in DataStage as LongVarChar with a length of 2147483647. In the Oracle (9i) database it is defined as CLOB. ODBC is used both to read the Sybase table and to write the Oracle t...

You can't. At least not with 7.1.

You're only choice that I am aware of is to use an ODBC stage instead of the OCI stage.

Larry

I also have just experienced this problem with 7.1, server is AIX5.1. Guess I better check my memory situation although it's hard to believe that would be the problem.

Larry

Ray, I couldn't agree more. Here! Here!

Larry

I don't know why, but my AIX DS 7.1 system is acting differently. I have a job sequence which has two job acitivities, JobA and JobB. These jobs are independent (they each load a different table) and are not connected in any way in the sequence. JobA has two triggers one handling failure, the other ...

This seems to be normal behavior. Quoting from the Install Manual for Version 7.1: A copy of the uvodbc.config file is also placed in each DataStage project directory (for example, /ui/dsadm/Ascential/DataStage/Projects/Dstage1). This is useful where you configure a data source that is known to some...

Wouldn't it be simpler to define your reference hash file so that all columns are keys? Then the constraint could simply be lkupDBRecs.NotFound. This would select all input records which do not exactly match a record in the hash file. This is how we do it. Is there some drawback to this technique? L...

Tobbi, Don't know if any of this will help, but I have some rather unrelated thoughts and questions. 1. Does your reference lookup (Hash) file get updated during the process? If so, is it possible that what you are seeing in the Oracle table is the result of the second (or first) lookup and in the s...

We were given a fix for a similar problem, described in 375249*WES: When rescheduling a DataStage job in Director after changing the default value for an encrypted parameter, clicking on "Set all to default" does not properly set the parameter value to the new value. We changed our databas...

I typically multiply by 1. Is adding zero faster than multiplying by 1?

Larry

I just tried with CompileAll Plus as suggested. The message now is: "Component 'msflxgrd.ocx' or one of its dependencies not correctly registered: a file is missing or invalid" One thought I have is that maybe CompileAll needs to installed in the same drive/directory as is the DataStage cl...

Wolfgang, Thanks for your response, but when you say install the product as administrator, which product are you talking about? I have CompileAll on another PC and did not install it as administrator and it works fine there. Maybe mlistx.ocx belongs to a product (Visual C++?) that is missing? I don'...

I'm attempting to execute compileall. It complains that mlistx.ocx or one of its components is missing or invalid or not setup right. Unix server is AIX 5.1. Windows is Windows 2000 Professional. DataStage is 5.2.

Any help will be appreciated.

Larry

I had the same problem trying to FTP to a Mainframe. Quoting from Ascential Support:

"Unfortunatly at this time the telnet after and before command is only for
Unix systems. It does not work for NT or Mainframe systems. "

Maybe this is your problem?

Larry

Ray,

Don't you mean prior to version 5.2 for /.uvhome? I am using 5.2 and it makes use of /.dshome, not /.uvhome. According to the install manual 5.2 is where the change was made.

Larry