Search found 20 matches
- Mon Nov 13, 2006 3:47 pm
- Forum: DSXchange Testimonials
- Topic: Thanks for Server to EE transition Class
- Replies: 2
- Views: 21484
Thanks for Server to EE transition Class
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 days back, and was in full appreciation for the structure, quality and clarity in Ray's approach to tra...
- Wed Sep 27, 2006 2:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Errors in Director still running
- Replies: 2
- Views: 2794
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 "immediately" with Oracle. Check with your DBAs and try to kill your open session.
- Mon Sep 25, 2006 10:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ORA-01036: illegal variable name/number
- Replies: 14
- Views: 9666
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 a valid numeric literal. Only numeric fields or character fields containing numeric data may be used in ari...
- Mon Sep 25, 2006 10:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ORA-01036: illegal variable name/number
- Replies: 14
- Views: 9666
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')
- Tue Sep 05, 2006 9:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequence in DS
- Replies: 3
- Views: 3107
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. use schema_name.SEQuence_name.nextval an alternate way would be to do the same via a OCI lookup stage. ...
- Wed Mar 15, 2006 9:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generate Sequence in Oracle DB in PX jobs.
- Replies: 6
- Views: 5745
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's method above is the more efficient way to do it... We normally do it this way in server jobs too and found it to be way faster ...
- Tue Jul 19, 2005 1:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: strange Oracle OCI performance problem
- Replies: 3
- Views: 3086
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. If you tested both queries outside of datastage -- and if you returned ALL (not just the FIRS...
- Tue Jul 19, 2005 10:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: strange Oracle OCI performance problem
- Replies: 3
- Views: 3086
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 query is really faster (outside of datastage) is to do a "create table select * from"... or do a...
- Tue Jul 19, 2005 10:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Compare two Oracle table
- Replies: 24
- Views: 10314
- Tue Mar 01, 2005 2:43 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Perfromance Issues
- Replies: 7
- Views: 3600
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: Take the distinct values of Tab2. col1,col2,col3 and stage it in a hashfile HF2 Take the distinct values ...
- Mon Feb 28, 2005 1:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Filter Condition failed in Sequential File
- Replies: 8
- Views: 9092
- Mon Feb 28, 2005 1:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Enterprise Stage
- Replies: 4
- Views: 3421
- Wed Jan 19, 2005 2:34 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: file manipulation
- Replies: 2
- Views: 2867
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 others face. But it doesn't serve anybody any good if one repeatedly asks questions without doing any ...
- Mon Aug 23, 2004 12:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage comparison to Oracle OWB
- Replies: 11
- Views: 8366
- Thu Aug 19, 2004 11:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job Accessed by Another user
- Replies: 6
- Views: 3260