Search found 531 matches

by prasson_ibm
Wed May 21, 2014 7:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while compiling custom operator code
Replies: 8
Views: 3256

I believe i am giving full path of .h headers.
by prasson_ibm
Wed May 21, 2014 9:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while compiling custom operator code
Replies: 8
Views: 3256

Hi Ray, Sorry,but i dont understand exactly what you are asking. :cry: I dont know if i understood correctly,but i went and looked into header files which i named here for e.g. $ more /opt/IBM/InformationServer/Server/PXEngine/include/apt_util/parse_err.h #ifndef APT_PARSE_ERR_H #define APT_PARSE_ER...
by prasson_ibm
Tue May 20, 2014 3:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while compiling custom operator code
Replies: 8
Views: 3256

Error while compiling custom operator code

Hi, I am trying to compile custom operator code on AIX server but i am getting below error message:- $ /usr/vacpp/bin/xlC_r -O -q64 -c /opt/IBM/InformationServer/Server/PXEngine/include strrevop.c -o strrevop_temp.o "/opt/IBM/InformationServer/Server/PXEngine/include/apt_framework/osh_name.h&qu...
by prasson_ibm
Wed May 14, 2014 1:42 am
Forum: General
Topic: Different Versions of same Job
Replies: 2
Views: 1428

Information Server Manager can also tell you what changes has beed done in your job in case you build a package.
by prasson_ibm
Wed May 14, 2014 1:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to create shared C++ object and use them in datastage
Replies: 6
Views: 6743

Try this:-

APT_COMPILEOPT=-O -q64 -c
APT_COMPILER=/usr/vacpp/bin/xlC_r

$<APT_COMPILER> <APT_COMPILEOPT> File_name.cpp
by prasson_ibm
Tue May 13, 2014 4:38 am
Forum: General
Topic: best way to design near real time job/sequence
Replies: 3
Views: 1410

Thanks Ray,

My only concern with this solution is Job log,log will keep on appending for the sequence because it will run 80 times in one day in a loop and auto purge only works when sequence finishes,and in solution it will finishe at 10.
by prasson_ibm
Tue May 13, 2014 2:49 am
Forum: General
Topic: best way to design near real time job/sequence
Replies: 3
Views: 1410

best way to design near real time job/sequence

Hi all, I got a requirment where i need to design a solution for near real time data extraction. My requirment is,i need to extract data from source and run my job in every 10 mints from 8:30AM to 10PM. I am thinking to design a sequence with many loops and stop,reset it everyday at 10PM using scrip...
by prasson_ibm
Fri May 09, 2014 5:52 am
Forum: General
Topic: Datastage Installation
Replies: 3
Views: 2346

Hi,

I am also facing the same issue.

when i check netstat -a|grep 9080 i dont get any result :cry:
by prasson_ibm
Tue Apr 29, 2014 7:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Error in view data
Replies: 7
Views: 3993

Hi,

I have changed the name as "LOC" and in metadata it is also "LOC" but still i am getting same error :cry:
by prasson_ibm
Tue Apr 29, 2014 6:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Error in view data
Replies: 7
Views: 3993

Hi, I tried to investigate more further and found that when query has functions like NVL it gives me error in viewing data. For e.g. When i paste below query in oracle connector,i am able to view the data. SELECT /*+ PARALLEL(a,4) */ ITEM, BUSINESS_UNIT_ID, DEPT, CLASS FROM #Source_DB.SRC_SCHEMA#.#S...
by prasson_ibm
Tue Apr 29, 2014 4:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Error in view data
Replies: 7
Views: 3993

Oracle Error in view data

Hi, I have job with oracle connector stage,job is running fine but when i am doing view data it gives me below error message:- The OCI function OCIStmtExecute return status -1. Error Code:3,115,Error Messgae: ORA-03115:unsupported network datatype or representation. Can anyone faced the same issue.P...
by prasson_ibm
Tue Apr 22, 2014 4:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Procedure Status in Stored Procedure stage
Replies: 3
Views: 2605

Hi,

In case procedure is failing what return code you are getting in file?
by prasson_ibm
Tue Apr 22, 2014 4:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unique record counter-Hash partitioning before transformer
Replies: 8
Views: 4668

Hi,

My advice is define a stage veriable in Transformer stage.Hash partition the input column and compare the current record with the previous record,if both are different then increment the counter veriable otherwise let it be same.
by prasson_ibm
Tue Apr 22, 2014 3:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error message: ORA-24374: define not done before fetch or ex
Replies: 4
Views: 7661

Can you please explain simple what you are doing in your job design.
by prasson_ibm
Tue Apr 22, 2014 3:48 am
Forum: General
Topic: IBM datastage 8.7 certification
Replies: 1
Views: 1619

IBM datastage 8.7 certification

Hi Guys,

I am trying to apply for IBM Datastage 8.7 certification,but i can't see any options available.

Is IBM providing certification on v8.7?

Thanks
Prasoon