Search found 25 matches
- Fri Dec 19, 2014 3:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: greeenplum error log
- Replies: 1
- Views: 1703
greeenplum error log
I am getting intemittent pipe errors
- Fri Sep 26, 2014 9:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: calling gp truncate
- Replies: 2
- Views: 2357
calling gp truncate
-- Function: dba.gtradmin_trunctable(character, character varying) -- DROP FUNCTION dba.gtradmin_trunctable(character, character varying); CREATE OR REPLACE FUNCTION dba.gtradmin_trunctable(sn character, tbl character varying) RETURNS character varying AS $BODY$ DECLARE result boolean; mycaller pg_s...
- Fri Sep 05, 2014 7:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage loading with greenplum connector
- Replies: 1
- Views: 2047
Datastage loading with greenplum connector
I get this message and it just hangs and keeps hanging forever
Greenplum_Connector_8,1: [+]CC_GPBigBufferConsumer::getDataSetDef
Greenplum_Connector_8,1: [+]CC_GPBigBufferConsumer::getDataSetDef
- Thu Aug 21, 2014 2:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Greenplum connector only for select columns
- Replies: 6
- Views: 3652
runtime columnpropogation is not on
runtime column propogation is not on.the table is straight select from dataset
- Wed Aug 20, 2014 10:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Greenplum connector only for select columns
- Replies: 6
- Views: 3652
tried the option but it still looks for all the columns.
It still looks for all columns
- Wed Aug 20, 2014 9:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Greenplum connector only for select columns
- Replies: 6
- Views: 3652
Greenplum connector only for select columns
How do i use greenplum connector to insert only selected columns.It seems to take all columns by default.
- Tue May 13, 2014 9:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: writing rank
- Replies: 3
- Views: 3514
writing rank
-- Function: gtr_etd.etd_auto_exit() -- DROP FUNCTION gtr_etd.etd_auto_exit(); CREATE OR REPLACE FUNCTION gtr_etd.etd_auto_exit() RETURNS integer AS $BODY$ DECLARE p_position character varying := 'Position'; p_submitted_for character varying := 'BOTH'; p_PositionCancel character varying := 'Position...
- Fri May 02, 2014 11:54 am
- Forum: General
- Topic: external table force quoting
- Replies: 3
- Views: 1906
external table force quoting
--------- 'gpfdist://172.30.208.100:8881/RATES_EHCRPT_File1.CSV', ----- 'gpfdist://172.30.208.100:8882/RATES_EHCRPT_File2.CSV', ----- 'gpfdist://172.30.208.100:8883/RATES_EHCRPT_File3.CSV', ----- 'gpfdist://172.30.208.100:8884/RATES_EHCRPT_File4.CSV', ----- 'gpfdist://172.30.208.100:8885/RATES_EHCRP...
- Tue Apr 08, 2014 3:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: populating an external table with quotes
- Replies: 1
- Views: 1898
populating an external table with quotes
CREATE WRITABLE EXTERNAL TABLE gtr_temp.ext_temp4(trade_side_id integer, obligation character varying(50) ) LOCATION ('gpfdist://172.30.218.130:8880/Ext_temp4.CSV') FORMAT 'csv' (DELIMITER ',') DISTRIBUTED RANDOMLY ; insert into gtr_temp.ext_temp4 select trade_side_id,'"'||obligation||'"' ...
- Wed Sep 08, 2010 3:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How can I do Audit Reporting?
- Replies: 3
- Views: 3158
how to generate the following reports
How do i create these reports for audit purpose?
- Fri Aug 13, 2010 1:35 pm
- Forum: General
- Topic: Error when creating any job after project is created.
- Replies: 1
- Views: 1743
Error when creating any job after project is created.
I installed fix pack 1 and i am getting he following error ehen i create a new project and compile it.
Error calling subroutine: DSR_RECORD (Action=21); check DataStage is set up correctly in project DataMigration_Dev
(The connection is broken (81002))
I have tried fixtools and most steps possible.
Error calling subroutine: DSR_RECORD (Action=21); check DataStage is set up correctly in project DataMigration_Dev
(The connection is broken (81002))
I have tried fixtools and most steps possible.
- Fri Aug 06, 2010 2:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Ibm Information server fasttrack error
- Replies: 8
- Views: 6502
- Fri Aug 06, 2010 10:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: The call to sqlldr failed; the return code = 256;
- Replies: 12
- Views: 13346
- Fri Aug 06, 2010 10:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: The call to the sqlldr failed;return code=256
- Replies: 5
- Views: 4245
- Fri Aug 06, 2010 10:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Ibm Information server fasttrack error
- Replies: 8
- Views: 6502