DSXchange

How would you know I am not?

Anyway, the resolution seems to be related to the length of the sql being passed via the Oracle Enterprise Stage. I shortened the sql and the job now works.

Hi,

I am facing the same issue when placing an update call to Oracle via Oracle Enterprise stage

Contents of phantom output file =>
509 Segmentation Fault - core dumped

The query works fine on toad.

If you know a workaround to this please let me know.

Thanks,

Hema

If you are loading this into a database, then it should automatically be handled at the database level. e.g. If you use an Oracle Enterprise stage, you can specify Upsert option with "Insert then Update" so that any rows coming in will be inserted then updated. Otherwise just use a dummy f...

Hi Ray,

I see what you mean now, sorry for being so daft. I am not an Oracle person (as must be obvious now.)

Thanks again for your help.

Regards,

Hema

Hi Ray, Thanks for the response. I am not sure what you mean. The table on the Database is a partitioned table, and i am trying to insert values in a particular partition by deriving the partition name from a key column. I am able to insert data via Oracle enterprise stage if I hard code the partiti...

Hi, I am trying to insert data into a partitioned table which has a partition name based on one of the primary key columns of the table. e.g if the value of the key column is PN GBRTEST the partition name is PN_GBRTEST. So my insert statement should look like insert into <table_name> partition (<par...

Would be a good idea if you could post the whole log then ? p.s i think you might want to double check the values you are specifying for the enterprise stage. and what is pname ?? I have no idea what pname is. I havent specified it anywhere I dont know where its picking that from. The log's below: ...

Can you shed a bit more light on where are you getting this error ? are you being able to view the file properly ? Are you using parameters? I'm getting this error in the Director, I am able to view the data in the file from datastage and i'm not using any parameters. Its a job selecting two fields...

Hi,

Can anyone shed some light on this error?

main_program: Fatal Error: No match for pname: db_cs, which: 0

I'm trying to run a very simple job to read from a file and insert into an oracle table when it aborts.

Thanks in advance

H

Is there any way we can use the IN function within Datastage? I have code which runs as follows IF r_tes.action IN ('TER','RET','RWP','TWB','TWP') THEN v_reason_for_leaving := r_tes.action_reason; ELSIF r_tes.termination_dt = to_date(r_tes.snapshot_key,'YYYY/MM/DD') AND r_tes.empl_status NOT IN ('T'...

Excellent. Thanks!

Hi,

Is there any way one can view the code generated by the transformer via datastage or on the server?

Thanks,

Hema

If both the tables are in the same schema then you can do it in one database stage itself. Something like select * from TABLE1 where timestampColumn > (select Max(Timestamp) from TABLE2) Thanks for the response. Actually, I am trying to do incremental loads from an audit table which has thousands o...

Hi, I am trying to do incremental loads. I need to select the max timestamp from the target table, compare it with a timestamp value in the Source table and select all rows which are greater than the max timestamp. I am trying to use the lookup stage in parallel to do this but need some suggestions ...

If it's a timestamp, it should be able to copy straight through (perhaps with an adjustment to the fractional seconds). [Oconv() does not work with timestamps even in server edition.] ... Hi Ray, Thanks for this. It's able to copy straight through if I change the Target datatypes in the transformer...