Search found 8 matches

by cassi_bsb
Tue Nov 21, 2017 7:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage with R functions
Replies: 4
Views: 3263

DataStage with R functions

Hi

Anyone have a case using R Functions (https://www.r-project.org/) in DataStage.

Thanks for any idea!!!
by cassi_bsb
Tue Sep 06, 2016 1:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Download zip file from http link
Replies: 4
Views: 2790

SURA wrote:

Code: Select all

wget -O file.tar "http://link"
You can try this.
Due to network restrictions, it can't reach the target.

I will see if network admin can open this route in firewall.

Thanks
by cassi_bsb
Mon Sep 05, 2016 2:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Download zip file from http link
Replies: 4
Views: 2790

Download zip file from http link

Hi all,

Is there any way to download a file from http link to a local server?

I need to download a zip file to DataStage server, unzip it then load into staging area. This zip file is updated every week, but keep the same name.

Thanks

Cassiano
by cassi_bsb
Fri May 15, 2015 6:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Length of ODBC Message
Replies: 2
Views: 1877

Length of ODBC Message

Hi There, Is there any way to configure the length of message sent from DB to DataStage ODBC conector? We have some troubles to identify properly the error because the message is presented truncated at 200 characters. Perhaps that the most significant part of message is not presented, like bellow. A...
by cassi_bsb
Mon Sep 27, 2010 8:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: can't open join stage properties
Replies: 5
Views: 3319

hi,

I have the same problem. I think that is a problem in registry.
Is there any solution?

Thanks,
Cassiano
by cassi_bsb
Thu Jul 15, 2010 1:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Classifying Link Types as Source, Reference and Reject
Replies: 10
Views: 6878

muralisankarr,

Did you resolve it? I have same problem with DSGetStageInfo.

Cassiano
by cassi_bsb
Wed Jan 09, 2008 11:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Select query fails sometimes
Replies: 4
Views: 2926

Re: Select query fails sometimes

Some of our server jobs which have the following flow odbc_stage(select from t1) -->transformer--> seq file --> odbc stage (update t1) fails sometimes with the following error message DSD.BCIGetNext call to SQLFetch failed. followed by the select query. When the job is executed say about 3 or 4 tim...
by cassi_bsb
Wed Jan 09, 2008 10:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: TIMESTAMP - SQL reserved word
Replies: 1
Views: 1436

TIMESTAMP - SQL reserved word

Hi, I am having problem while importing a DB2 DCLGEN in MetaStage. Occurs that MetaStage not allow to set a collumn name like "TIMESTAMP" ERROR: Erro 1 (line 13): 'TIMESTAMP' Column name cannot be SQL reserved word. In IBM DB2 there is no restriction about a column name like TIMESTAMP. Is ...