DSXchange

Sure, they all use the $ORACLE_HOME specified in the dsenv file when they need to connect, but the Bulk Loader is a little different animal. It creates a 'control' file to set Schema and Table names post-connect which is probably your issue here. Check the '.ctl' file the stage generates and make s...

It works the same way that it does in TOAD. Typically, you point it to an ORACLE_HOME and it uses the tnsnames.ora file there. Obviously, there can be more to it than that but that's normally how it works. The fact that you got a Table or View does not exist error shows you are connected to an inst...

It works the same way that it does in TOAD. Typically, you point it to an ORACLE_HOME and it uses the tnsnames.ora file there. Obviously, there can be more to it than that but that's normally how it works. The fact that you got a Table or View does not exist error shows you are connected to an inst...

You need to add ORACLE_HOME and the other variables to dsenv. Do a search this has been covered in great detail. You may need to start and stop DataStage. Thank you for your answer. I suppose to be able to set only one Oracle environment, so DataStage Server would have to reference the same Oracle'...

Hi everybody How does an OCI stage find an Oracle Instance? I have this problem. I'm checking a DataStage Server Job, release 7.5.2, loadind data from a flat file to an Oracle Table using a Bulk Stage. It doesn't work, obviously, and the error displayed in the log is: *** Output from command was: **...

Hi

can you describe me the layout of the table and can you tell me how do you update or insert the rows (update fields keys)?

Thank you

Umberto

All records in DS_JOBOBJECTS are controller or identified by the field OLETYPE. This field really identifies the Windows program which deals with that plugin. You do not really care about how it is implemented normally all you want to do is report on it. The Oracle plugins almost all have OCI in th...

How can I recognize an OCI stage in the DS_JOBOBJECTS table (or other one) of DataStage Repository?

Can I know the columns name and type used in referenced stages from the previous query?

Thank you in advance

Umberto

ArndW wrote:Very strange behaviour. If you output In.Colum[1,1] does it still add the two CHAR(000) places? ...

No, the jobs put the correct value in the output file in this case.

add a transform stage and add a column with the derivation of "LEN(In.OracleColumn)" and it should be 1 and not 3 ... I think that now you can read better. It loss tab characters. I'm sorry for that. Ok I tried to follow your suggestion. The result is one. The string is one byte long. Thi...

add a transform stage and add a column with the derivation of "LEN(In.OracleColumn)" and it should be 1 and not 3 ... Ok I tried to follow your suggestion. The result is one. The string is one byte long. Oracle Table OCI Trasformer Hash file Char(1) Char(1) Copy without any Char(1) type o...

ArndW wrote:add a transform stage and add a column with the derivation of "LEN(In.OracleColumn)" and it should be 1 and not 3 ...

Ok, I'll try and after I'll report you.

May someone explain to me why in the terminal hashed file I have, in this field, the value "Y.." (59 00 00 ine hex format) for all records. What 'terminal hashed file'? :? I sorry for that. I started with an example and after I talk about an other Job. There is no hashed file. Don't worry...

What is the column defined as in Oracle (not in the oracle stage, but in the describe of the database itself)? It looks like a CHAR(3) definition and it is padding with CHAR(000); in this case DS will ... No. It is defined as a char(1) not null. I suspected something similar and I verified immediat...

Hi everybody the problem I have today is about a trasformation. We are upgrading DataStage Server from the release 7.1 to 7.5.2. We are testing all Jobs. Two jobs of them have the same problem. They extract data from an Oracle8i table and write them onto a flat file. ORACLE-TABLE ------> SEQUENTIAL ...