DSXchange

Hi All, In my job, source is a data set. These records are transformed in the transformer and then loaded into an Oracle table. When I run the job I get error as Caught ORCHESTRATE exception in main program: APT_ParseError In the meta data for the data set and in the output of the transformer, for s...

Hi All, In my job, source is a data set. These records are transformed in the transformer and then loaded into an Oracle table. When I run the job I get error as Caught ORCHESTRATE exception in main program: APT_ParseError In the meta data for the data set and in the output of the transformer, for s...

Hi All, I'm loading data from a data set into an Oracle table. After the job is run, I get error as main_program: Incorrect -dboptions option list; failed on Expected value for property "user". main_program: Creation of a step finished with status = FAILED. and the job is aborted. I've def...

We included NLS_LANG as User Defined Environment variable and included the same in our jobs I also face the same issue when I run a job which has any Oracle stage and the warning is main_program: An NLS character map <ISO8859-1> is specified, but no entry was found in $APT_ORCHHOME/etc/oracle_cs.tx...

Once you know your partitioning method you can reflect that in your DataStage jobs and finally, those options will not show up unless you specify "Load" method. I understand from your above statement that -These options will be available and can be mentioned in the Oracle Enterprise stage...

Thanks for the replies. I've some queries. 1) I believe that the table should be partitioned for enabling us to set the partitioning in the Oracle stage? How can I know whether it is partitioned or not? 2) Is there any way to set partitioning in the Oracle stage while extracting data? 3) I'm not abl...

Hi All, I'm extracting records from an Oracle table which has 142 million records using Oracle Enterprise stage. I do transformations for the columns and load it to a data set. Finally I'm loading from the data set into another Oracle table (This too has 130 million records) which is child of the fi...

Thanks for the reply. You are right;the input comes from a file and in the sequential file's column definition I've mentioned it as Varchar 20, 4 and in the immediate transformer I'm mapping it where the column is Decimal 20,4 which is the expected format for the target Oracle table. The data is 89 ...

Please have a look at the settings below. The settings in DS and Oracle are as follows. DataStage ********** In Job parameters section of the job: Default map for stages: Project default(ISO8859-1) Default collation locale for stages: Project(OFF) NLS Map tab of Oracle Enterprise Stage: Select categ...

The data type has been specified as Timestamp in the input data set and I need to write it to an Oracle table which has a column with Timestamp data type. e.g. The value in the data set is 2007-10-10. My understanding says Oracle expects the above date in the format 10-OCT-2007 and without convertin...

Please let me know how I can set NLS_LANG? Do I need to set in Oracle or DataStage.

Thanks,
Sumesh

Hi All,

I've a column with data type Timestamp. Please let me know how I can convert it into Oracle Date format (DD-MON-YYYY]

Thanks,
Sumesh

I executed the query and it shows UTF-8.
I tried to set UTF-8 in the DS Administrator and in the filter stage I set it as Project Default(OFF). Still I get the warning.

Thanks for the replies. Setting Clear for partitioning solves the fiorst problem. I checked the NLS section in the DS Administrator. It is set as ISO-8859-1. I tried to set it as OFF at the filter stage, but the job shows the same warning. Does setting NLS_LANG will resolve the issue? If so, what sh...

Hi All, I'm facing an issue in my job. The job extracts data from an Oracle table (using Oracle Enterprise Stage) and a data set, does an outer join on the records from these and filters the records into 2 output sequential files (Exception records for each source) and a data set (Matching records f...