Search found 312 matches

by kirankota79
Wed Mar 14, 2007 9:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: error with c++ routine in the transformer
Replies: 1
Views: 679

error with c++ routine in the transformer

i have written a C++ routine and it is compiling without any errors in Visual Studio. But when iam using it in the transformer and compiling the job it is giving compilation error. Can anybody tell the possible reasons!


thanks in advance.
by kirankota79
Mon Mar 12, 2007 2:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: server shared container in parallel job
Replies: 5
Views: 2415

server shared container in parallel job

can we use a server shared container in a parallel job....If so please give some hints.


thanks in advance
by kirankota79
Fri Mar 09, 2007 9:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: replacement for lookup stage
Replies: 9
Views: 1803

i want to be more clear......what iam doing is a swap technique. i want to swap the 4 collumns. for example.....the values of columns at row 1 should be swapped with the values of columns at row 100. I have generated some random rownumbers with a C++ routine equal to the number of the records in the...
by kirankota79
Fri Mar 09, 2007 9:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: replacement for lookup stage
Replies: 9
Views: 1803

replacement for lookup stage

i want to replace the values of 4 columns with other values......so iam using the original file as input to the lookupstage and the new values sequential file as a lookup file to the lookup stage. the file has 10million records. Datastage job is aborting saying that the space is not sufficient. i un...
by kirankota79
Wed Mar 07, 2007 1:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: info for dynamic RDBMS
Replies: 5
Views: 1294

i want to use the output of one stream(link) as a lookup for the other stream. I know that i can do in two separate jobs.....separate jobs are not working bcoz of the huge size of the table (10 million records)...
by kirankota79
Wed Mar 07, 2007 1:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: info for dynamic RDBMS
Replies: 5
Views: 1294

info for dynamic RDBMS

Hi........iam using dynamic RDBMS as a source for oracle database. I have two links going out from dynamic RDBMS stage. For each link i am using different sql queries. I want to know how i can execute a sql query for one link first and then go to the next link. i don't want both the links execute si...
by kirankota79
Tue Mar 06, 2007 2:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to kill a parallel job in windows
Replies: 5
Views: 2615

"cleanup resources" is not activated in my director..........what should i do to enable it?
by kirankota79
Tue Mar 06, 2007 11:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to kill a parallel job in windows
Replies: 5
Views: 2615

how to kill a parallel job in windows

i want to kill a job which is running on windows machine. There is nothing wrong in the job.......but i have made some mistake in transformation....so instead of allowing the whole job to run.......i want kill it and recompile then run the job again. even i hit the stop button in director....it is n...
by kirankota79
Fri Mar 02, 2007 9:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem with importing orchestrate schema
Replies: 1
Views: 694

problem with importing orchestrate schema

hi....i am trying to import a table from a schema with orchbutil (orchestrate schema). but i am getting an error......and it is trying to execute the sql query select count(*) from dba_tables where owner = upper('CAFE') Do we need to have privilege on dba_tables and i don't understand why it is look...
by kirankota79
Fri Mar 02, 2007 9:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: requirements for using oracle stage in parallel jobs
Replies: 3
Views: 1053

requirements for using oracle stage in parallel jobs

please tell me whether it is compulsory to have a select privilege for the following to use an oracle stage: DBA_EXTENTS DBA_DATA_FILES DBA_TAB_PARTITONS DBA_OBJECTS ALL_PART_INDEXES ALL_PART_TABLES ALL_INDEXES bcoz......when i used this stage, it is giving an error that it needs the privilege on &q...
by kirankota79
Thu Mar 01, 2007 9:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: replacement for Oracle OCI
Replies: 6
Views: 1566

i dont have select privileges on dba tables. They have given me the privilege only on the schema iam working. Is it necessary for orchbutil to have select privileges on dba or system tables?
by kirankota79
Wed Feb 28, 2007 10:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: replacement for Oracle OCI
Replies: 6
Views: 1566

replacement for Oracle OCI

Is there any replacement for Oracle OCI in parallel job? The table that is working with Oracle OCI in server job ...is not working with ODBC stage in parallel job. I have a problem with a column with a name "TIME_STAMP" for which the datastage is importing as LonVarBinary datatype instead ...
by kirankota79
Wed Feb 28, 2007 9:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem with oracle OCI stage
Replies: 1
Views: 1049

problem with oracle OCI stage

I am giving DSN name, user id and password in the oracle OCI stage. When i give the DSN name, iam getting the following error: CTA_ASR..Oracle_OCI_8i_5: ORA-12154: TNS:could not resolve service name CTA_ASR..Oracle_OCI_8i_5.DSLink1: DSP.Open GCI $DSP.Open error -100. So, i removed the DSN name and g...
by kirankota79
Tue Feb 27, 2007 1:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem with column with name "TIME_STAMP" or &quo
Replies: 10
Views: 2143

anybody...........please give me reply