DSXchange

Hi,

I am using ORACLE Stage to read data from the database. My job is running successfully but ORACLE Stage giving warnings like: "orclGftRgtPrch: Column ORDERITEMS_ID floating point decimal is not fully supported; adjusting the scale."

Can any one guide me.

Thanks,
Reddy.

Here, take a look at this page on why that error occured and what to do to fix it. Thanks for valuable suggestion... but... Today i am getting different Fatal error... as follows... DB2_UDB_Enterprise_57: The db2 node `uhqt3cdb01.rei.com' does not exist in the apt configuration file. main_program: ...

My target is DB2. i am using DB2 enterprise stage. following fata errors r giving... can any one suggest me... DB2_UDB_Enterprise_57,0: DB2 Load Binary Error. DB2_UDB_Enterprise_57,0: SQLCODE = -3508; SQLSTATE= ?????/tmp/APT_DB2_LOADMSG_db2inst10_REMOTE DB2_UDB_Enterprise_57,0: SQL3508N Error in acc...

Hi,

Need help to write script, to place output file generated by my job in to remote server in specified directory.

Thanks,
Reddy.

Hi, I have flat file (source) contains fields like city,country,... . Target dimention table (country) contains fields like country,city,... and so on. In my source field country, some times empty.... if it is an empty i have to identify the country for that corresponding city field, then i have to ...

Can any one explain about Data set Management option in Designer. i.e.
Tools>Data set Management.

Thanks
Reddy.

i have to give condition in where clause like " where name1 is not null". There are different ways i tried like 1)when i try to give the same conditon in where clause by selecting operand as name1 and the operator as IS NOT NULL, while verifying ABAP Extract stage is giving " right op...

Hi,

My problem is resolved. If i change numeric data type to integer, its not showing period at the end of the data in the field.
Thanks for your suggestion ArndW.

i have requirement like based on the input parameter(date) in to sequential file field data type Numeric. In the Numeric field length is 8. Output of sequential file is giving date and ending with period(.). like (2005-12-21.).I am using logic to converting that field is DateToString(inputparameter,...