DSXchange

Hi Arnd,

As told by you, i tested the job by repalcing Oracle stage with PEEK stage.
Now, the warning is not coming.

Regards,
ssunda

Hi, Please see if the following additional info will help to find a solution. I checked the statistics on oracle table and the statistics are: Avg Record length is 70. And column wise also it listed avg column length. The summation value of all the columns length is 77. But none of these values are ...

Hi, I am using "LOAD" option for write method in oracle stage.( So, this will use SQL Loader ). Total there are 24 columns in the Input file and 16 columns in the target table. Total length is neither 272 nor 273. The following is the metadata of table. BUS_DT NOT NULL DATE STORE_NUM NOT N...

Hi Arnd,

I have copy pasted the error as it is. Yes, it is referring to the oracle stage for the error in the director log .

In the transformer, I am converting some decimal fields to date type( decimal->string->date) and some decimal fields to varchar. Just FYI.

Hi,

I have checked the table definition. No field is having length of 273.
The file that I am reading is in EBCDIC format.

Regards,
ssunda.

Hi, I am getting the following warning in datastage director log: oraInsertData: When checking operator: Formatted length of fields and record (272) less than declared length (273) oraInsertData: is the name of oracle stage in the job. In my job, I am reading data using a sequential file, performing...

Hi Ray,

The table is partitioned and yes, there is SELECT privilege to the ID that I am using

Regards,
ssunda.

Hi All, I am using LOAD option in oracle stage. To further improve performance, heard we can use oracle environment variable: $APT_ORA_IGNORE_CONFIG_FILE_PARALLELISM When we set its value TRUE, it should automatically partition datastage data to match oracle partitions. But when I use the above vari...

Hi, Providing OPTIONS(DIRECT=FALSE, PARALLEL=TRUE) value to $APT_ORACLE_LOAD_OPTIONS, the job is working fine without throwing any errors about index. (I have removed index option in the oracle stage) Does the options DIRECT and PARALLEL does anything about index also. Is index rebuilt after loading...

...

...

ok. Thanx a lot.

Regards,
ssunda.

Hi,

Ans = Field(Output,@FM,Count(Output,@FM),1) is returning the required value of output.

Count(Output,@FM)+1 is giving an empty line. I think a new line is there in the output of the script.

Thanks for the replies.

Hi ,

After moving this to parallel forum, i dint check the reply you posted to that thread.

Ray,
yes, tail -1 option is better. Thanx

Thank you,
ssunda.

Hi, My issue is resolved. While using the DSExecute function, I was earlier using Call DSExecute("UNIX","sh ScriptName",Output,SystemReturnCode) Ans=Output<1> Now I tried getting the required output by using awk. Solution: Call DSExecute("UNIX","sh ScriptName 2>&am...