DSXchange

hello,

No, the files I have to process are all FoxPro DBf files for which I need ODBC (stage).

Peter

Hello,

I have an ODBC file for which I want to check and report if it is sorted on a certain column. How to do this?

Peter

Hello, The following error is displayed when I do view data in an ODBC stage: Error executing View Data command: ##E TOPK 000000 10:34:26(015) <_PEEK_IDENT_> Input dataset does not have field: "mutdat" The following user-defined sql statement is executed: SELECT mutdat FROM test.DBF in bot...

Ok, in more detail: I want to select rows from an ODBC source table (dbf) that have duplicate values in a given column. Only 2 of these rows should be written to a sequential logfile. Additionally, an extra line should be added to the end of this file with the number of duplicates and the percentage...

hi, Setting the userstatus is no problem in server jobs. I already experienced that. However, server jobs are very limited in processing possibilities, so I prefer to develop most things in parallel jobs. Ray mentioned some alternatives like storing the value in a textfile or using environment varia...

Hello,

I have a routine named PublishUserStatus(arg1) that calls the userstatus function, as you adviced:

Call DSSetUserStatus(Arg1)
Ans = 0

Peter

Hello ray, I tried passing a userstatus in a Basic transformer (from a fully sequential parallel job, as you suggested) to the parent job, but this doesn't work. I get the following warning: subjob(BASIC_Transformer_3).#0.BASIC_Transformer_3 (DSSetUserStatus): Error reading Job Status record. JobNo ...

he DLL in question must be an OLE server, so as to expose ActiveX objects. Is yours?

I don't understand your reply?? How can I make an OLE Server for this dll?

In Manager, choose Import > External Function Definitions

We have tried that solution but for us it's not working. We get the message: error loading type library\DLL.

What do we do wrong????

Nope!!

We have now make a call to IBM for this problem..

But maybe can someone help us.....

Hi everyone, We have stille problems with importing a c++ (Borland Dll) into designer. Our ETl envioroment stands on a Windows machine and we uses Parallel- and Server jobs. For parallel jobs we can make an external routine that can use .os file (library file). For the server job enviroment you can ...

Hello,

The dll was still in the Universe standard library list. This list can be viewed in gci.admin, option 7. Deleting the dll from this list solved my problem

Peter

Hello, When I run a job I get the following log warning: DataStage Job 347 Phantom 1728 Error 126 loading GCI library C:\\Ascential\\DataStage\\Engine\\bin\\ultradll.dll. The specified module could not be found. DataStage Phantom Finished Even though I removed ultradll.dll from this directory. (the ...

hi,

If calling an external function is only possible from a server job then i have chosen the wrong forum...

Peter

Hi ray,

No value in particular. Any value that I want to pass to other jobs that follow in the sequence. For instance, a table value that I want to retrieve once, and use in other jobs that come after this one.

Peter