DSXchange

If you have installed the server, why would you need the client? The director, developer and administrator should be there after the install.

The error is occuring on the read(oraread). I an using the Oracle enterprise stage for the source.

I am using the modify stage to change a column name that has '-' (Specification = CAUSE_EN = Cause-en). When I run the job, I get the following error: main_program: Syntax error: Error in "oraread" operator: Error in output redirection: Error in output parameters: Error in modify adapter: ...

It seems that the problem is only with character data. The target field definition is larger than the source.
On the table definition for the target, the final delimeter is set to none, record delimeter string is set to DOS format, record length is fixed.

If you do not have Parallel Extender (EE) you can always create a 64bit hash file.

Ray,
I used the oracle plug in metadata definitions for the source and target tables.
What is the Orchestrate orchdbutil facility

I am using the Oracle Enterprise source with copy stage to copy Oracle data to a staging area. On the character data, I am getting the following error when looking at the log file: Record xxxx: Rejected - Error on table xxxxxx, column xxxxxx. ORA-01401: inserted value too large for column. Director ...

I am working with version 8 and have the following problem with Oracle column names. My source has column names with '$'(CLAIMED$), #(phone#). When importing the definitions, the # gets changed to _036_, the # _035_. Can I fix this rednaming the colums using the modify stage. If so, would I use the ...

I am trying to trim all trailing characters after a '(' eg. abcdef (xxxx) would become abcdef
The trim function will not work because the trailing or leading function will only remove the '('.

What would be the best way to do this?

Thanks

When running a parellel job, I am getting the following warning message:
Failed to initialize job monitoring. Monitor information will not be generated. [osh.C:754].

I have set APT_NO_JOBMON to false.

What would cause this error and how do I fix the problem.

Thanks

I have a data source that is an unload of a db2 table. I am using the FTP stage to bring the data over to the server and CFF stage to convert the data from ebcdic to ascii. I have imported the COBOL portion of the dclgen to use as my layout for the conversion.. I have several fields on my source tha...