DSXchange

Unfortunately, it doesn't work properly for anything other than hashed files. For database lookups, check for null values returned instead. ... arrrghhhhh!!!! Full day trying to guess what the ***** was happening, and now it comes to me that there is a 'bug' on Datastage with this issue! At least, ...

I thougth I was going to find this easily in the forum, but I couldnt I am writting a user routine, and I would to do something like this: FUNCTION CALCUL (x, z) y = x + z RETURN (y) END Ans = CALCUL (Arg1, Arg2) But I got this error when compiling: "FUNCTION" unexpected, Was expecting: Ar...

I am working with Excel sheets via ODBC, reading and writing to. I do have a source Excel which I can read perfectly, with a column with long text, some of them, longer than 255. As said, I can read them. But when writing to destination, I can only write the first 255 positions. I tried all of this:...

Got it! It's char(10)
Thanks guys!

At the moment, the routine is just doing what I posted: Ans = index(Arg1, char(10):char(13), 1) And it is for sure that what I have is not separate cells, but just one with returns (no idea if they are like operating system, but they are returns, I can even "navigate" the cell with down cu...

I do have an ODBC connection pointing to an Excel file. Some of the cells do have values like this CN MA TH I mean, with different lines. When I find some of those cells, I should return something like: CN, MA, TH I tried to build a routine to get it, but I cant manage to detect return character. I ...

As far as it seemed there was no option to solve this via Datastage, I decided to write a macro to be executed as the Excel was opened, so it was automatic and transparent for the user. The macro is this: Private Sub Workbook_Open() Sheets("Mailing4").Activate Dim i As Integer i = 2 Do Whi...

gateleys wrote: '=B':@INROWNUMBER:'+1' :CHAR(13)

hehehe, thanks a lot for your answer, but I must confess: I already tried
and tried also with char(13):char(10)
of course, none of them worked

Just to make things much easier, I uploaded a capture of the result I am getting after datastage process execution: http://www.cuelgalo.com/viewer.php?id=1193322093_excel_formulas.JPG As you can see, third column are formulas that would show same value that column B. But what they are showing, is fo...

No such luck, with DataStage you can only add values to excel, not formula's. Thanks ogmios, I was afraid to get this answer I don't understand what you want to do finally. But it seems to me, that you have not yet thought about the advantages and sense of each tool. Maybe, that when you tell why y...

Hello everybody, I am working with server job, reading and writing to Excel sheets via ODBC. But we are having problems with formules. Typical excample would be to give cells in column C the value of column B plus 3: C =B1+1 =B2+1 =B3+1 and so on. But when we deploy this column in datastage transfor...

Hello mates I am trying to install Information Server on a "clean" machine (just after having installed XP), but with repository on a different machine on the same network, and on SQL Server 2005 instead DB2. Following installation notes, I placed 'Microsoft SQL Server 2005 JDBC Driver' on...

I answer myself, so that other people can obtain help if needed

Problem was with 'admin' user, which in my operative system, was not defined as 'password never expires'. As result, obviously, the password was expired

I hope this can be helpful for other people

Hello everybody Just my first post, and I am already reporting problems :D I do have version 8.x installed on a desktop computer. I have been working perfectly until today. I just switched on my computer, waited all services to be up, and tried log in Datastage Client, when I got this error message:...