DSXchange

Hi, Has this been resolved? If yes, please share the resolution. In my case I am observing this issue while invoking a parallel shared container - which loads data using the DRS stage. This shared container is used by other jobs as well and they are working fine. Any suggestion would be helpful. Tha...

Hi, Reading with varchar will work, but as i've mentioned i am reading it using schema file and RCP, the same job loads data back to Teradata table. If i convert timestamp[microseconds] to varchar loading to table will fail. why not read it as varchar and then convert it to timestamp within the job?

We just got a comment from production Oracle DBA, saying no delete query fired at all from DataStage to oracle during the run. But this job is failing with this error as we got from the production support team after running for some half an hour or so. Could there be a problem when DataStage tries t...

I don't have access to production environment. But production DS admin is saying no difference.

Can volume be a problem? We are trying to delete around 15-20 millions of record using oracle delete statement.

ray.wurlod wrote:What's different in the production environment? ...

Hi All Is there a DataStage UNIX utility which can list out all the dependent jobs run by a DataStage sequencer job? Actually we are creating a logging and reporting UNIX script and we are struggling to find out a DataStage utility (UNIX command) which can list out all the jobs run by a DataStage se...

Hi I got a problem with DB2 NLS mapping, I am little new to DB2, I am accessing DB2 using ODBC stage. This is just select few columns from mainframe DB2. The problem is I am able to read data from all other columns but not one <XYZ>. This column <XYZ> contains some strange characters, when run this ...

I am now able to connect to the DB2 through ODBC connectivity. Few things we added are the location information and Database information. One more thing, this need a permission from mainframe DB2 side for external query access, this is done by DB2 administrator. Thanks all for your replies. Vir I ca...

Hi All, I got a problem, actually this is the first time I am working with DB2 database with DataStage. I am using Ascential PX 7.5. We need to read some set of data from DB2 database using ODBC stage (we have only DB2 driver installed in Data Stage UNIX server and no DB2 client) I've put following ...

What are the column data types when you import the table definition into DataStage? DataStage does not support a data type called "byteint". ... Hi, Thanks for reply, for some reason I am not able to import the exact table definition, but I tried importing different table with one column ...

Hello, I am loading flat file data to Netezza database table. I am using IBM DataStage 8.0.1, and trying to load through Netezza plug-in stage. The error I am getting is as follows: main_program: Fatal Error: Type mismatch for field 'id'. Fatal error. One of the key fields in the table is defined as...

Netezza stage is available in IBM DataStage 8.0.1, in other lower version probably you would need to install a plug-in for it.