DSXchange

Hi,

Thanks for reply.I could not get the solution.

Thanks & Regards,
-- sudhakar

Hi,

I am getting the following problem frequently.

TNS:could not resolve service name

some times jobs are running finely.Some times it is throwing above error.
Each time i am processing the same data.Can anybody suggest me the solution.

Thanks & Regards,
-- sudhakar

Hi,

Thanks for reply.

I am not using bulk loader.
I don't want to load the records if job gets aborted due to any reason.

Thanks & Regards,
--sudhakar

Hi, I got the following error. SQL*Loader -605:Non-data dependent ORACLE error occurred. I found the solution , there is no space in table to load the records. The problem is, we are processing 100,000 records.After 1000 records job got aborted.So,the records should get rollback.But it is not happen...

Hi, I am getting the following warning. floating point decimal is not fully supported; adjusting the scale. My source is Oracle and target also Oracle. Input column is containing the number but that column datatype is varchar.I am populating this column into target.Target column datatype is NUMBER. ...

Change you declaration line to read Deffun KeyMgtGetNextValue(A1) Calling "DSX.KEYMGTGETNEXTVALUE" ... Hi ArndW, Thanks.It is working.I need to rename the file after it is processed like following. before after fileaA fileA_1_currentdatetime fileaA fileA_2_currentdatetime fileaA fileA_3_c...

Double click on the cell that shows <<ERROR>> in the Test grid and report what is displayed there. ... Hi Ray, It is showing like the following.. TEST #1 ******* Arg1 = 1 Test failed. Program "DSU.modify": Line 5, Unable to open the operating system file "DSU_BP.O/DSX.KeyMgtGetNextVa...

ArndW wrote:Why don't you go to the manager and do a test run run directly in KeyMgtGetNextValue using your test value of "s1". Does that work or show any errors? ...

Hi ArndW,

I need to take the value from routine that is my requirement.

Thanks,
sudhakar

Specify: Deffun KeyMgtGetNextValue(A1) Calling "DSX.KeyMgtGetNextValue" in the first line of your routine. Klaus Hi Klaus, Thanks.Now it is not showing any error.But i have specified Deffun KeyMgtGetNextValue(A1) Calling "DSX.KeyMgtGetNextValue" Ans=KeyMgtGetNextValue("s1&q...

ray.wurlod wrote:In your routine ("modify") you need a DEFFUN declaration to declare the catalog name and number of arguments of the KeyMgtGetNextValue routine. ...

Hi ray,
I did not get exactly.
My requirement is to get next value for each time

Thanks,
sudhakar

Hi,

This is the routine code

Ans=KeyMgtGetNextValue("s1")

THe error is

Compiling: Source = 'DSU_BP/DSU.modify', Object = 'DSU_BP.O/DSU.modify'

Array 'KeyMgtGetNextValue' never dimensioned.

1 Errors detected, No Object Code Produced.

Thanks,
sudhakar

Hi,

I am getting the Following error while processing data from oracle to oracle.

APT_CombinedOperatorController,0: Field 'UDF_057' from input dataset '0' is NULL. Record dropped.

The column name is UDF_057
It contains NULL value.And Nullable option is Yes.

Thanks,
sudhakar

Hi rwierdsm ,

It is nullable column.

Thanks,
sudhakar[/i]

Hi Arnd/Kumar s,

This is urgent fror me.Thats why i said asap.

Thanks,
sudhakar

Hi Kumar/Arndw,

Thanks.I got it

--sudhakar