DSXchange

I use custom SQL, with to_date. Hi Ken, I tried your way, it doesn't work either. Here is the error message: Attempt to convert String value "2004-06-09" to Date type unsuccessful The Oracle stage adds to_Date(columnname, 'YYYY-MM-DD') to your column in the auto-generated SQL. If you're us...

Hi Ken, I tried your way, it doesn't work either. Here is the error message: Attempt to convert String value "2004-06-09" to Date type unsuccessful The Oracle stage adds to_Date(columnname, 'YYYY-MM-DD') to your column in the auto-generated SQL. If you're using auto-generated SQL, then mak...

Hi,

I try to put current date to Oracle. The Oracle type on the target table is Date. If I use the function Date(), then it is a 13310. But if I use the function Oconv, then it becomes blank on the target table.

I do I handle this.

hello everyone,

My input file has duplicated values on the constraint. How do I insert into the database. The constraint are defined by business rules, but they are not keys on the database. I need to inserted them in a way so that only the last duplicated data will be in the database.

Hello everyone, Here is my situation: I loaded existing entries on the output table into a hashfile for lookup and then I perform a look up, if found, I do an update, If not found, I do an insert. I also have an reject file. the funny thing is, for all updated items, They go to both the update the r...

Thank you for the solution. yes I want to pass input rows that have valid matches on 3 attributes on the lookup table. by the way, for the missmatched constraint, Do I use (Isnull(lu1.KeyField)) or (Isnull(lu2.KeyField)) or (Isnull(lu3.KeyField)) What are your requirements? Do you only want to pass ...

I have the same situation. and I am following what you suggested. I am using multiple lookup, but I don't know how I need to define the constraints for insert and update. Do I use the statement " IsNull(Lookup.xxx@TRUE)" This is a pretty straight-forward thing to accomplish. First, pull ex...

I am doing a lookup, the lookup conbines 3 keys. So how do I define the contraints?

You first assumption is correct. The semi-colom caused the problem. Thank you for the help! A couple of things that will typically cause that error... You are using Custom SQL and there is a trailing semi-colon at the end of the SQL statement. Works in View Data but not when the job runs. :? You mis...

Hello I got this error message when I tired to exact data from an Oracle Table and simply load it into a hash file. I am able to view data on the Oracle OCI stage. But if I run the job, this problem occurs. Here is the message: LoadSampleLookUp..Oracle_OCI_9i_0: ORA-00911: invalid character Dose any...

Hi,

I get this error message when I run the ORAOCI9 stage.


ds_loadlibrary: error in dlopen of oraoci9.so -ld.so.1: dsapi_slave: fata;: libclntsh.so.9.0: open failed: No such file or directory.

Does anyone know what the problem is?

Hi,
I am new to meta stage. I am just wondering, is there an Unix version of Metastage?

I called the guy from Ascential who sent me the CD, he said that it works on all Unix platforms, including Sun.

chulett wrote:Nope.

Hi,

I have a Datastage server software that is for HP platform. Is it possbile to install it on Sun Solaris?