DSXchange

And when that happens, it will still take years to catch up to whatever post level high water mark Ray leaves behind.

See previous reply.

Oh, and Welcome. Simply correct your issues as noted and we'll help as best we can. :D

Where to start?

You need to post in the correct forum, use meaningful Subjects (ds? come on) and do a better job of asking your question. There's not enough information here to do anything but guess what might be going on.

Besides the fact that (as noted) hashed files have no 'duplicate' records, it can't be used to return multiples. Other stages can - UV, ODBC. What exactly do you need to do?

I guessing that, since the question does not make any sense, that the answer wouldn't either. Is there someone else there whom you could run the question by, see if they understand the change needed?

I searched the forum, but couldn't get any info. Really? I did an Exact match search for your error string: (Subroutine failed to complete successfully (30107) And found 47 threads. Note I needed to put the space back before the paren that got taken out somehow. The answer seemed to be pretty consi...

Because the Keys are what are passed from the main input stream to the reference lookup, and are what are used in the 'where' clause to constrain your query to the row that is best suited to your input data. The bind variables are the place holders for the key values.

Never heard of nor seen an XML Reader stage, where did you 'come across' it? XML Input XML Output XML Transformer Are the three XML related stages in the product. For your requirement, a typical job design would look something like: Folder -> XML Input -> Transformer -> Sequential File Suggest you a...

Which would explain why I've never seen that option light up.

If Num(YourField[2,20]) Then map_positions Else leave_blank

One 'value' period, and last one in wins. Make that value delimited and parse it post fetch.

paule wrote:Is it true that all users logging into Designer, etc. have to have admin rights on the server?

No. Search the forums here for your exact error message.

Or a routine that runs a sql*plus session and returns the value you need. Execute this routine in the Initial Value column.

Maybe. If I had a clue I'd help, but this is not my cup o' tea. When you do get the solution, please post it back here.

You can also leverage the 'more than 300' iWay adapters from Information Builders, including one for Essbase.