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.
Search found 19 matches
- Fri Nov 13, 2009 6:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: 22101 Segmentation Fault - core dumped & Parallel job re
- Replies: 11
- Views: 5891
- Thu Nov 12, 2009 5:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: 22101 Segmentation Fault - core dumped & Parallel job re
- Replies: 11
- Views: 5891
Re: 22101 Segmentation Fault - core dumped & Parallel jo
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
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
- Tue Sep 22, 2009 2:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Update/Insert a Dataset
- Replies: 4
- Views: 4432
- Fri May 08, 2009 4:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inserting Data into Partitioned Tables
- Replies: 3
- Views: 3234
- Fri May 08, 2009 2:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inserting Data into Partitioned Tables
- Replies: 3
- Views: 3234
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...
- Fri May 08, 2009 1:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inserting Data into Partitioned Tables
- Replies: 3
- Views: 3234
Inserting Data into Partitioned Tables
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...
- Tue Apr 01, 2008 12:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: main_program: Fatal Error: No match for pname: db_cs, which:
- Replies: 7
- Views: 4027
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: ...
- Mon Mar 31, 2008 11:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: main_program: Fatal Error: No match for pname: db_cs, which:
- Replies: 7
- Views: 4027
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...
- Mon Mar 31, 2008 11:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: main_program: Fatal Error: No match for pname: db_cs, which:
- Replies: 7
- Views: 4027
main_program: Fatal Error: No match for pname: db_cs, which:
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
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
- Thu Mar 13, 2008 10:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: IN / NOT IN functions
- Replies: 5
- Views: 2012
IN / NOT IN functions
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'...
- Thu Oct 18, 2007 9:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer Code
- Replies: 2
- Views: 1305
- Thu Oct 18, 2007 3:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer Code
- Replies: 2
- Views: 1305
Transformer Code
Hi,
Is there any way one can view the code generated by the transformer via datastage or on the server?
Thanks,
Hema
Is there any way one can view the code generated by the transformer via datastage or on the server?
Thanks,
Hema
- Fri Sep 15, 2006 10:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparing with max timestamp
- Replies: 6
- Views: 2736
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...
- Fri Sep 15, 2006 4:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparing with max timestamp
- Replies: 6
- Views: 2736
Comparing with max timestamp
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 ...
- Fri Sep 15, 2006 4:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 to Oracle Timestamp conversions
- Replies: 5
- Views: 3746
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...