Search found 10 matches
- Mon Mar 28, 2005 7:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: link report not found
- Replies: 13
- Views: 18076
Hi All, I have had this problem as well. Our problem occured when custom SQL was used in an OCI stage (in our cases a lookup) - when using the process metabroker. In our case, it turns out it was the lack of a table name in the OCI stage that caused this problem. Go into the offending link, change t...
- Tue Nov 25, 2003 1:01 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extracting from a hash file in numeric order.
- Replies: 8
- Views: 5253
Got it! I assumed that the 'yourhashfile' part of your code refered to a file variable. I have found that it refered to the actual name (a mistake on my part - but that was how it worked in the select without the execute). I had an OPEN statement above and assumed that this operated on the open hash...
- Tue Nov 25, 2003 12:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extracting from a hash file in numeric order.
- Replies: 8
- Views: 5253
- Mon Nov 24, 2003 11:58 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extracting from a hash file in numeric order.
- Replies: 8
- Views: 5253
- Mon Nov 24, 2003 11:21 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extracting from a hash file in numeric order.
- Replies: 8
- Views: 5253
- Mon Nov 24, 2003 9:20 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extracting from a hash file in numeric order.
- Replies: 8
- Views: 5253
Extracting from a hash file in numeric order.
Hi, I am writing a custom Server Routine to read out of a hash file. The only problem is that the key is a number. I have tried: SSELECT FILENAME TO X That returns data sorted alphabetically (1, 10, 2, 3, etc). I have done searches on previous topics and found nothing like this (lots on sorting, but...
- Thu Oct 16, 2003 11:16 pm
- Forum: Site/Forum
- Topic: Memberlist On DSXchange
- Replies: 2
- Views: 4364
- Thu Oct 16, 2003 9:25 pm
- Forum: Site/Forum
- Topic: Individual Post View
- Replies: 2
- Views: 4811
Individual Post View
Hi,
This suggestion is only a nice-to-have. I have found a great post that I would like to print. The only problem is that you can not view just one post.
That's all.
Chris.
This suggestion is only a nice-to-have. I have found a great post that I would like to print. The only problem is that you can not view just one post.
That's all.
Chris.
- Thu Oct 16, 2003 9:18 pm
- Forum: Site/Forum
- Topic: Memberlist On DSXchange
- Replies: 2
- Views: 4364
Memberlist On DSXchange
It is difficult to find particular users. In the Tools4Datastage forum, you were able to find a username (nickname) by the user's first and last names. I couldn't find any facility to do this. Not only that, if you would like to find the users with particular locations or usernames that lie in the m...
- Wed Sep 24, 2003 9:38 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: One Input file and multiple Output
- Replies: 7
- Views: 3300
Hi Louise, There is one other solution to get it to work. You can use an OCI stage -> Tx -> Sequential File -> OCI. In the transform, for the column output, use the derivation - col1 : Char(10) : col2 : Char(10) : ... : col12. Remember to leave the last Char(10) off the end. For this solution, it is...