Search found 25 matches

by dsfamily
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
by dsfamily
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...
by dsfamily
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
by dsfamily
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
by dsfamily
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.
by dsfamily
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...
by dsfamily
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...
by dsfamily
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||'"' ...
by dsfamily
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?
by dsfamily
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.
by dsfamily
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

I tried this setting.I even restarted my machine.I still get the error.
by dsfamily
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

Please install fixpack1 and this issue will fade away
by dsfamily
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

Install fixpack1 .this error will go away
by dsfamily
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

I tried that too.Please find the fasttrack ini file.
-clean
-vm
../../ASBNode/apps/jre/bin/javaw.exe
-vmargs
-Dauthentication=server