DSXchange

Your mainframe data are probably encoded using EBCDIC. How does it arrive?

The Euro symbol is a perfectly valid character. Similarly accented characters are perfectly valid. Verify with your business whether they want valid characters to be removed. If they do, then you can use the Convert() function.

Just out of curiosity, try it using an Oracle Connector stage.

Welcome aboard. First, please don't send private emails with exactly the same question as you've posted. It wastes our time, which is annoying. WTX is now in a completely different brand within IBM, so we're not really au fait with it any more. However, I suspect that redistributing training or any ...

You can get a list of process ids with the following command. $DSHOME/bin/list_readu | grep DS.ADMIN | grep <<projectname>> Then you could step through that list using something like ps to get the user names associated with those process IDs. Alternatively you could use a command like finger on the ...

I have only ever used the ODBC Connector with MySQL, so am not competent to comment on other stage types.

There is no Like operator or function in version 7.5. There is, however, a Matches operator. This uses DataStage BASIC pattern matching, in which either "..." or "0X" is the general wildcard. So a suitable expression for your stated requirement would be InLink.TheField Matches &q...

S9(16)V9(2) implies a sign, sixteen digits, a decimal place holder and two more digits, for a total of 20 characters. Therefore read this field as InLink.TheLine[1,20] Using similar logic, the other field has eight characters, therefore read this field as InLink.TheLine[21,8] Your line length is 28 ...

Not without you telling us the precise error message being generated.

Is it just you, or is it every client machine at your site?

Don't do that. Start a new thread instead, so we become aware what are YOUR operating system, version number, etc.

Does your operating system have a maximum length of a file name? I think this is a truncated name of a pipe (fifo) file. Try using shorter stage and/or link names, at least for the purpose of testing this theory.

Since this will employ the DB2 bulk loader, you will need to examine the files produced by that utility.

Try looking for StringToDate() function.

Not possible in version 8. What "issue" are you having with the Administrator client?