DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 20 matches
Author Message
 Topic: Thanks for Server to EE transition Class
bibhudc

Replies: 2
Views: 9341

PostForum: DSXchange Testimonials   Posted: Mon Nov 13, 2006 3:47 pm   Subject: Thanks for Server to EE transition Class
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
I attended the Server to EE transition Class several months back, at Dallas. I think I did thank the organizers and our instructor on a class well conducted. I was reading the handouts again a few day ...
Resolved
 Topic: Errors in Director still running
bibhudc

Replies: 2
Views: 1662

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Sep 27, 2006 2:50 pm   Subject: Re: Errors in Director still running
I suspect your session is still open with the database and is trying to insert records and hence encountering the ORA-12899 error. Killing the job from Director always doesn't terminate the connection ...
Resolved
 Topic: ORA-01036: illegal variable name/number
bibhudc

Replies: 14
Views: 6478

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Sep 25, 2006 10:59 am   Subject: Re: ORA-01036: illegal variable name/number
I am sure you looked at ORA-01722 invalid number already. Just in case you didn't:

Cause: The attempted conversion of a character string to a number failed because the character string was not ...
Resolved
 Topic: ORA-01036: illegal variable name/number
bibhudc

Replies: 14
Views: 6478

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Sep 25, 2006 10:31 am   Subject: Re: ORA-01036: illegal variable name/number
could it be this part "ERDAT_SLS_ORD_CRTE_DT=:3" ? try ERDAT_SLS_ORD_CRTE_DT=TO_date(:3, 'YYYY-MM-DD')
 Topic: Sequence in DS
bibhudc

Replies: 3
Views: 1944

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Sep 05, 2006 9:22 am   Subject: Re: Sequence in DS
Hi All,

Pls clarify me regarding how to call an oracle sequence inside the data stage?

one way would be to use userdefined sql while you either do the select or insert in the Oracle stage .. i.e ...
 Topic: Generate Sequence in Oracle DB in PX jobs.
bibhudc

Replies: 6
Views: 3801

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 15, 2006 9:17 am   Subject: Generate Sequence in Oracle DB in PX jobs.
Why don't you just use the sequence when inserting the rows with user-defined SQL? For example
INSERT INTO table(col1, col2, col3) VALUES (tableseq.NEXTVAL, :1, :2);

ray' ...
 Topic: strange Oracle OCI performance problem
bibhudc

Replies: 3
Views: 1687

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 19, 2005 1:49 pm   Subject: Re: strange Oracle OCI performance problem
[quote="chanthou_2000"]the processing after the OCI is exactly the same.
as i mentionned, i execute an explain plan and i tested the 2 queries oustide of Datastage, and i have the same conclusion.
...
 Topic: strange Oracle OCI performance problem
bibhudc

Replies: 3
Views: 1687

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 19, 2005 10:56 am   Subject: Re: strange Oracle OCI performance problem
Chanthou,

After the OCI stage, are both jobs doing a similar kind of processing ? i.e. is one writing to a text file while the other is going through transformations ?

One way to find out which ...
 Topic: Compare two Oracle table
bibhudc

Replies: 24
Views: 6066

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Jul 19, 2005 10:38 am   Subject: Compare two Oracle table
The MINUS command is also powerful.

Use the Minus command with caution. If any of the columns has NULLs, then the minus command willnot work.
 Topic: Perfromance Issues
bibhudc

Replies: 7
Views: 2092

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Mar 01, 2005 2:43 pm   Subject: Perfromance Issues
Better split the query into DataStage manageable chunks and design the job in DataStage.

To add to what the experts have said here, here is a how you could do it in datastage manageable chunks:

...
 Topic: Filter Condition failed in Sequential File
bibhudc

Replies: 8
Views: 6845

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 28, 2005 1:50 pm   Subject: Filter Condition failed in Sequential File
dsedi,

can you try with this to eliminate the first line -- sed -e '1d' filename ?
 Topic: Oracle Enterprise Stage
bibhudc

Replies: 4
Views: 1938

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 28, 2005 1:10 pm   Subject: Oracle Enterprise Stage
One way you could avoid re-processing all the rows again is to store the records in a flat file before you insert into the Oracle table. This of course gets complicated if you have multiple targets in ...
 Topic: file manipulation
bibhudc

Replies: 3
Views: 1797

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Jan 19, 2005 2:34 pm   Subject: Re: file manipulation
Harithay,

Very few will disagree with Ken Bland's observation to your latest post on the dsxchange. There are a bunch of very experienced and knowledeable people here who help solve lot of problems ...
 Topic: DataStage comparison to Oracle OWB
bibhudc

Replies: 11
Views: 6391

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Aug 23, 2004 12:27 pm   Subject: DataStage comparison to Oracle OWB
I don't know if its true now, but when I worked with OWB (about 5 yrs back) it only worked with Oracle databases. It would just generate Pl/Sql code and run it on the oracle engine.
 Topic: Job Accessed by Another user
bibhudc

Replies: 6
Views: 1633

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Aug 19, 2004 11:37 am   Subject: Job Accessed by Another user
Try using DS.TOOLS from the Administrator client.

Bibhu
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours