DSXchange

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...

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...

Hi,

I am still having no luck. Any advice would be appreciated.

Thanks,

Chris.

Hi Kenneth,

I am looking at the web pages you posted the address of now. But so you know, I did actually have it exactly as you put it in (with no quotes - apart from those you specify). It just seems to parse it that way.

I will write back if I still can't do it.

Thanks,

Chris.

Hi Kenneth, Thanks for your reply. It compiled alright, but when I tested it, I got the following error: Retrieve: syntax error. Unexpected sentence without filename. Token was "". Scanned command was SSELECT 'LOG' BY '@ID' FMT '12R' Also, can I select into a numbered select list in an EXE...

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...

Hi Dennis,

I was looking for a colleague that I have worked with in the past. I wanted to check if they had their e-mail or web page online.

But this is, I guess, an extenuating circumstance. I just thought this worthy of a mention (but not necessarily worth the trouble for a fix).

Chris.

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.

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...

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...