Search found 18 matches
- Mon Jul 16, 2007 12:03 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extract Oracle Ora-Error description
- Replies: 7
- Views: 5084
Re: Extract Oracle Ora-Error description
Thx, guys, I will check out the LastErr.
- Sat Jul 14, 2007 10:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extract Oracle Ora-Error description
- Replies: 7
- Views: 5084
- Sat Jul 14, 2007 9:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extract Oracle Ora-Error description
- Replies: 7
- Views: 5084
Extract Oracle Ora-Error description
Hey, just wondering if anyone tried to extract the Oracle ORA-? Description within a server job during insert/update. I know it's found in run Log, but anyone has tried to do it within the job itself? The best I found it is the Code itself use the DBMSCODE in the Link Variable Outputs. But it is jus...
- Thu Aug 17, 2006 2:07 pm
- Forum: Articles, White Papers and Tips and Tricks
- Topic: What happened?
- Replies: 0
- Views: 21641
What happened?
Haven't been here for awhile, but what happened to the searchable archive for all the tricks, tips and faq?
- Tue Feb 15, 2005 2:41 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Using hash files instead of UV tables for multirow
- Replies: 13
- Views: 19297
- Tue Feb 15, 2005 2:37 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date between two dates - comparision
- Replies: 2
- Views: 2735
Re: Date between two dates - comparision
Not sure this would help performance wise, but I would design my job this way. So both files do not have match keys, I am assuming you are comparing the dates row by row. 1 row compare with 1 row. I would generate a new seq file and a hash file with generated keys (row 1 = key 1, etc). While I gener...
- Tue Feb 15, 2005 1:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS Repository
- Replies: 11
- Views: 6898
- Tue Feb 15, 2005 1:13 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Enable Selection tab in Hash Stage for Remote Hash File
- Replies: 10
- Views: 6642
- Sat Feb 12, 2005 2:53 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Enable Selection tab in Hash Stage for Remote Hash File
- Replies: 10
- Views: 6642
- Fri Feb 11, 2005 3:19 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Enable Selection tab in Hash Stage for Remote Hash File
- Replies: 10
- Views: 6642
Enable Selection tab in Hash Stage for Remote Hash File
All: I researched a lot of people's post about mkdbfile, setfile, and hash file, but I got bits and piece of info. So I am posting to see if anyone can help me understand this a bit more so I can enable the selection tab in the hash stage for Remote Hash File without too much manual process. The bac...
- Thu Feb 10, 2005 5:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Access Seq files over http
- Replies: 4
- Views: 3507
- Wed Feb 09, 2005 7:09 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Access Seq files over http
- Replies: 4
- Views: 3507
Access Seq files over http
Hi All: Been awhile since I have time to drop by, but I am back to get help where I know I will get one when I needed. :) The challenge is that I got a few csv seq files on an url. I can not get ftp access to them so I have to do it via http so anyone has any idea how to do this without using RTI we...
- Thu Jul 08, 2004 6:43 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Reading variable length records in Sequencial Stage
- Replies: 9
- Views: 6479
This is what I think you are trying to do: Record A1-1 A1-2 A1-3 A1-4 Record B1-1 B1-2 B1-3 B1-4 Record B2-1 B2-2 B2-3 B2-4 Record B3-1 B3-2 B3-3 B3-4 Record C1-1 C1-2 C1-3 C1-4 Into A1-1, A1-1, B1-1, B1-2, B1-3, B1-4, C1-1 A1-1, A1-1, B2-1, B2-2, B2-3, B2-4, C1-1 A1-1, A1-1, B3-1, B3-2, B3-3, B3-4,...
- Fri Jul 02, 2004 5:34 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Difference/Advantage of using Transform instead of Routine
- Replies: 12
- Views: 8062
If not transform or routine for an over million row in DS, what else? Is there something option or way to able to call a rountine or function without it being called and cleaned up for each row? I can probably code a routine that actually process each row within that routinue, but that defeats the p...
- Fri Jul 02, 2004 12:23 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Licensing and mulithreading
- Replies: 5
- Views: 3908
Not an expert on licensing or multi-threading, but after an interesting interaction with Asc. about my company's licensing issue, I don't have an overall warm and fuzzy feeling toward Asc's licensing policy. In my opinion, I don't think someone should charge me extra for using the more powerful hard...