DSXchange

OK I saw that information in the documentation. I guess what I am trying to do is to create a library of functions that I could use in multiple jobs. So there would be no questions about what to do in certain cases. For example always convert char(0) to empty string. I guess there is no way to do so...

Thanks for the reply Ray.
Where can I find information on this?

Is it in the documentation?

Thanks,

Sean

Hi there, I want to create a parallel shared container that will convert any invalid characters that are in the data to spaces or empty strings. So, in my container job I have a tranformer to convert the fields passing through using the convert function. If I have runtime column propegation on, how ...

I am loading data into an Oracle database. When I get to the end of the load I get an error as such... Ciramst_to_Oracle,0: GenericQuery:esqlErrorHandler Prepare failed for: GenericStmt_7 query is: SELECT banner FROM V$VERSION sqlcode is: -3135 esql complaint: ORA-03135: connection lost contact I am...

The first thing to get is the sqlloader log file from the scratch disk area. This should have more information in it if it pertains to something that happened during the load. Post that information here.

Sean

I am not 100% sure why it does this. I have seen it with the infamous 139 error message. The only thing I can think is that DataStage sees that the job finished successfully then hits the timeout and since it is not a DataStage error, but an Oracle error it reports that something happened and finish...

It sounds like your Oracle connection is timing out. We were having some issues with this as well on long running jobs. We finally turned time outs off. You will have to work with your DBA on this. In short we added the following entry on our client(DS server) and Server (Oracle Server) in the sqlne...

I have been running PX on Windows 2003. I am not happy with it though. I have run into many issues which I think will go away when we switch to our Linux servers. I will not go into detail here because I have posted some of the issues here.

You can try something like this in the derivation field of a transformer. This works for me. convert(char(0):char(1):char(2):char(3):char(4):char(5):char(6):char(7):char(8):char(9):char(10):char(11):char(12):char(13):char(14):char(15):char(16):char(17):char(18):char(19):char(20):char(21):char(22):ch...

It means it is stored on disk, instead of memory.

HTH.

Also be aware if you are running Oracle on RAC this is how a sequence will not be sequential.

If order matters...

create the sequence with nocache order options. Note however there is a performance penalty for this.

HTH

You could also use column aliases to rename the column utilizing custom sql. In an Oracle DB you would do it as such select col1 as column1....

HTH

OK testing this way did not work because of the parallel nature of the job. So I get both records with a record indicator of "N".

I will investigate the other ways which were suggested.

Thanks

Here's How I did it. I have 3 output links from a transformer. One catches the new inserts (change code 1). The other 2 output links catch the edit (change code 3). On the one output link I update the old record with the values from the transformer to set the end_date and the current record indicato...

I have a job that uses the change capture stage. I know that if I have a change_code 1 I can insert. If I have a change_code 3 I have an edit and I need to update. Instead of updating I want to insert a new record and update the old one with an end date. How would I go about doing this using the Ora...