DSXchange

Hi Chulett,
Normal java programmers not able to help me..

Hi Eostic,
Please provide me that code snippet.
I understand it will after that for loop.

Hi,
That is not the requirement...
we have to take advantage of java...calculate some result and store in a particular column.

other column will remain as it is.

help me to write that portion of java code and mapped to a extra output column.

i have a java code like this. Can anyone please let me know how can i add new column in java and then pass it on to output link? below sample code will convert lower case to uppercase. import com.ascentialsoftware.jds.Stage; import com.ascentialsoftware.jds.Row; import com.ascentialsoftware.jds.Colu...

Hi Chandra,
I also thinked that way only.
Now the only question remaining if i run this jon manually,it works fine.
If i scheduled it,then only it fails. I tried with different DB2 stages,but no improvement.

The surprising fact of that particular subsequencer is if you run it manually,it works fine,
but you schedule it only that sub sequencer it fails also.

Hi ArndW, Yes . It is a staging table. I am using before job sub routine and calling a unix script to truncate table . After running the job i am facing this issue. I am following same rule other 30 tables and it is working fine. Same unix script is used for all other jobs. If i run it manully it is...

Dear All,
there is no after or before statement and there is no exceute statement also. Its an insert statement on a truncated table. Please note if i ran it manually only this subsequence and its work fine

Hi All, I facing a strange issue in DataStage. My job fails due to following error [IIS-CONN-DB2-000004] DB2 function SQLExecute failed: SQLSTATE = 22001: Native Error Code = -302: Msg = [IBM][CLI Driver][DB2/LINUXX8664] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too l...

detail error message from a db2 connector stage: IIS-CONN-DB2-000013] DB2 information: SQLSTATE = 40506: Native Error Code = -1,476: Msg = [IBM][CLI Driver][DB2/LINUXX8664] SQL1476N The current transaction was rolled back because of error "-911". SQLSTATE=40506 see first in target table on...

Hi,
Auto-purge of job log check box is not clicked in administrator.
so purge option of log is not active.

Thanks

Hi All, we have two source system AUS and UK . Tables are pulled are same structure in both the instance. So we have created one multi instance enabled job that will used for both the instances. Now one separate sequence for each job that is multi instance enabled. Two main sequences has been create...

Hi All, i am finding difficulty while reading data from DB2 through ODBC connector stage. When i am using DB2 API stage read the table there is no issue. But same table reading by ODBC connector throwing following error. "An exception occured while trying to receive the response from handler:OD...

I have tried with
CAST(<string_or_column> AS <DATATYPE>)
TO_CHAR(<string_or_column>, <format>) and
TO_CLOB(right VARCHAR2 CHARACTER SET ANY_CS) RETURN CLOB

If you have different opinion,just let me know.

Hi All, I am not able to read SDO_geometry() datatype[oracle source] in DataStage through ODBC Connector stage. I am getting the following error. "An exception occured while trying to receive the response from handler :An exception received from handler:unknown datatype" when try to view d...

Hi All, Thanks for your help.After 3 days of sleepless day/night,issue just resloved. Solution is creating one password environment variable ,with string type[remember not encryption type] and assign it to our password argument in routine. Donot be surprise..I have different kind of experience with ...