DSXchange

You said "hexadecimal code of 32 bits" bits are binary on or off. I guess you meant to say 32 bytes.

TPM appears to be illegal in Kazakhstan. Please file a TPS report on the same.

Are you using generated SQL or custom user-defined SQL? What is the actual SQL statement being used? Does it fail every time, sometimes, only when row count is greater than zero, etc.?

I'm on 8.7.0.0 on a Unix server as well and have not faced that problem on the same stage or any other Connector stage. I'll keep my fingers crossed! Have you checked if the problem happens across multiple clients or not? If not, your client install got messed up. Run the ISALite health check on you...

Of course you can save the Word file as a txt or similar format to begin with then read it without much effort.

Is the newer docx format any easier to work with? Is it XML based?

What about the MS OLD DB stage, would it help or not?

Need more info... how to access it (from the web, via FTP, etc.)? Is the file encrypted and if so, with what?

U can do it!

I always wanted to say that...

Well, I must quote from the docs, as I'm not making this stuff up... The FTP Enterprise stage allows you to "specify multiple URIs." "You can also use a wildcard character to retrieve multiple files." It also has an Open command option. I have used that to change the FTP mode, fo...

I don't have Cognos, but I know to search Cognos docs rather than BG docs for this answer. Try this link as it has steps for Cognos 10: http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_cra.10.1.0.doc%2Fug_cra_id10451Configure_Business_Glossary.html U c...

The IN clause is rather SQL-ish, whereas the Transformer stage does not directly support SQL statements like a database stage does. You can check like this: If (to_transf.COUNTRYCODE="US" Or to_transf.COUNTRYCODE="CA") And (to_transf.COUNTRY_CODE="US" Or to_transf.COUNT...

For 8.5 server components on Windows platform, only Windows Server 2003 and Windows Server 2008 are supported. You may think you have a working version on XP, but I would bet you just haven't hit problems on it yet. I bet the client tier works OK!

Here are a few related tech notes: --- IBM InfoSphere DataStage Server FTP stage is FTPing one blank record if the input file is empty. "...for empty lines, these characters also get added. To avoid this, set "FTP Plugin > Inputs > Omit Last New Line" = Yes. This will not add the '\n'...

I even searched for IsValidDecimal() but i didn't find any such function in 8.1. Is there any function to check the scale in decimal values. Version 8.7 includes the following IsValid* functions under the type conversion category. I don't know what version each function was first introduced, so if ...

Yes, I'm familiar with that topic. That could certainly be the cause. You don't know until you try upgrading your DataDirect drivers, or try the same job and same SQL into a supported version of SQL Server based on your driver version...

viewtopic.php?t=145041

For example, "MinutesFromTime" is just for minute and it should be converted by hours + minutes... Also, catering for cross-date transaction is needed. If you use the SecondsSinceFromTimestamp() function that I mentioned above, then I think you can avoid doing it "the hard way" ...